[Bucardo-general] Multi-master replication and sequences
Michelle Sullivan
michelle at sorbs.net
Tue Jul 14 12:18:00 UTC 2015
Federico Fanton wrote:
> Hi everyone!
>
> I'm (still) setting up multi-master replication between two nodes.
> What is the recommended way to handle sequences? I've seen posts
> saying that you should make one instance generate even numbers while
> the other should generate odd numbers, but they were quite old
> posts... Is this still the recommended way?
>
> Many thanks!
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Sequences can be replicated but if you're going to have concurrent
inserts into both DBs you probably should go with the offset sequences
or do as I did add a 'server ID' to the pks and not worry about
replicating the sequences.
Regards,
Michelle
--
Michelle Sullivan
http://www.mhix.org/
More information about the Bucardo-general
mailing list