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
