Re: BDR global sequences in two machine failover

[Giovanni Maruzzelli <gmaruzz@xxxxxxxxx>]

Thanks again and more Craig

-giovanni

On Tue, Sep 8, 2015 at 8:31 AM, Craig Ringer <craig@xxxxxxxxxxxxxxx> wrote:

On 7 September 2015 at 20:56, Giovanni Maruzzelli <gmaruzz@xxxxxxxxx> wrote:

> If I do not use global sequences, and I use uuid as primary keys, would BDR
> be a correct choice?

For something like a VoIP service where eventual consistency is
usually OK and geographic redundancy with latency tolerance and
partition tolerance is needed, yes, it could make a lot of sense.

You could use UUID keys or use normal sequences with different offsets
on the nodes. UUID will probably be easier to manage.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

--

Sincerely,

Giovanni Maruzzelli
Cell : +39-347-2665618