[Bucardo-general] Replication problems? data overwritten?

[eric machine]

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: 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)
> 
> Regards,
> 
> -- 
> Michelle Sullivan
> http://www.mhix.org/
> 
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130826/a13734dd/attachment.html>