From: Stephen Frost <sfrost@snowman.net>
To: Dhandapani Shanmugam <postgresql95@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-general@postgresql.org
Subject: Re: PostgreSQL Active-Active
Date: Tue, 6 Feb 2018 06:12:00 -0500
Message-ID: <20180206111200.GH2416@tamriel.snowman.net> (raw)
In-Reply-To: <CAAj4MFGjrtpruHsyw9TjXyWH72B0cfiBDNJpqMLsAUuHc8TGhw@mail.gmail.com>
References: <CAAj4MFGjrtpruHsyw9TjXyWH72B0cfiBDNJpqMLsAUuHc8TGhw@mail.gmail.com>
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
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, postgresql95@gmail.com, pgsql-general@postgresql.org
Subject: Re: PostgreSQL Active-Active
In-Reply-To: <20180206111200.GH2416@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox