[Bucardo-general] Replication problems? data overwritten?
eric.machine at hotmail.com
Mon Aug 26 15:27:41 UTC 2013
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: michelle at sorbs.net
> Subject: Re: [Bucardo-general] Replication problems? data overwritten?
> To: eric.machine at hotmail.com
> CC: bucardo-general at bucardo.org
> 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)
> Michelle Sullivan
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general