From: jasoninmel <jasoninmel+1@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres - Replication
Date: Thu, 16 Mar 2017 20:34:02 -0700 (MST)
Message-ID: <1489721642262-5950175.post@n3.nabble.com> (raw)
In-Reply-To: <1489721413358-5950172.post@n3.nabble.com>
References: <1489553982608-5949678.post@n3.nabble.com>
<1398211489576882@web5g.yandex.ru>
<1489721413358-5950172.post@n3.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Here is bit more background of the work I've done and issues around them.
What I'm looking for is an option to scale the solution to multi site
configuration where two different sites located in different geographical
locations to be able to maintain data in sync.
Currently I'm using synchronous streaming replication and one option I've
evaluated is cascading replication. Issues or concerns so far I have with
this setup are;
1. Only supports async replication
2. Automatic failover script I have built (have been using for several years
now without an issue) would 3. have to be enhanced to be intelligent to
switch to new master in primary site in the event primary fails.
4. All the standby servers including cascading standby would not allow
writes.
Happy to understand if there are implementations done by an expert in this
forum with solutions for these concerns.
Please note that I'm open for any other replication method that would allow
better scalability. One of the best option would be to have Multi-master
setup though I haven't seen any documentation around the support for such
capability by Postgres.
Thanks,
Jason
--
View this message in context: http://www.postgresql-archive.org/Postgres-Replication-tp5949678p5950175.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: jasoninmel+1@gmail.com
Subject: Re: Postgres - Replication
In-Reply-To: <1489721642262-5950175.post@n3.nabble.com>
* 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