mysql 主备切换_MySQL 主备库切换记录

旧主库：

切换前将主库的表上锁，防止切换期间数据写到主库

mysql>flush tables with read lock;

旧备库：

mysql> show processlist ;

Slave has read all relay log; waiting for the slave I/O thread to update it

mysql> show slave status \G

旧主库：

mysql> show processlist ;

Master has sent all binlog to slave; waiting for binlog to be updated

旧从库

mysql> STOP SLAVE IO_THREAD;

mysql> SHOW PROCESSLIST;

确保状态为：has read all relay log

旧主库：

mysql> show master status

旧从库变主库

mysql>STOP SLAVE;

mysql> RESET MASTER;

mysql> RESET SLAVE;

mysql> show master status \G

关闭旧主库

/etc/init.d/mysql stop

待主库应用切到备库，关闭原主库的表lock状态

unlock tables;

从库变主库

mysql> RESET MASTER;

mysql> RESET SLAVE;