MySQL Forums
Forum List  »  Replication

Switch Slave to Master / Master to Slave
Posted by: S N
Date: June 27, 2005 10:24AM

Hi,

I am in the midst of setting up Replication on our site.

If the master server crashes I want the site to switch to the slave server. Therefore, I would need the slave server to switch and be the Master and the Master to switch and be the slave, so that the updates that are made on the site while the slave server is acting as the site's mysql server will be replicated back to the original master's server. Both servers are running in Logging mode.

Is that clear?

I need to know if I would
a) have to run the entire replication on the slave server. (flushing the tables...)
b) do anything more than to a change master to... on the original master server...

I have not seen any information on this, and it would really be a great help if someone has dealt with this, and can clue me in.

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Switch Slave to Master / Master to Slave
9143
S N
June 27, 2005 10:24AM


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.