Re: BDR global sequences in two machine failover

Поиск
Список
Период
Сортировка
От Giovanni Maruzzelli
Тема Re: BDR global sequences in two machine failover
Дата
Msg-id CALXCt0oAE7nJ8KGrF9=3Mf8yBAw_iwnZgx1W0fVUBAYtKS5VFw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BDR global sequences in two machine failover  (Craig Ringer <craig@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: bdr admin role
Следующее
От: Ramesh T
Дата:
Сообщение: view