|
tarted, pid: 6361. Check tmp log /var/log/masterha/manager/mysql-mha03_3306_20150723145922.log if it takes time..
Thu Jul 23 14:59:25 2015 - [info]
Thu Jul 23 14:59:25 2015 - [info] Log messages from mysql-mha03 ...
Thu Jul 23 14:59:25 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] Sending binlog..
Thu Jul 23 14:59:24 2015 - [info] scp from local:/var/log/masterha/manager/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog to root@mysql-mha03:/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog succeeded.
Thu Jul 23 14:59:24 2015 - [info] Starting recovery on mysql-mha03(192.168.8.8:3306)..
Thu Jul 23 14:59:24 2015 - [info] Generating diffs succeeded.
Thu Jul 23 14:59:24 2015 - [info] Waiting until all relay logs are applied.
Thu Jul 23 14:59:24 2015 - [info] done.
Thu Jul 23 14:59:24 2015 - [info] Getting slave status..
Thu Jul 23 14:59:24 2015 - [info] This slave(mysql-mha03)'s Exec_Master_Log_Pos equals to Read_Master_Log_Pos(mysql-bin.000014:107). No need to recover from Exec_Master_Log_Pos.
Thu Jul 23 14:59:24 2015 - [info] Connecting to the target slave host mysql-mha03, running recover script..
Thu Jul 23 14:59:24 2015 - [info] Executing command: apply_diff_relay_logs --command=apply --slave_user='root' --slave_host=mysql-mha03 --slave_ip=192.168.8.8 --slave_port=3306 --apply_files=/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog --workdir=/var/log/masterha/node --target_version=5.5.43-log --timestamp=20150723145922 --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56 --slave_pass=xxx
Thu Jul 23 14:59:24 2015 - [info]
Applying differential binary/relay log files /var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog on mysql-mha03:3306. This may take long time...
Applying log files succeeded.
Thu Jul 23 14:59:24 2015 - [info] All relay logs were successfully applied.
Thu Jul 23 14:59:24 2015 - [info] Resetting slave mysql-mha03(192.168.8.8:3306) and starting replication from the new master mysql-mha01(192.168.8.6:3306)..
Thu Jul 23 14:59:24 2015 - [info] Executed CHANGE MASTER.
Thu Jul 23 14:59:25 2015 - [info] Slave started.
Thu Jul 23 14:59:25 2015 - [info] End of log messages from mysql-mha03.
Thu Jul 23 14:59:25 2015 - [info] -- Slave recovery on host mysql-mha03(192.168.8.8:3306) succeeded.
Thu Jul 23 14:59:25 2015 - [info] All new slave servers recovered successfully.
Thu Jul 23 14:59:25 2015 - [info]
Thu Jul 23 14:59:25 2015 - [info] * Phase 5: New master cleanup phase..
Thu Jul 23 14:59:25 2015 - [info]
Thu Jul 23 14:59:25 2015 - [info] Resetting slave info on the new master..
Thu Jul 23 14:59:25 2015 - [info] mysql-mha01: Resetting slave info succeeded.
Thu Jul 23 14:59:25 2015 - [info] Master failover to mysql-mha01(192.168.8.6:3306) completed successfully.
Thu Jul 23 14:59:25 2015 - [info]
----- Failover Report -----
MHAmanager: MySQL Master failover mysql-mha02(192.168.8.7:3306) to mysql-mha01(192.168.8.6:3306) succeeded
Master mysql-mha02(192.168.8.7:3306) is down!
Check MHA Manager logs at mysql-mha03:/var/log/masterha/manager.log for details.
Started automated(non-interactive) failover.
The latest slave mysql-mha01(192.168.8.6:3306) has all relay logs for recovery.
Selected mysql-mha01(192.168.8.6:3306) as |