Mon Apr 20 14:30:22 2015 - [info]? vdbsrv2(192.168.1.7:3306)
Mon Apr 20 14:30:22 2015 - [info]? vdbsrv3(192.168.1.8:3306)
Mon Apr 20 14:30:22 2015 - [info] Alive Slaves:
Mon Apr 20 14:30:22 2015 - [info]? vdbsrv2(192.168.1.7:3306)? Version=5.6.22-log (oldest major version between slaves) log-bin:enabled
Mon Apr 20 14:30:22 2015 - [info]? ? Replicating from 192.168.1.6(192.168.1.6:3306)
Mon Apr 20 14:30:22 2015 - [info]? vdbsrv3(192.168.1.8:3306)? Version=5.6.22-log (oldest major version between slaves) log-bin:enabled
Mon Apr 20 14:30:22 2015 - [info]? ? Replicating from 192.168.1.6(192.168.1.6:3306)
Mon Apr 20 14:30:22 2015 - [info] Starting Non-GTID based failover.
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] ** Phase 1: Configuration Check Phase completed.
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] * Phase 2: Dead Master Shutdown Phase.. ###隔离master server
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] Forcing shutdown so that applications never connect to the current master..
Mon Apr 20 14:30:22 2015 - [info] Executing master IP deactivation script:
Mon Apr 20 14:30:22 2015 - [info]? /tmp/master_ip_failover --orig_master_host=vdbsrv1 --orig_master_ip=192.168.1.6 --orig_master_port=3306
? --command=stopssh --ssh_user=root?
IN SCRIPT TEST====/sbin/ifconfig eth0:0 down==/sbin/ifconfig eth0:0 192.168.1.13/24===
To:
vdbsrv2(192.168.1.7:3306) (new master)
?+--vdbsrv3(192.168.1.8:3306)
Mon Apr 20 14:30:24 2015 - [info]
Mon Apr 20 14:30:24 2015 - [info] * Phase 3.3: New Master Diff Log Generation Phase..
Mon Apr 20 14:30:24 2015 - [info]? This server has all relay logs. No need to generate diff files from the latest slave.
Mon Apr 20 14:30:24 2015 - [info] Sending binlog..
Mon Apr 20 14:30:25 2015 - [info] scp from local:/var/log/masterha/app1/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog to
? root@vdbsrv2:/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog succeeded.
Mon Apr 20 14:30:25 2015 - [info]
Mon Apr 20 14:30:25 2015 - [info] * Phase 3.4: Master Log Apply Phase..
Mon Apr 20 14:30:25 2015 - [info]
Mon Apr 20 14:30:25 2015 - [info] *NOTICE: If any error happens from this phase, manual recovery is needed.
Mon Apr 20 14:30:25 2015 - [info] Starting recovery on vdbsrv2(192.168.1.7:3306)..
Mon Apr 20 14:30:25 2015 - [info]? Generating diffs succeeded.
Mon Apr 20 14:30:25 2015 - [info] Waiting until all relay logs are applied.
Mon Apr 20 14:30:36 2015 - [info]? done.
Mon Apr 20 14:30:36 2015 - [info] Getting slave status..
Mon Apr 20 14:30:36 2015 - [info] This slave(vdbsrv2)'s Exec_Master_Log_Pos equals to Read_Master_Log_Pos(mysql-bin.000020:315514388).
? No need to recover from Exec_Master_Log_Pos.
Mon Apr 20 14:30:36 2015 - [info] Connecting to the target slave host vdbsrv2, running recover script..? ###基于新主库Apply差量日志
Mon Apr 20 14:30:36 2015 - [info] Executing command: apply_diff_relay_logs --command=apply --slave_user='mha' --slave_host=vdbsrv2
? --slave_ip=192.168.1.7? --slave_port=3306 --apply_files=/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog
? --workdir=/var/tmp --target_version=5.6.22-log --timestamp=20150420143022 --handle_raw_binlog=1 --disable_log_bin=0
? --manager_version=0.56 --slave_pass=xxx
Mon Apr 20 14:30:36 2015 - [info]
Applying differential binary/relay log files /var/tmp/saved_master_binlog_