MySQL master-Slave Toggle Summary

1, need to promote the main from the library, stop IO thread waiting for slave data all update complete

Stop slave Io_thread

#show processlist output until you see that the status is slave have read all relay log; Waiting for the slave I/O thread to update it, indicating that the update is complete

2, need to promote the main from the library:

Stop slave Stops Slave
Reset Master
Grant Replication Slave on * * to ' repl ' @ ' 192.168.0.100 ' identified by ' 123456 ';
Reset slave All

3, other from the library

Stop slave
Change Master #到新主库
Start slave

Delete the Master.info and Relay-log.info files on the new home server

MySQL master-Slave Toggle Summary