Mon May 5 07:20:20 PDT 2008
- Previous message: [Slony1-general] Beginner question about slony - push or pull replication?
- Next message: [Slony1-general] Beginner question about slony - push or pull replication?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
"Jakub K" <slonymaillist at gmail.com> writes: > Hello, > i am new in slony and i have question, about how it's works. > Q: slony is pull or push replication? or both? When it combines "publish" and "subscribe," that implies a bit of both, though it mostly looks like "pull," as that's where the bulk of the work takes place. > I set replication using slonik, than start slon daemon on subsrciber > (sub) and publisher (pub). And now, subsrciber is asking for data > or publisher is sending data? How often? -S SYNC check interval > means how often are data asking (sub) or sending (pub) "How often" is essentially controlled by the origin; it is there that the "check interval" is used to determine if a SYNC event should be published. -> If, within the sync_interval period, replication work has arrived, the origin will generate a SYNC event. -> If the origin is quiet (e.g. - not receiving any replicable work), there will still be a SYNC event each sync_interval_timeout milliseconds. The SYNC event is published via the LISTEN/NOTIFY system in PostgreSQL, which will cause a quiescent subscriber to wake up and know it has new work to do. That's when the "pulling" takes place. -- output = reverse("moc.enworbbc" "@" "enworbbc") http://www3.sympatico.ca/cbbrowne/emacs.html Horribly wedging my very own personal machine gives me a comfortable, familiar, Lisp-machine feeling (like an old shoe), laced with that racy hint of raw, cold-boot power.
- Previous message: [Slony1-general] Beginner question about slony - push or pull replication?
- Next message: [Slony1-general] Beginner question about slony - push or pull replication?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list