Your need multi-Master?
I am assuming that will give us the highest availability with the most
dynamic failover and recovery, yes.
-----Original Message-----
From: Gilberto Castillo
Sent: Thursday, July 17, 2014 2:00 PM
To: Joseph Mays
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [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?
Your need multi-Master?
Saludos,
Gilberto Castillo
La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running
at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
