From: Jan Lentfer <Jan.Lentfer@web.de>
To: pgsql-admin@postgresql.org
Subject: Re: Maximum Availability Architecture(MAA) for PostgreSQL
Date: Wed, 08 Apr 2015 14:44:09 +0200
Message-ID: <3f89a3e198877cffec4b544a9fc0e033@imap.lan.net> (raw)
In-Reply-To: <CAFe9ZTo5z6mCH9p3eUO-wpKFcKioHdfd9OjLDj-2N6NUM_twew@mail.gmail.com>
References: <CAFe9ZTo5z6mCH9p3eUO-wpKFcKioHdfd9OjLDj-2N6NUM_twew@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Am 2015-04-08 10:22, schrieb Wei Shan:
> In the PostgreSQL world, what do you guys think would be the
> equivalent?
>
> Attached is a diagram I have thought of. Clusters of pg-pool2 used to
> load balance the connection in and for connection failover when a DB
> crashes. Between master and slave, sync replication is being used for
> zero-data-loss.
Why do you need 3 pg-pool instances? 2 instances uses watchdog should
be sufficient?
And if you plan to use sync replication you need to plan for 3
PostgreSQL Servers (a 3rd one that the sync replication can fail-over
to).
Regards,
Jan
--
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: Jan.Lentfer@web.de
Subject: Re: Maximum Availability Architecture(MAA) for PostgreSQL
In-Reply-To: <3f89a3e198877cffec4b544a9fc0e033@imap.lan.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