Re: BDR global sequences in two machine failover - Mailing list pgsql-general

From Craig Ringer
Subject Re: BDR global sequences in two machine failover
Date
Msg-id CAMsr+YEUk==PeLzdR63OXVoiOLS4xKayF_fsBbzzp-49B9Uy4w@mail.gmail.com
Whole thread Raw
In response to Re: BDR global sequences in two machine failover  (Giovanni Maruzzelli <gmaruzz@gmail.com>)
Responses Re: BDR global sequences in two machine failover
List pgsql-general
On 7 September 2015 at 20:56, Giovanni Maruzzelli <gmaruzz@gmail.com> 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


pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Re: Partitioning and constraint exclusion
Next
From: Craig Ringer
Date:
Subject: Re: bdr admin role