MHA安装配置 - 数据库编程

emporary relay log file is /var/lib/mysql/mysql-mha03-relay-bin.000005 Testing mysql connection and privileges.. done. Testing mysqlbinlog output.. done. Cleaning up test file(s).. done. Thu Jul 23 14:40:30 2015 - [info] Slaves settings check done. Thu Jul 23 14:40:30 2015 - [info] mysql-mha02(192.168.8.7:3306) (current master) +--mysql-mha01(192.168.8.6:3306) +--mysql-mha03(192.168.8.8:3306) Thu Jul 23 14:40:30 2015 - [info] Checking replication health on mysql-mha01.. Thu Jul 23 14:40:30 2015 - [info] ok. Thu Jul 23 14:40:30 2015 - [info] Checking replication health on mysql-mha03.. Thu Jul 23 14:40:30 2015 - [info] ok. Thu Jul 23 14:40:30 2015 - [warning] master_ip_failover_script is not defined. Thu Jul 23 14:40:30 2015 - [warning] shutdown_script is not defined. Thu Jul 23 14:40:30 2015 - [info] Got exit code 0 (Not master dead). MySQL Replication Health is OK.
启动mha manager

[root@mysql-mha03 ~]# nohup masterha_manager --conf=/etc/MHA/MHAmanager.conf &
[1] 5552

查看启动日志

Thu Jul 23 14:49:01 2015 - [info] MHA::MasterMonitor version 0.56.
Thu Jul 23 14:49:01 2015 - [info] GTID failover mode = 0
Thu Jul 23 14:49:01 2015 - [info] Dead Servers:
Thu Jul 23 14:49:01 2015 - [info] Alive Servers:
Thu Jul 23 14:49:01 2015 - [info]   mysql-mha01(192.168.8.6:3306)
Thu Jul 23 14:49:01 2015 - [info]   mysql-mha02(192.168.8.7:3306)
Thu Jul 23 14:49:01 2015 - [info]   mysql-mha03(192.168.8.8:3306)
Thu Jul 23 14:49:01 2015 - [info] Alive Slaves:
Thu Jul 23 14:49:01 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:49:01 2015 - [info]     Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:49:01 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:49:01 2015 - [info]     Replicating from 192.168.8.7(192.168.8.7:3306)
Thu Jul 23 14:49:01 2015 - [info] Current Alive Master: mysql-mha02(192.168.8.7:3306)
Thu Jul 23 14:49:01 2015 - [info] Checking slave configurations..
Thu Jul 23 14:49:01 2015 - [info]  read_only=1 is not set on slave mysql-mha01(192.168.8.6:3306).
Thu Jul 23 14:49:01 2015 - [info]  read_only=1 is not set on slave mysql-mha03(192.168.8.8:3306).
Thu Jul 23 14:49:01 2015 - [info] Checking replication filtering settings..
Thu Jul 23 14:49:01 2015 - [info]  binlog_do_db= , binlog_ignore_db= 
Thu Jul 23 14:49:01 2015 - [info]  Replication filtering check ok.
Thu Jul 23 14:49:01 2015 - [info] GTID (with auto-pos) is not supported
Thu Jul 23 14:49:01 2015 - [info] Starting SSH connection tests..
Thu Jul 23 14:49:02 2015 - [info] All SSH connection tests passed successfully.
Thu Jul 23 14:49:02 2015 - [info] Checking MHA Node version..
Thu Jul 23 14:49:03 2015 - [info]  Version check ok.
Thu Jul 23 14:49:03 2015 - [info] Checking SSH publickey authentication settings on the current master..
Thu Jul 23 14:49:03 2015 - [info] HealthCheck: SSH to mysql-mha02 is reachable.
Thu Jul 23 14:49:03 2015 - [info] Master MHA Node version is 0.56.
Thu Jul 23 14:49:03 2015 - [info] Checking recovery script configurations on mysql-mha02(192.168.8.7:3306)..
Thu Jul 23 14:49:03 2015 - [info]   Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/var/lib/mysql/logs --output_file=/var/log/masterha/node/save_binary_logs_test --manager_version=0.56 --start_file=mysq

MHA安装配置(五)