|
TICE: If any error happens from this phase, manual recovery is needed.
Thu Jul 23 14:59:24 2015 - [info] Starting recovery on mysql-mha01(192.168.8.6: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-mha01)'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-mha01, 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-mha01 --slave_ip=192.168.8.6 --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-mha01: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] Getting new master's binlog name and position..
Thu Jul 23 14:59:24 2015 - [info] mysql-bin.000014:107
Thu Jul 23 14:59:24 2015 - [info] All other slaves should start replication from here. Statement should be: CHANGE MASTER TO MASTER_HOST='mysql-mha01 or 192.168.8.6', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000014', MASTER_LOG_POS=107, MASTER_USER='repl', MASTER_PASSWORD='xxx';
Thu Jul 23 14:59:24 2015 - [warning] master_ip_failover_script is not set. Skipping taking over new master IP address.
Thu Jul 23 14:59:24 2015 - [info] ** Finished master recovery successfully.
Thu Jul 23 14:59:24 2015 - [info] * Phase 3: Master Recovery Phase completed.
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] * Phase 4: Slaves Recovery Phase..
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] * Phase 4.1: Starting Parallel Slave Diff Log Generation Phase..
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] -- Slave diff file generation on host mysql-mha03(192.168.8.8:3306) started, pid: 6359. Check tmp log /var/log/masterha/manager/mysql-mha03_3306_20150723145922.log if it takes time..
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] Log messages from mysql-mha03 ...
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] This server has all relay logs. No need to generate diff files from the latest slave.
Thu Jul 23 14:59:24 2015 - [info] End of log messages from mysql-mha03.
Thu Jul 23 14:59:24 2015 - [info] -- mysql-mha03(192.168.8.8:3306) has the latest relay log events.
Thu Jul 23 14:59:24 2015 - [info] Generating relay diff files from the latest slave succeeded.
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] * Phase 4.2: Starting Parallel Slave Log Apply Phase..
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] -- Slave recovery on host mysql-mha03(192.168.8.8:3306) s |