Thu Feb 23 13:02:22 PST 2006
- Previous message: [Slony1-general] Wait for event before subscribing
- Next message: [Slony1-general] RFC - Migration to pgFoundry
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Thu, Feb 23, 2006 at 11:00:49AM -0500, Christopher Browne wrote: > "Victoria Parsons" <victoria.parsons at streamshield.com> writes: > > Is it really necessary, when creating a new set and subscribing it > > that a wait for event is done after the set creation? Won't the > > requests get queued and so are guaranteed to be processed on the > > subscriber in the right order. The reason I ask is because I have a > > single set currently replicating to many slaves. I want to add a > > second set with a single table to go from the same master to all > > slaves (with the intent of eventually performing a merge set). If > > one of the slaves is temporarily down (network outage or turned > > off), I want to be able to create the set on the master and issue a > > subscribe set to all nodes, so that all the OK nodes pick it up > > straightaway and when the bad node comes back it will process create > > set, set add table, and subscribe set in the right order. By putting > > a wait for event after the create set (and add tables) I won't be > > able to subscribe any nodes until all including the bad one confirm. > > Yes, you can have extra events "queued" up... > > It basically introduces the risk that you might, if there is a problem > with the slonik submissions, queue up a series of *bad* events, and > have more complex cleanup to do if one of the early ones breaks. Hrm... are there any error codes returned from a command? Or perhaps if there was a way to tell wait to ignore certain errors. Basically, there are conditions that won't create a mess to cleanup and those that will, so it would be good if there was some way to differentiate (of course, different people will have different ideas as to what a 'mess' is...) -- Jim C. Nasby, Sr. Engineering Consultant jnasby at pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- Previous message: [Slony1-general] Wait for event before subscribing
- Next message: [Slony1-general] RFC - Migration to pgFoundry
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list