- 论坛徽章:
- 2
|
[root@swserver samples]# masterha_check_repl --conf=/etc/app1.cnf
Tue Aug 4 15:51:26 2015 - [info] Reading default configuration from /etc/masterha_default.cnf..
Tue Aug 4 15:51:26 2015 - [info] Reading application default configuration from /etc/app1.cnf..
Tue Aug 4 15:51:26 2015 - [info] Reading server configuration from /etc/app1.cnf..
Tue Aug 4 15:51:26 2015 - [info] MHA::MasterMonitor version 0.56.
Tue Aug 4 15:51:29 2015 - [info] GTID failover mode = 1
Tue Aug 4 15:51:29 2015 - [info] Dead Servers:
Tue Aug 4 15:51:29 2015 - [info] Alive Servers:
Tue Aug 4 15:51:29 2015 - [info] 192.168.1.201(192.168.1.201:3306)
Tue Aug 4 15:51:29 2015 - [info] 192.168.1.202(192.168.1.202:3310)
Tue Aug 4 15:51:29 2015 - [info] Alive Slaves:
Tue Aug 4 15:51:29 2015 - [info] 192.168.1.202(192.168.1.202:3310) Version=5.6.24-enterprise-commercial-advanced-log (oldest major version between slaves) log-bin:enabled
Tue Aug 4 15:51:29 2015 - [info] GTID ON
Tue Aug 4 15:51:29 2015 - [info] Replicating from 192.168.1.201(192.168.1.201:3306)
Tue Aug 4 15:51:29 2015 - [info] Primary candidate for the new Master (candidate_master is set)
Tue Aug 4 15:51:29 2015 - [info] Current Alive Master: 192.168.1.201(192.168.1.201:3306)
Tue Aug 4 15:51:29 2015 - [info] Checking slave configurations..
Tue Aug 4 15:51:29 2015 - [info] Checking replication filtering settings..
Tue Aug 4 15:51:29 2015 - [info] binlog_do_db= record,test, binlog_ignore_db= information_schema,mysql
Tue Aug 4 15:51:29 2015 - [info] Replication filtering check ok.
Tue Aug 4 15:51:29 2015 - [info] GTID (with auto-pos) is supported. Skipping all SSH and Node package checking.
Tue Aug 4 15:51:29 2015 - [info] Checking SSH publickey authentication settings on the current master..
Tue Aug 4 15:51:34 2015 - [warning] HealthCheck: Got timeout on checking SSH connection to 192.168.1.201! at /usr/share/perl5/vendor_perl/MHA/HealthCheck.pm line 342.
Tue Aug 4 15:51:34 2015 - [info]
192.168.1.201(192.168.1.201:3306) (current master)
+--192.168.1.202(192.168.1.202:3310)
Tue Aug 4 15:51:34 2015 - [info] Checking replication health on 192.168.1.202..
Tue Aug 4 15:51:34 2015 - [info] ok.
Tue Aug 4 15:51:34 2015 - [info] Checking master_ip_failover_script status:
Tue Aug 4 15:51:34 2015 - [info] /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover --command=status --ssh_user=root --orig_master_host=192.168.1.201 --orig_master_ip=192.168.1.201 --orig_master_port=3306
Bareword "FIXME_xxx" not allowed while "strict subs" in use at /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover line 93.
Execution of /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover aborted due to compilation errors.
Tue Aug 4 15:51:35 2015 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln226] Failed to get master_ip_failover_script status with return code 255:0.
Tue Aug 4 15:51:35 2015 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. at /usr/bin/masterha_check_repl line 48
Tue Aug 4 15:51:35 2015 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.
Tue Aug 4 15:51:35 2015 - [info] Got exit code 1 (Not master dead).
MySQL Replication Health is NOT OK!
[root@swserver samples]# cat /etc/app1.cnf
[server default]
user=root
password=123456
manager_workdir=/var/log/masterha/app1
manager_log=/var/log/masterha/app1/manager.log
remote_workdir=/var/log/masterha/app1
[server1]
hostname=192.168.1.201
port=3306
[server2]
hostname=192.168.1.202
port=3310
check_repl_delay=0
candidate_master=1
[root@swserver samples]# cat /etc/masterha_default.cnf
[server default]
user=root
password=123456
ssh_user=root
master_binlog_dir= /var/lib/mysql/log,/home/mysql/slave01/log
remote_workdir=/database/mha/log/masterha
repl_password=repl
repl_user=repl
secondary_check_script= masterha_secondary_check -s 192.168.1.201 -s 192.168.1.202
ping_interval=3
master_ip_failover_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover
#shutdown_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/power_manager
report_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/send_report
master_ip_online_change_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_online_change
请问是什么问题呢 |
|