07) completed on mysql-mha03(192.168.8.8:3306). Executed 0 events.
Thu Jul 23 15:29:59 2015 - [info] done.
Thu Jul 23 15:29:59 2015 - [info] Resetting slave mysql-mha03(192.168.8.8:3306) and starting replication from the new master mysql-mha02(192.168.8.7:3306)..
Thu Jul 23 15:29:59 2015 - [info] Executed CHANGE MASTER.
Thu Jul 23 15:29:59 2015 - [info] Slave started.
Thu Jul 23 15:29:59 2015 - [info] End of log messages from mysql-mha03 ...
Thu Jul 23 15:29:59 2015 - [info]
Thu Jul 23 15:29:59 2015 - [info] -- Slave switch on host mysql-mha03(192.168.8.8:3306) succeeded.
Thu Jul 23 15:29:59 2015 - [info] Unlocking all tables on the orig master:
Thu Jul 23 15:29:59 2015 - [info] Executing UNLOCK TABLES..
Thu Jul 23 15:29:59 2015 - [info] ok.
Thu Jul 23 15:29:59 2015 - [info] All new slave servers switched successfully.
Thu Jul 23 15:29:59 2015 - [info]
Thu Jul 23 15:29:59 2015 - [info] * Phase 5: New master cleanup phase..
Thu Jul 23 15:29:59 2015 - [info]
Thu Jul 23 15:29:59 2015 - [info] mysql-mha02: Resetting slave info succeeded.
Thu Jul 23 15:29:59 2015 - [info] Switching master to mysql-mha02(192.168.8.7:3306) completed successfully. 查看mysql-mysql03节点,已经成功切换到mysql-mha02为master
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.8.7
Master_User: repl
Master_Port: 3306
Connect_Retry: 20
Master_Log_File: mysql-bin.000015
Read_Master_Log_Pos: 107
Relay_Log_File: mysql-mha03-relay-bin.000002
Relay_Log_Pos: 253
Relay_Master_Log_File: mysql-bin.000015
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: