MySQL Forums
Forum List  »  Replication

Dual Master and Dual Slave
Posted by: Alvin Chang
Date: August 04, 2005 01:08PM

We are in the process of setting up a set of high volume MySQL servers. and the configuration that we have chosen is a Dual master replication model, each with its own slave. ie. a total of 4 computers with this configuration

C<-----A<----->B----->D

We have chosen this so that if one master fails we can easily bring the slave forward to take its place.

However, we do have a question with bringing a Slave up to replace a dead master (ie. if A dies we bring C up to the dual master configuration with B)

Is there any way to bring C up as a replacement master WITHOUT stopping mysql or locking the tables?

Let me know.. Thanks for your help upfront.

Options: ReplyQuote


Subject
Views
Written By
Posted
Dual Master and Dual Slave
3894
August 04, 2005 01:08PM
1991
August 23, 2005 12:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.