[Bucardo-general] bucardo 5 master-master sequence odd/even?

Greg Sabino Mullane greg at endpoint.com
Sat Aug 23 18:24:57 UTC 2014


On Thu, Aug 21, 2014 at 11:34:28AM -0400, Jonathan Brinkman wrote:
> Greetings
> When using bucardo4 with swap syncs we were instructed to set each side of
> the swap to use dissimilar primary key ranges so that the swap would never
> create a conflict. Like Master-A uses even keys and Master-B uses odd keys
> (Increment 2).
> Do we still need to do that with bucardo5 in a Master-Master sync?

Yes, that is still a best pracice.

> We are seeing primary key conflicts when Master-B creates a new record and
> apparently isn't having its sequence updated properly when Master-A
> previously created a record (and used that primary key already).

I'm not following here - are A and B not creating odd and even 
primary keys? Are the sequences based on the primary keys that 
Bucardo is using?

-- 
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/20140823/2a9f01a1/attachment.sig>


More information about the Bucardo-general mailing list