[Bucardo-general] Replication problems? data overwritten?

[eric machine]

It works :) Thanks so much :)

> Date: Mon, 26 Aug 2013 17:32:41 +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,
> >
> > 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.
> 
> To do that you need 3 syncs I think:
> 
> bucardo install
> bucardo add database dbbranch1 host=192.168.56.12 dbname=branch1
> bucardo add database dbbranch2 host=192.168.56.13 dbname=branch2
> bucardo add database dbbranch3 host=192.168.56.14 dbname=branch3
> bucardo add database dbhq host=192.168.56.11 dbname=dbhq
> bucardo add all tables db=dbhq -T nopktable herd=therd
> bucardo add dbgroup tgroup1 dbbranch1:source dbhq:target
> bucardo add dbgroup tgroup2 dbbranch2:source dbhq:target
> bucardo add dbgroup tgroup3 dbbranch3:source dbhq:target
> bucardo add sync foobar1 herd=therd dbs=tgroup1 ping=false autokick=0
> checktime=300
> bucardo add sync foobar2 herd=therd dbs=tgroup2 ping=false autokick=0
> checktime=300
> bucardo add sync foobar3 herd=therd dbs=tgroup3 ping=false autokick=0
> checktime=300
> bucardo validate foobar1
> bucardo validate foobar2
> bucardo validate foobar3
> bucardo start
> bucardo kick foobar1
> bucardo kick foobar2
> bucardo kick foobar3
> bucardo status  <--- note this won't stop 'no rows found, infact it
> might cause it if the tables haven't had any updates since the last sync.
> 
> bucardo update sync foobar1 autokick=1
> bucardo update sync foobar2 autokick=1
> bucardo update sync foobar3 autokick=1
> bucardo reload config
> 
> -- 
> Michelle Sullivan
> http://www.mhix.org/
> 
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130826/fbf5baec/attachment.html>