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

From Giovanni Maruzzelli
Subject Re: BDR global sequences in two machine failover
Date
Msg-id CALXCt0oAE7nJ8KGrF9=3Mf8yBAw_iwnZgx1W0fVUBAYtKS5VFw@mail.gmail.com
Whole thread Raw
In response to Re: BDR global sequences in two machine failover  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-general
Thanks again and more Craig

-giovanni


On Tue, Sep 8, 2015 at 8:31 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
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



--
Sincerely,

Giovanni Maruzzelli
Cell : +39-347-2665618

pgsql-general by date:

Previous
From: Ray Stell
Date:
Subject: Re: bdr admin role
Next
From: Ramesh T
Date:
Subject: view