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