MHA 自动切换步骤及过程剖析(3)

Mon Apr 20 14:27:45 2015 - [info] Checking master_ip_failover_script status:
Mon Apr 20 14:27:45 2015 - [info]  /tmp/master_ip_failover --command=status --ssh_user=root --orig_master_host=vdbsrv1
  --orig_master_ip=192.168.1.6 --orig_master_port=3306

IN SCRIPT TEST====/sbin/ifconfig eth0:0 down==/sbin/ifconfig eth0:0 192.168.1.13/24===

Checking the Status of the script.. OK
Mon Apr 20 14:27:45 2015 - [info]  OK.
Mon Apr 20 14:27:45 2015 - [warning] shutdown_script is not defined.
Mon Apr 20 14:27:45 2015 - [info] Set master ping interval 1 seconds.
Mon Apr 20 14:27:45 2015 - [warning] secondary_check_script is not defined. It is highly recommended setting it to check master
          reachability from two or more routes.
Mon Apr 20 14:27:45 2015 - [info] Starting ping health check on vdbsrv1(192.168.1.6:3306)..
Mon Apr 20 14:27:45 2015 - [info] Ping(SELECT) succeeded, waiting until MySQL doesn't respond..
Mon Apr 20 14:30:19 2015 - [warning] Got error on MySQL select ping: 2013 (Lost connection to MySQL server during query) ###侦测到错误
Mon Apr 20 14:30:19 2015 - [info] Executing SSH check script: save_binary_logs --command=test --start_pos=4 --binlog_dir=/data/mysqldata
 --output_file=/var/tmp/save_binary_logs_test --manager_version=0.56 --binlog_prefix=mysql-bin
Mon Apr 20 14:30:19 2015 - [info] HealthCheck: SSH to vdbsrv1 is reachable.
Mon Apr 20 14:30:20 2015 - [warning] Got error on MySQL connect: 2003 (Can't connect to MySQL server on '192.168.1.6' (111))
Mon Apr 20 14:30:20 2015 - [warning] Connection failed 2 time(s)..
Mon Apr 20 14:30:21 2015 - [warning] Got error on MySQL connect: 2003 (Can't connect to MySQL server on '192.168.1.6' (111))
Mon Apr 20 14:30:21 2015 - [warning] Connection failed 3 time(s)..
Mon Apr 20 14:30:22 2015 - [warning] Got error on MySQL connect: 2003 (Can't connect to MySQL server on '192.168.1.6' (111))
Mon Apr 20 14:30:22 2015 - [warning] Connection failed 4 time(s)..
Mon Apr 20 14:30:22 2015 - [warning] Master is not reachable from health checker!
Mon Apr 20 14:30:22 2015 - [warning] Master vdbsrv1(192.168.1.6:3306) is not reachable!
Mon Apr 20 14:30:22 2015 - [warning] SSH is reachable.
Mon Apr 20 14:30:22 2015 - [info] Connecting to a master server failed. Reading configuration file /etc/masterha_default.cnf and
  /etc/masterha/app1.cnf again, and trying to connect to all servers to check server status..
Mon Apr 20 14:30:22 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Mon Apr 20 14:30:22 2015 - [info] Reading application default configuration from /etc/masterha/app1.cnf..
Mon Apr 20 14:30:22 2015 - [info] Reading server configuration from /etc/masterha/app1.cnf..
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] 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] 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===

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/502301d6cd73217d0993c1b5a960d444.html