It works :) Thanks so much :)
> Date: Mon, 26 Aug 2013 17:32:41 +0200 > From: [email protected] > Subject: Re: [Bucardo-general] Replication problems? data overwritten? > To: [email protected] > CC: [email protected] > > 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/ >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
