Mysql master-slave server switch, mysql master-slave

Mysql master-slave server switch, mysql master-slave
Switch from the mysql server to the master server:


The procedure is as follows:


1. confirm that all synchronization operations have been completed on the slave server:


 
Stop slave io_thread
Show processlist
 
The status is xxx has read all relay log, indicating that the update is complete.


2. Stop the slave server slave Service


Stop slave


3. Switch the slave server to the master server:


 
Reset master


Complete the switchover.


PS: If the read only option is set on the slave server, remove this parameter and restart the database.