pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedActive/Active clustering in postgres
12+ messages / 10 participants
[nested] [flat]
* Active/Active clustering in postgres
@ 2014-11-26 10:36 Postgres India <pgbugindia@gmail.com>
2014-11-26 11:00 ` Re: Active/Active clustering in postgres Jan Lentfer <Jan.Lentfer@web.de>
2014-11-26 17:20 ` Re: Active/Active clustering in postgres John R Pierce <pierce@hogranch.com>
2014-11-26 18:09 ` Re: Active/Active clustering in postgres Leonardo Carneiro <chesterman86@gmail.com>
0 siblings, 3 replies; 12+ messages in thread
From: Postgres India @ 2014-11-26 10:36 UTC (permalink / raw)
To: " <pgsql-general@postgresql.org>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active/Active clustering in postgres
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
@ 2014-11-26 11:00 ` Jan Lentfer <Jan.Lentfer@web.de>
2 siblings, 0 replies; 12+ messages in thread
From: Jan Lentfer @ 2014-11-26 11:00 UTC (permalink / raw)
To: Postgres India <pgbugindia@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active/Active clustering in postgres
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
@ 2014-11-26 17:20 ` John R Pierce <pierce@hogranch.com>
2014-11-26 18:25 ` Re: Active/Active clustering in postgres Suzuki Hironobu <hironobu@interdb.jp>
2 siblings, 1 reply; 12+ messages in thread
From: John R Pierce @ 2014-11-26 17:20 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active/Active clustering in postgres
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
2014-11-26 17:20 ` Re: Active/Active clustering in postgres John R Pierce <pierce@hogranch.com>
@ 2014-11-26 18:25 ` Suzuki Hironobu <hironobu@interdb.jp>
2014-11-26 18:37 ` Re: Active/Active clustering in postgres Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 12+ messages in thread
From: Suzuki Hironobu @ 2014-11-26 18:25 UTC (permalink / raw)
To: pgsql-general@postgresql.org
(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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active/Active clustering in postgres
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
2014-11-26 17:20 ` Re: Active/Active clustering in postgres John R Pierce <pierce@hogranch.com>
2014-11-26 18:25 ` Re: Active/Active clustering in postgres Suzuki Hironobu <hironobu@interdb.jp>
@ 2014-11-26 18:37 ` Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 12+ messages in thread
From: Stephen Frost @ 2014-11-26 18:37 UTC (permalink / raw)
To: Suzuki Hironobu <hironobu@interdb.jp>; +Cc: pgsql-general@postgresql.org
* 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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active/Active clustering in postgres
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
@ 2014-11-26 18:09 ` Leonardo Carneiro <chesterman86@gmail.com>
2014-11-26 19:19 ` Re: Active/Active clustering in postgres Greg Spiegelberg <gspiegelberg@gmail.com>
2 siblings, 1 reply; 12+ messages in thread
From: Leonardo Carneiro @ 2014-11-26 18:09 UTC (permalink / raw)
To: Postgres India <pgbugindia@gmail.com>; +Cc: " <pgsql-general@postgresql.org>; pgsql-admin
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:
> 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
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active/Active clustering in postgres
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
2014-11-26 18:09 ` Re: Active/Active clustering in postgres Leonardo Carneiro <chesterman86@gmail.com>
@ 2014-11-26 19:19 ` Greg Spiegelberg <gspiegelberg@gmail.com>
2014-11-26 19:34 ` Re: [ADMIN] Active/Active clustering in postgres Doiron, Daniel <DoironD@advisory.com>
0 siblings, 1 reply; 12+ messages in thread
From: Greg Spiegelberg @ 2014-11-26 19:19 UTC (permalink / raw)
To: Leonardo Carneiro <chesterman86@gmail.com>; +Cc: Postgres India <pgbugindia@gmail.com>; " <pgsql-general@postgresql.org>; pgsql-admin
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:
> 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:
>
>> 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
>>
>
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [ADMIN] Active/Active clustering in postgres
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
2014-11-26 18:09 ` Re: Active/Active clustering in postgres Leonardo Carneiro <chesterman86@gmail.com>
2014-11-26 19:19 ` Re: Active/Active clustering in postgres Greg Spiegelberg <gspiegelberg@gmail.com>
@ 2014-11-26 19:34 ` Doiron, Daniel <DoironD@advisory.com>
0 siblings, 0 replies; 12+ messages in thread
From: Doiron, Daniel @ 2014-11-26 19:34 UTC (permalink / raw)
To: Greg Spiegelberg <gspiegelberg@gmail.com>; Leonardo Carneiro <chesterman86@gmail.com>; +Cc: Postgres India <pgbugindia@gmail.com>; " <pgsql-general@postgresql.org>; pgsql-admin
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active-Active Clustering in Postgres
@ 2018-08-23 11:13 pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: pavan95 @ 2018-08-23 11:13 UTC (permalink / raw)
To: pgsql-admin
Hi Team,
Is it possible to set up high availability solution for postgres with
Active-Active Clustering? Please detail me in detail about the available
products/tools.
And which tool will be able to compensate my requirement(Active-Active
Clustering with 5 9's availability all the time)
Looking forward to hear from you!!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active-Active Clustering in Postgres
@ 2018-08-23 11:18 pavan95 <pavan.postgresdba@gmail.com>
2018-08-23 11:31 ` Re: Active-Active Clustering in Postgres soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: pavan95 @ 2018-08-23 11:18 UTC (permalink / raw)
To: pgsql-admin
Hi Team,
Is it possible to set up high availability solution for postgres with
Active-Active Clustering? Please detail me in detail about the available
products/tools.
And which tool will be able to compensate my requirement(Active-Active
Clustering with 5 9's availability all the time)
Looking forward to hear from you!!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active-Active Clustering in Postgres
2018-08-23 11:18 Re: Active-Active Clustering in Postgres pavan95 <pavan.postgresdba@gmail.com>
@ 2018-08-23 11:31 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-08-23 11:47 ` Re: Active-Active Clustering in Postgres pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: soumitra bhandary @ 2018-08-23 11:31 UTC (permalink / raw)
To: pavan95 <pavan.postgresdba@gmail.com>; pgsql-admin
Hi Pavan ,
Please clarify the Active - Active clustering . Are you looking for all the postgres node in the HA solution to be able to perform read /write both operation ? If so then you have to go for Postgre BDR .
Thanks
Soumitra
Postgres DBA
________________________________
From: pavan95 <pavan.postgresdba@gmail.com>
Sent: Thursday, August 23, 2018 4:48 PM
To: pgsql-admin@postgresql.org
Subject: Re: Active-Active Clustering in Postgres
Hi Team,
Is it possible to set up high availability solution for postgres with
Active-Active Clustering? Please detail me in detail about the available
products/tools.
And which tool will be able to compensate my requirement(Active-Active
Clustering with 5 9's availability all the time)
Looking forward to hear from you!!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Active-Active Clustering in Postgres
2018-08-23 11:18 Re: Active-Active Clustering in Postgres pavan95 <pavan.postgresdba@gmail.com>
2018-08-23 11:31 ` Re: Active-Active Clustering in Postgres soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2018-08-23 11:47 ` pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: pavan95 @ 2018-08-23 11:47 UTC (permalink / raw)
To: pgsql-admin
Hi Bhandary,
I'm not talking about replication, rather I want to know the best practice
in implementing clustering for postgres servers(Shared Disk clusters, Shared
Nothing clusters) which involve heartbeat/corosync, pacemaker, RHCS,
choosing RAID levels, SAN's etc!!!
Like what clustering means in other databases(for example SQL server, Oracle
RAC) I want to know how to implement the same in Postgres(may be with the
help of some tools).
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2018-08-23 11:47 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-11-26 10:36 Active/Active clustering in postgres Postgres India <pgbugindia@gmail.com>
2014-11-26 11:00 ` Jan Lentfer <Jan.Lentfer@web.de>
2014-11-26 17:20 ` John R Pierce <pierce@hogranch.com>
2014-11-26 18:25 ` Suzuki Hironobu <hironobu@interdb.jp>
2014-11-26 18:37 ` Stephen Frost <sfrost@snowman.net>
2014-11-26 18:09 ` Leonardo Carneiro <chesterman86@gmail.com>
2014-11-26 19:19 ` Greg Spiegelberg <gspiegelberg@gmail.com>
2014-11-26 19:34 ` Doiron, Daniel <DoironD@advisory.com>
2018-08-23 11:13 Re: Active-Active Clustering in Postgres pavan95 <pavan.postgresdba@gmail.com>
2018-08-23 11:18 Re: Active-Active Clustering in Postgres pavan95 <pavan.postgresdba@gmail.com>
2018-08-23 11:31 ` Re: Active-Active Clustering in Postgres soumitra bhandary <soumitra.bhandary@hotmail.com>
2018-08-23 11:47 ` Re: Active-Active Clustering in Postgres pavan95 <pavan.postgresdba@gmail.com>
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