Hi Michelle, That's clearer :) Thanks.
But yes I am looking at 3 masters and 1 slave. However I run this command below:- bucardo add dbgroup tgroup dbbranch1:source dbbranch2:source dbbranch3:source dbhq:target It should be working right? I mean all the 3 masters into dbhq only? But it's not working as I expected. How come master dbbranch2 will write to another master dbbranch1? or did I configure it wrongly? Basically I need this:- dbbranch1 -> will always replicate only to -> dbhq dbbranch2 -> will always replicate only to -> dbhq dbbranch3 -> will always replicate only to -> dbhq Any help? Thanks. > Date: Mon, 26 Aug 2013 17:22:25 +0200 > From: [email protected] > Subject: Re: [Bucardo-general] Replication problems? data overwritten? > To: [email protected] > CC: [email protected] > > eric machine wrote: > > Hi Michelle, > > > > Wow, I liked your proposed replication strategy, that's look good :) > > Thanks so so much :) > > > > > ALTER SEQUENCE $schema start with 1 INCREMENT BY 10; > > > ALTER SEQUENCE $schema start with 2 INCREMENT BY 10; > > ... > > > > By the way, few more questions to clarify further:- > > > > a) > > Because the status is only set after the first successful sync... > > >> sorry, I am not sure what do you mean by first successful sync? > > Since autokick is set to yes, shouldn't it be automatically "status = > > good" when it detects new changes (when insert new record?)? > > When you start bucardo it doesn't always perform a sync (there might not > be any changes) so 'No records found' is the appropriate status. With > Auto-Kick set when it kicks the sync (because of a detected change) the > sync will be performed. The status will be updated at the *end* of the > sync, so it will show 'No records found' until the end of the first sync. > > > > > > > b) > > > > I'm not running 5 yet - but from my understanding your config would > > indicate multimaster between dbbranch1, dbbranch2 and dbbranch3 with the > > dbhq being a slave. > > >> Yes that's correct. But for HQ, I can always create new records but > > it will never get replicated to the branches. Just I still can't > > figure out why this will happen? > > > > dbbranch2 -> HQ (correct) > > dbbranch1 -> HQ (correct) > > dbbranch2 -> dbbranch1 (not supposed to be happen, but it happens, any > > idea?) > > > > Any help? Thanks. > > MultiMaster is not 3 masters to one target, it's 3 masters between > themselves.. Consider this (my understanding of Bucardo5 is your > configuration results in the following): > > dbbranch1 <-> dbbranch2 <-> dbbranch3 > \ | / > ------------+---------- > \ > \-> dbhq > > (if my ASCII art works) > > Regards, > > -- > Michelle Sullivan > http://www.mhix.org/ >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
