Quantcast

Master to Master replication options?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Master to Master replication options?

CS_DBA
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
---------------------------------------------


--
Sent via pgsql-admin mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...