[Bucardo-general] multi-master

John Powell john.powell at emapsite.com
Tue Dec 6 13:44:55 UTC 2011


I am going to need to do multi-master replication soon, so it looks like 
I'll need to upgrade to version 5. Question.

We use haproxy to split requests evenly accross db servers, but need all 
the writes consolidated on each machine. When I have done this in the 
past with MySQL, I had machine A replicate to B, B to C and C to A, ie, 
B was a slave of A, etc, which worked well for the way MySQL does 
replication. And to avoid primary key conflicts, we create a sequence 
for each machine with a different offset starting value, eg, 1,2,3 and 
have them increment by, say, 10.

Is this a sensible way to approach the problem with bucardo 5 or is 
there a better way to achieve our aim. Should I use delta or swap.

Sorry for all the questions.


More information about the Bucardo-general mailing list