mysql高可用MHA部署全过程

g87616758

[root@mysql_slave2 conf]# masterha_check_repl --conf=/etc/mha/conf/app1.cnf　　
Sat Nov  4 00:57:03 2017 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
　　
Sat Nov  4 00:57:03 2017 - [info] Reading application default configurations from /etc/mha/conf/app1.cnf..
　　
Sat Nov  4 00:57:03 2017 - [info] Reading server configurations from /etc/mha/conf/app1.cnf..
　　
Sat Nov  4 00:57:03 2017 - [info] MHA::MasterMonitor version 0.55.
　　
Sat Nov  4 00:57:03 2017 - [info] Dead Servers:
　　
Sat Nov  4 00:57:03 2017 - [info] Alive Servers:
　　
Sat Nov  4 00:57:03 2017 - [info]   mysql_master(192.168.2.74:55555)
　　
Sat Nov  4 00:57:03 2017 - [info]   mysql_slave1(192.168.2.75:55555)
　　
Sat Nov  4 00:57:03 2017 - [info]   mysql_slave2(192.168.2.76:55555)
　　
Sat Nov  4 00:57:03 2017 - [info] Alive Slaves:
　　
Sat Nov  4 00:57:03 2017 - [info]   mysql_slave1(192.168.2.75:55555)  Version=5.5.57-log (oldest major version between slaves) log-bin:enabled
　　
Sat Nov  4 00:57:03 2017 - [info]     Replicating from 192.168.2.74(192.168.2.74:55555)
　　
Sat Nov  4 00:57:03 2017 - [info]     Primary candidate for the new Master (candidate_master is set)
　　
Sat Nov  4 00:57:03 2017 - [info]   mysql_slave2(192.168.2.76:55555)  Version=5.5.57-log (oldest major version between slaves) log-bin:enabled
　　
Sat Nov  4 00:57:03 2017 - [info]     Replicating from 192.168.2.74(192.168.2.74:55555)
　　
Sat Nov  4 00:57:03 2017 - [info]     Primary candidate for the new Master (candidate_master is set)
　　
Sat Nov  4 00:57:03 2017 - [info] Current Alive Master: mysql_master(192.168.2.74:55555)
　　
Sat Nov  4 00:57:03 2017 - [info] Checking slave configurations..
　　
Sat Nov  4 00:57:03 2017 - [info]  read_only=1 is not set on slave mysql_slave1(192.168.2.75:55555).
　　
Sat Nov  4 00:57:03 2017 - [info]  read_only=1 is not set on slave mysql_slave2(192.168.2.76:55555).
　　
Sat Nov  4 00:57:03 2017 - [info] Checking replication filtering settings..
　　
Sat Nov  4 00:57:03 2017 - [info]  binlog_do_db= , binlog_ignore_db=
　　
Sat Nov  4 00:57:03 2017 - [info]  Replication filtering check ok.
　　
Sat Nov  4 00:57:03 2017 - [info] Starting SSH connection tests..
　　
Sat Nov  4 00:57:04 2017 - [info] All SSH connection tests passed successfully.
　　
Sat Nov  4 00:57:04 2017 - [info] Checking MHA Node version..
　　
Sat Nov  4 00:57:05 2017 - [info]  Version check ok.
　　
Sat Nov  4 00:57:05 2017 - [info] Checking SSH publickey authentication settings on the current master..
　　
Sat Nov  4 00:57:05 2017 - [info] HealthCheck: SSH to mysql_master is reachable.
　　
Sat Nov  4 00:57:05 2017 - [info] Master MHA Node version is 0.54.
　　
Sat Nov  4 00:57:05 2017 - [info] Checking recovery script configurations on the current master..
　　
Sat Nov  4 00:57:05 2017 - [info]   Executing command: save_binary_logs --command=test --start_pos=4 --binlog_dir=/data/mysql/55555/logs/ --output_file=/var/tmp/save_binary_logs_test --manager_version=0.55 --start_file=mysql-bin.000006
　　
Sat Nov  4 00:57:05 2017 - [info]   Connecting to root@mysql_master(mysql_master)..
　　
  Creating /var/tmp if not exists..    ok.
　　
  Checking output directory is accessible or not..
　　
   ok.
　　
  Binlog found at /data/mysql/55555/logs/, up to mysql-bin.000006
　　
Sat Nov  4 00:57:05 2017 - [info] Master setting check done.
　　
Sat Nov  4 00:57:05 2017 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
　　
Sat Nov  4 00:57:05 2017 - [info]   Executing command : apply_diff_relay_logs --command=test --slave_user='mha' --slave_host=mysql_slave1 --slave_ip=192.168.2.75 --slave_port=55555 --workdir=/var/tmp --target_version=5.5.57-log --manager_version=0.55 --relay_log_info=/data/mysql/55555/relay-log.info  --relay_dir=/data/mysql/55555/  --slave_pass=xxx
　　
Sat Nov  4 00:57:05 2017 - [info]   Connecting to root@192.168.2.75(mysql_slave1:22)..
　　
  Checking slave recovery environment settings..
　　
    Opening /data/mysql/55555/relay-log.info ... ok.
　　
    Relay log found at /data/mysql/55555, up to 55555-relay-bin.000002
　　
    Temporary relay log file is /data/mysql/55555/55555-relay-bin.000002
　　
    Testing mysql connection and privileges.. done.
　　
    Testing mysqlbinlog output.. done.
　　
    Cleaning up test file(s).. done.
　　
Sat Nov  4 00:57:05 2017 - [info]   Executing command : apply_diff_relay_logs --command=test --slave_user='mha' --slave_host=mysql_slave2 --slave_ip=192.168.2.76 --slave_port=55555 --workdir=/var/tmp --target_version=5.5.57-log --manager_version=0.55 --relay_log_info=/data/mysql/55555/relay-log.info  --relay_dir=/data/mysql/55555/  --slave_pass=xxx
　　
Sat Nov  4 00:57:05 2017 - [info]   Connecting to root@192.168.2.76(mysql_slave2:22)..
　　
  Checking slave recovery environment settings..
　　
    Opening /data/mysql/55555/relay-log.info ... ok.
　　
    Relay log found at /data/mysql/55555, up to 55555-relay-bin.000002
　　
    Temporary relay log file is /data/mysql/55555/55555-relay-bin.000002
　　
    Testing mysql connection and privileges.. done.
　　
    Testing mysqlbinlog output.. done.
　　
    Cleaning up test file(s).. done.
　　
Sat Nov  4 00:57:05 2017 - [info] Slaves settings check done.
　　
Sat Nov  4 00:57:05 2017 - [info]
　　
mysql_master (current master)
　　
+--mysql_slave1
　　
+--mysql_slave2
　　

　　
Sat Nov  4 00:57:05 2017 - [info] Checking replication health on mysql_slave1..
　　
Sat Nov  4 00:57:05 2017 - [info]  ok.
　　
Sat Nov  4 00:57:05 2017 - [info] Checking replication health on mysql_slave2..
　　
Sat Nov  4 00:57:05 2017 - [info]  ok.
　　
Sat Nov  4 00:57:05 2017 - [warning] master_ip_failover_script is not defined.
　　
Sat Nov  4 00:57:05 2017 - [warning] shutdown_script is not defined.
　　
Sat Nov  4 00:57:05 2017 - [info] Got exit code 0 (Not master dead).
　　

　　
MySQL Replication Health is OK.
　　
[root@mysql_slave2 conf]#