MySQL Server Forum - Procedures to promote slave to master server?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Procedures to promote slave to master server?

charles@nospamm.com

2005-11-09, 9:23 am

What is the proper procedure for promoting a Slave into a Master
replication server?

We want to do some fail-over testing. When we tried this in the past, the
former master would not replicate. We got an error: "master and slave
have equal MySQL server ids".

The fail-over procedure includes renaming the slave and exchanging IP
addresses with the master server. We did not change the server-ids.

I haven't found any information on promoting slaves to master servers.

Sponsored Links