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

Jonathan Brinkman jb at blackskytech.com
Mon Aug 25 13:05:14 UTC 2014

When we changed to Bucardo 5.1.1 we thought master-master syncs would handle
the primary key conflict issue without the need to manually modify the
sequences to use even/odd.
Now that we have returned to using that technique, I don't expect further
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)? 
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.

-----Original Message-----
From: Greg Sabino Mullane [mailto:greg at endpoint.com] 
Sent: Saturday, August 23, 2014 2:25 PM
To: Jonathan Brinkman
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] bucardo 5 master-master sequence odd/even?

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

More information about the Bucardo-general mailing list