Re: PostgreSQL Active-Active

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: PostgreSQL Active-Active
Дата
Msg-id 20180206111200.GH2416@tamriel.snowman.net
обсуждение исходный текст
Ответ на PostgreSQL Active-Active  (Dhandapani Shanmugam <postgresql95@gmail.com>)
Ответы RE: PostgreSQL Active-Active  ("Lazaro Garcia" <lazaro3487@gmail.com>)
RE: PostgreSQL Active-Active  ("Lazaro Garcia" <lazaro3487@gmail.com>)
Список pgsql-admin
Greetings,

* Dhandapani Shanmugam (postgresql95@gmail.com) wrote:
> Do we have active-active setup in postgreSQL, like we have in oracle RAC?.
> Sorry if this question has been addressed already. What will be best open
> source HA for postgresql with zero RTO and RPO.

What you're probably looking for is a 3 (or more) node setup with
patroni, etcd, and synchronous replication.  Note that this will be a
shared-nothing architecture, avoiding the risk that something bad
happens with the storage system but requiring that the data be
replicated multiple times.  Using synchronous replication means that you
have to have the nodes all close to each other, of course, but meets the
zero RPO.  Zero RTO is just silly, but with patroni and haproxy you can
detect and failover pretty darn fast.

Thanks!

Stephen

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Dhandapani Shanmugam
Дата:
Сообщение: PostgreSQL Active-Active
Следующее
От: Samuel Teixeira Santos
Дата:
Сообщение: Re: Postgres install