Active/Active clustering in postgres

Am 2014-11-26 11:36, schrieb Postgres India:

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 can have a look at pgpool-II's integrated replication + load
balancing.

http://www.pgpool.net/mediawiki/index.php/Main_Page

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

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.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

It look's like you're searching for Postgres equivalent of Oracle RAC. I
don't know if there is any solution to do this right now in the postgres

On Wed, Nov 26, 2014 at 8:36 AM, Postgres India <pgbugindia@gmail.com>
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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-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

There is BDR (Bi-Directional Replication) from 2ndQuadrant available in 9.4.
http://2ndquadrant.com/en/resources/bdr/

-Greg

On Wed, Nov 26, 2014 at 11:09 AM, Leonardo Carneiro <chesterman86@gmail.com>
wrote:

Is BDR still in beta?

Here’s the postgres wiki with a chart:

https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Greg Spiegelberg
Sent: Wednesday, November 26, 2014 2:20 PM
To: Leonardo Carneiro
Cc: Postgres India; pgsql-general@postgresql.org >> PG-General Mailing List; [ADMIN]
Subject: Re: [ADMIN] Active/Active clustering in postgres

There is BDR (Bi-Directional Replication) from 2ndQuadrant available in 9.4.
http://2ndquadrant.com/en/resources/bdr/

-Greg

On Wed, Nov 26, 2014 at 11:09 AM, Leonardo Carneiro <chesterman86@gmail.com<mailto:chesterman86@gmail.com>> wrote:
It look's like you're searching for Postgres equivalent of Oracle RAC. I don't know if there is any solution to do this right now in the postgres

On Wed, Nov 26, 2014 at 8:36 AM, Postgres India <pgbugindia@gmail.com<mailto:pgbugindia@gmail.com>> wrote:
Hi All,

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.

Regards

Manmohan