From: CS DBA <cs_dba@consistentstate.com>
To: PG Admin <pgsql-admin@postgresql.org>
Subject: Master to Master replication options?
Date: Thu, 11 Aug 2011 08:39:39 -0600
Message-ID: <4E43E9AB.8060707@consistentstate.com> (raw)
Hi All;
I have a client that wants the following:
- 2 masters (master to master replication)
- multiple read only slaves off each master
- the ability to failover in case of a master node failure
to include re-directing the slaves off the failed master to now
point to the remaining active master
Questions:
- Is Bucardo the only viable master to master solution?
- Can I setup HOT standby's or SLONY off of a Bucardo master?
- Can I shift a slave's 'master' without a full reset?
Thanks in advance...
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
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: cs_dba@consistentstate.com
Subject: Re: Master to Master replication options?
In-Reply-To: <4E43E9AB.8060707@consistentstate.com>
* 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