|
ger_version=0.56 --binlog_prefix=mysql-bin
Thu Jul 23 14:59:13 2015 - [info] Executing secondary network check script: masterha_secondary_check -s mysql-mha03 --user=root --master_host=mysql-mha02 --master_ip=172.16.21.13 --master_port=3306 --user=root --master_host=mysql-mha02 --master_ip=192.168.8.7 --master_port=3306 --master_user=root --master_password=123456 --ping_type=SELECT
Thu Jul 23 14:59:14 2015 - [info] HealthCheck: SSH to mysql-mha02 is reachable.
Monitoring server mysql-mha03 is reachable, Master is not reachable from mysql-mha03. OK.
Thu Jul 23 14:59:14 2015 - [info] Master is not reachable from all other monitoring servers. Failover should start.
Thu Jul 23 14:59:16 2015 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111)
Thu Jul 23 14:59:16 2015 - [warning] Connection failed 2 time(s)..
Thu Jul 23 14:59:19 2015 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111)
Thu Jul 23 14:59:19 2015 - [warning] Connection failed 3 time(s)..
Thu Jul 23 14:59:22 2015 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111)
Thu Jul 23 14:59:22 2015 - [warning] Connection failed 4 time(s)..
Thu Jul 23 14:59:22 2015 - [warning] Master is not reachable from health checker!
Thu Jul 23 14:59:22 2015 - [warning] Master mysql-mha02(192.168.8.7:3306) is not reachable!
Thu Jul 23 14:59:22 2015 - [warning] SSH is reachable.
Thu Jul 23 14:59:22 2015 - [info] Connecting to a master server failed. Reading configuration file /etc/masterha_default.cnf and /etc/MHA/MHAmanager.conf again, and trying to connect to all servers to check server status..
Thu Jul 23 14:59:22 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Thu Jul 23 14:59:22 2015 - [info] Reading application default configuration from /etc/MHA/MHAmanager.conf..
Thu Jul 23 14:59:22 2015 - [info] Reading server configuration from /etc/MHA/MHAmanager.conf..
Thu Jul 23 14:59:22 2015 - [info] GTID failover mode = 0
Thu Jul 23 14:59:22 2015 - [info] Dead Servers:
Thu Jul 23 14:59:22 2015 - [info] mysql-mha02(192.168.8.7:3306)
Thu Jul 23 14:59:22 2015 - [info] Alive Servers:
Thu Jul 23 14:59:22 2015 - [info] mysql-mha01(192.168.8.6:3306)
Thu Jul 23 14:59:22 2015 - [info] mysql-mha03(192.168.8.8:3306)
Thu Jul 23 14:59:22 2015 - [info] Alive Slaves:
Thu Jul 23 14:59:22 2015 - [info] mysql-mha01(192.168.8.6:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled
Thu Jul 23 14:59:22 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:59:22 2015 - [info] mysql-mha03(192.168.8.8:3306) Version=5.5.43-log (oldest major version between slaves) log-bin:enabled
Thu Jul 23 14:59:22 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:59:22 2015 - [info] Checking slave configurations..
Thu Jul 23 14:59:22 2015 - [info] read_only=1 is not set on slave mysql-mha01(192.168.8.6:3306).
Thu Jul 23 14:59:22 2015 - [info] read_only=1 is not set on slave mysql-mha03(192.168.8.8:3306).
Thu Jul 23 14:59:22 2015 - [info] Checking replication filtering settings..
Thu Jul 23 14:59:22 2015 - [info] Replication filtering check ok.
Thu Jul 23 14:59:22 2015 - [info] Mas |