MHA自动切换步骤及过程剖析(六)
0 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] Checking slave configurations..
Mon Apr 20 14:30:22 2015 - [info] read_only=1 is not set on slave vdbsrv2(192.168.1.7:3306).
Mon Apr 20 14:30:22 2015 - [info] Checking replication filtering settings..
Mon Apr 20 14:30:22 2015 - [info] Replication filtering check ok.
Mon Apr 20 14:30:22 2015 - [info] Master is down!
Mon Apr 20 14:30:22 2015 - [info] Terminating monitoring script.
Mon Apr 20 14:30:22 2015 - [info] Got exit code 20 (Master dead).
Mon Apr 20 14:30:22 2015 - [info] MHA::MasterFailover version 0.56.
Mon Apr 20 14:30:22 2015 - [info] Starting master failover.
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] * Phase 1: Configuration Check Phase..
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] GTID failover mode = 0
Mon Apr 20 14:30:22 2015 - [info] Dead Servers:
Mon Apr 20 14:30:22 2015 - [info] vdbsrv1(192.168.1.6:3306)
Mon Apr 20 14:30:22 2015 - [info] Checking master reachability via MySQL(double check)...
Mon Apr 20 14:30:22 2015 - [info] ok.
Mon Apr 20 14:30:22 2015 - [info] Alive Servers:
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===
Disabling the VIP on old master: vdbsrv1
Mon Apr 20 14:30:22 2015 - [info] done.
Mon Apr 20 14:30:22 2015 - [warning] shutdown_script is not set. Skipping explicit shutting down of the dead master.
Mon Apr 20 14:30:22 2015 - [info] * Phase 2: Dead Master Shutdown Phase completed.
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] * Phase 3: Master Recovery Phase..
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] * Phase 3.1: Getting Latest Slaves Phase..
Mon Apr 20 14:30:22 2015 - [info]
Mon Apr 20 14:30:22 2015 - [info] The latest binary log file/position on all slaves is mysql-bin.000020:315514388
Mon Apr 20 14: