From: Joseph Mays <mays@win.net>
To: pgsql-admin@postgresql.org
Subject: Re: Pgpool-II, pgcluster, or pgbouncer?
Date: Thu, 17 Jul 2014 13:35:24 -0400
Message-ID: <A91C78C4D4684D10A104177BE2BEFED7@Gantry> (raw)
In-Reply-To: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry>
References: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
I only just now discovered postgres-xc. Is there anyone out there using it in a production environment who can comment on it?
From: Joseph Mays
Sent: Thursday, July 17, 2014 12:53 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Pgpool-II, pgcluster, or pgbouncer?
I have a site that has a postgres database server. 24 hour availability is pretty critical to them, so I want to turn it into a redundant cluster for high availability. I currently have a streaming backup server, but we want to be able to make either server capable of accepting writes in the case one fails. The problem with streaming backup is that we can promote the backup when the master fails, but when the master comes backup you basically have to rebuild the entire database and reconfigure postgres on it to either make it the master or make it into a new streaming backup. We want something that’s much more dynamic, so writes can go either direction in the event of one or the failing, and so that things will automatically resync when a failed server in the cluster comes back online.
Given these goals – pgpool-II, pgcluster, pgbouncer? Some other tool that I haven’t even considered?
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mays@win.net
Subject: Re: Pgpool-II, pgcluster, or pgbouncer?
In-Reply-To: <A91C78C4D4684D10A104177BE2BEFED7@Gantry>
References: <52E4C0ED4C424CF5BFA534D92A8534F9@Gantry> <A91C78C4D4684D10A104177BE2BEFED7@Gantry>
* 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