From: | Alexander Kukushkin <cyberdemn(at)gmail(dot)com> |
---|---|
To: | Lazaro Garcia <lazaro3487(at)gmail(dot)com> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Dhandapani Shanmugam <postgresql95(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | RE: PostgreSQL Active-Active |
Date: | 2018-02-07 16:24:03 |
Message-ID: | CAFh8B=mVbE2kCzJ_iHDdJkAr4ZFksJv+S=JFJ3Z90WZ0qYHhvQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
I would recommend to read
https://linode.com/docs/databases/postgresql/create-a-highly-available-postgresql-cluster-using-patroni-and-haproxy/
And actually we just did a 3 hours tutorial at pgconf.ru and soon we will
publish slides.
In April we will give the Patroni tutorial at postgresconf.us
On 7 Feb 2018 17:29, "Lazaro Garcia" <lazaro3487(at)gmail(dot)com> wrote:
Do you have any tutorial about patroni + ha-proxy with postgresql (what
about load balancing with this setup?)
Regards.
-----Mensaje original-----
De: Stephen Frost [mailto:sfrost(at)snowman(dot)net]
Enviado el: martes, 6 de febrero de 2018 06:12 a. m.
Para: Dhandapani Shanmugam
CC: pgsql-admin; pgsql-general(at)postgresql(dot)org
Asunto: Re: PostgreSQL Active-Active
Greetings,
* Dhandapani Shanmugam (postgresql95(at)gmail(dot)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
Regard,
Alexander Kukushkin
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Steben | 2018-02-07 16:57:35 | who can view pg_stat_activity? |
Previous Message | Lazaro Garcia | 2018-02-07 14:28:34 | RE: PostgreSQL Active-Active |
From | Date | Subject | |
---|---|---|---|
Next Message | Sargez | 2018-02-07 16:37:46 | Re: Master-Slave error: the database system is starting up |
Previous Message | David G. Johnston | 2018-02-07 14:47:05 | Re: "could not receive data from client" && "incomplete startup packet" |