[Bucardo-general] bucardo 5 master-master sequence odd/even?
Greg Sabino Mullane
greg at endpoint.com
Mon Aug 25 17:44:33 UTC 2014
On Mon, Aug 25, 2014 at 09:05:14AM -0400, Jonathan Brinkman wrote:
> But I thought the B5 upgrade meant that multi-master scenarios were handled
> internally. What if I have a sync that includes (say) 5 masters? Would I
> need to alter the sequences accordingly to avoid this primary-key conflict
> problem (INCREMENT=5)?
Yes, that would be one solution. Doesn't scale well of course, because you
are stuck with X number of servers due to the increment.
> Also I had considered using a sequence strategy where each master's sequence
> started with a different number (1-9 say), but that doesn't work if Bucardo
> is checking/modifying the sequences for MAX on each restart. And would of
> course be limited to 9 masters.
Right. If you are using tricks to have different sequences on each server,
you do NOT want Bucardo to track the sequences. A better sequence strategy
than the inrement trick would be to reserve the first two numbers for a potential
pool of 99 servers, or to simply use pre-defined ranges. As sequences can be BIGINT,
there is little danger of running out of values. This will involve setting a
different MINVALUE and MAXVALUE for each server.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140825/eafffc3a/attachment.sig>
More information about the Bucardo-general
mailing list