|
nfo] Reading server configurations from /etc/mha/app1.cnf..
Fri Aug 7 15:27:22 2015 - [info] MHA::MasterMonitor version 0.53.
Fri Aug 7 15:27:22 2015 - [info] Dead Servers:
Fri Aug 7 15:27:22 2015 - [info] Alive Servers:
Fri Aug 7 15:27:22 2015 - [info] 10.10.10.56(10.10.10.56:3306)
Fri Aug 7 15:27:22 2015 - [info] 10.10.10.57(10.10.10.57:3306)
Fri Aug 7 15:27:22 2015 - [info] 10.10.10.58(10.10.10.58:3306)
Fri Aug 7 15:27:22 2015 - [info] Alive Slaves:
Fri Aug 7 15:27:22 2015 - [info] 10.10.10.57(10.10.10.57:3306) Version=5.6.25-log (oldest major version between slaves) log-bin:enabled
Fri Aug 7 15:27:22 2015 - [info] Replicating from 10.10.10.56(10.10.10.56:3306)
Fri Aug 7 15:27:22 2015 - [info] Primary candidate for the new Master (candidate_master is set)
Fri Aug 7 15:27:22 2015 - [info] 10.10.10.58(10.10.10.58:3306) Version=5.6.25-log (oldest major version between slaves) log-bin:enabled
Fri Aug 7 15:27:22 2015 - [info] Replicating from 10.10.10.56(10.10.10.56:3306)
Fri Aug 7 15:27:22 2015 - [info] Current Alive Master: 10.10.10.56(10.10.10.56:3306)
Fri Aug 7 15:27:22 2015 - [info] Checking slave configurations..
Fri Aug 7 15:27:22 2015 - [info] Checking replication filtering settings..
Fri Aug 7 15:27:22 2015 - [info] binlog_do_db= city, binlog_ignore_db= mysql
Fri Aug 7 15:27:22 2015 - [info] Replication filtering check ok.
Fri Aug 7 15:27:22 2015 - [info] Starting SSH connection tests..
Fri Aug 7 15:27:24 2015 - [info] All SSH connection tests passed successfully.
Fri Aug 7 15:27:24 2015 - [info] Checking MHA Node version..
Fri Aug 7 15:27:24 2015 - [info] Version check ok.
Fri Aug 7 15:27:24 2015 - [info] Checking SSH publickey authentication settings on the current master..
Fri Aug 7 15:27:25 2015 - [info] HealthCheck: SSH to 10.10.10.56 is reachable.
Fri Aug 7 15:27:25 2015 - [info] Master MHA Node version is 0.53.
Fri Aug 7 15:27:25 2015 - [info] Checking recovery script configurations on the current master..
Fri Aug 7 15:27:25 2015 - [info] Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/data/mysql --output_file=/tmp/save_binary_logs_test --manager_version=0.53 --start_file=mysql-bin.000006
Fri Aug 7 15:27:25 2015 - [info] Connecting to root@10.10.10.56(10.10.10.56)..
Creating /tmp if not exists.. ok.
Checking output directory is accessible or not..
ok.
Binlog found at /data/mysql, up to mysql-bin.000006
Fri Aug 7 15:27:25 2015 - [info] Master setting check done.
Fri Aug 7 15:27:25 2015 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
Fri Aug 7 15:27:25 2015 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user=mha --slave_host=10.10.10.57 --slave_ip=10.10.10.57 --slave_port=3306 --workdir=/tmp --target_version=5.6.25-log --manager_version=0.53 --relay_log_info=/data/mysql/relay-log.info --relay_dir=/data/mysql/ --slave_pass=xxx
Fri Aug 7 15:27:25 2015 - [info] Connecting to root@10.10.10.57(10.10.10.57:1022)..
Checking slave recovery environment settings..
Opening /data/mysql/relay-log.info ... ok.
Relay log found at /data/mysql, up to net-app1b-relay-bin.000014
Temporary relay log file is /data/mysql/net-app1b-relay-bin.000014
Testing mysql connection and privileges..Warning: Using a password on the command line interface can be insecure.
done.
Testing mysql |