Procedures to promote slave to master server?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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.

Site Timeline