From: Stephen Frost <sfrost@snowman.net>
To: Suzuki Hironobu <hironobu@interdb.jp>
Cc: pgsql-general@postgresql.org
Subject: Re: Active/Active clustering in postgres
Date: Wed, 26 Nov 2014 13:37:17 -0500
Message-ID: <20141126183717.GF28859@tamriel.snowman.net> (raw)
In-Reply-To: <54761B2B.9060708@interdb.jp>
References: <CAMU5o+_FD-X4ODhY0A4qDqtczaZ_TS6b79iEP11k3zdPM5-XBw@mail.gmail.com>
<54760BD4.1020000@hogranch.com>
<54761B2B.9060708@interdb.jp>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
* Suzuki Hironobu (hironobu@interdb.jp) wrote:
> (2014/11/27 2:20), John R Pierce wrote:
> >On 11/26/2014 2:36 AM, Postgres India wrote:
> >>I am looking for PostgreSQL active/active clustering and whether
> >>PostgreSQL support any form of shared-storage clustering . Is there
> >>any methods or tools for implementing active/active clustering on
> >>Postgres supported by community or any third party tools.
> >
> >you might look into PostgreSQL-XC and -XL (-XL is a fork of -XC). both
> >of these are multi-master clusters based on postgres.
>
> In addition, XC and XL are shared-nothing DB clusters.
>
> I think that there is no multi-master shared-storage DB cluster
> based on PostgreSQL.
I'm not aware of any. It would require the equivilant of the
distributed lock management which exists in RAC (and is also what makes
RAC limited in its ability to scale..). Note that applications which
are written to use RAC are likely easier to migrate to shared-nothing
sharded database systems since they would have already had to deal with
the complications associated with determining which node to send writes
to.
If your application isn't doing that then you're very unlikely to be
using RAC in a performant manner (as it relates to write-load
distribution, specifically) and would operate just fine with a single
master and slave replicas, with appropriate systems in place to handle
failover.
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, hironobu@interdb.jp, pgsql-general@postgresql.org
Subject: Re: Active/Active clustering in postgres
In-Reply-To: <20141126183717.GF28859@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