[root@rd-mysql-test4 scripts]# vim /etc/mha/app1.cnf [root@rd-mysql-test4 scripts]# masterha_check_repl --conf=/etc/mha/app1.cnf Fri Aug 7 15:24:54 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Fri Aug 7 15:24:54 2015 - [info] Reading application default configurations from /etc/mha/app1.cnf.. Fri Aug 7 15:24:54 2015 - [info] Reading server configurations from /etc/mha/app1.cnf.. Fri Aug 7 15:24:54 2015 - [info] MHA::MasterMonitor version 0.53. Fri Aug 7 15:24:54 2015 - [info] Dead Servers: Fri Aug 7 15:24:54 2015 - [info] Alive Servers: Fri Aug 7 15:24:54 2015 - [info] 10.10.10.56(10.10.10.56:3306) Fri Aug 7 15:24:54 2015 - [info] 10.10.10.57(10.10.10.57:3306) Fri Aug 7 15:24:54 2015 - [info] 10.10.10.58(10.10.10.58:3306) Fri Aug 7 15:24:54 2015 - [info] Alive Slaves: Fri Aug 7 15:24:54 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:24:54 2015 - [info] Replicating from 10.10.10.56(10.10.10.56:3306) Fri Aug 7 15:24:54 2015 - [info] Primary candidate for the new Master (candidate_master is set) Fri Aug 7 15:24:54 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:24:54 2015 - [info] Replicating from 10.10.10.56(10.10.10.56:3306) Fri Aug 7 15:24:54 2015 - [info] Current Alive Master: 10.10.10.56(10.10.10.56:3306) Fri Aug 7 15:24:54 2015 - [info] Checking slave configurations.. Fri Aug 7 15:24:54 2015 - [info] Checking replication filtering settings.. Fri Aug 7 15:24:54 2015 - [info] binlog_do_db= city, binlog_ignore_db= mysql Fri Aug 7 15:24:54 2015 - [info] Replication filtering check ok. Fri Aug 7 15:24:54 2015 - [info] Starting SSH connection tests.. Fri Aug 7 15:24:56 2015 - [info] All SSH connection tests passed successfully. Fri Aug 7 15:24:56 2015 - [info] Checking MHA Node version.. Fri Aug 7 15:24:56 2015 - [info] Version check ok. Fri Aug 7 15:24:56 2015 - [info] Checking SSH publickey authentication settings on the current master.. Fri Aug 7 15:24:56 2015 - [info] HealthCheck: SSH to 10.10.10.56 is reachable. Fri Aug 7 15:24:57 2015 - [info] Master MHA Node version is 0.53. Fri Aug 7 15:24:57 2015 - [info] Checking recovery script configurations on the current master.. Fri Aug 7 15:24:57 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:24:57 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:24:57 2015 - [info] Master setting check done. Fri Aug 7 15:24:57 2015 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers.. Fri Aug 7 15:24:57 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=330
mysql高可用之mha(六)
- [debug] Connecting via SSH from root@10.10.10.58(10.10.10.58:1022) to root@10.10.10.57(10.10.10.57:1022)..
Fri Aug 7 15:20:12 2015 - [debug] ok.
Fri Aug 7 15:20:12 2015 - [info] All SSH connection tests passed successfully.
7.检查整个复制环境的状况