MHA安装配置 - 数据库编程

ter is down! Thu Jul 23 14:59:22 2015 - [info] Terminating monitoring script. Thu Jul 23 14:59:22 2015 - [info] Got exit code 20 (Master dead). Thu Jul 23 14:59:22 2015 - [info] MHA::MasterFailover version 0.56. Thu Jul 23 14:59:22 2015 - [info] Starting master failover. Thu Jul 23 14:59:22 2015 - [info] Thu Jul 23 14:59:22 2015 - [info] * Phase 1: Configuration Check Phase.. Thu Jul 23 14:59:22 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] GTID failover mode = 0 Thu Jul 23 14:59:23 2015 - [info] Dead Servers: Thu Jul 23 14:59:23 2015 - [info] mysql-mha02(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] Checking master reachability via MySQL(double check)... Thu Jul 23 14:59:23 2015 - [info] ok. Thu Jul 23 14:59:23 2015 - [info] Alive Servers: Thu Jul 23 14:59:23 2015 - [info] mysql-mha01(192.168.8.6:3306) Thu Jul 23 14:59:23 2015 - [info] mysql-mha03(192.168.8.8:3306) Thu Jul 23 14:59:23 2015 - [info] Alive Slaves: Thu Jul 23 14:59:23 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:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 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:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] Starting Non-GTID based failover. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] ** Phase 1: Configuration Check Phase completed. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] * Phase 2: Dead Master Shutdown Phase.. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:5

9:23 2015 - [info] Forcing shutdown so that applications never connect to the current master.. Thu Jul 23 14:59:23 2015 - [warning] master_ip_failover_script is not set. Skipping invalidating dead master IP address. Thu Jul 23 14:59:23 2015 - [warning] shutdown_script is not set. Skipping explicit shutting down of the dead master. Thu Jul 23 14:59:23 2015 - [info] * Phase 2: Dead Master Shutdown Phase completed. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] * Phase 3: Master Recovery Phase.. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] * Phase 3.1: Getting Latest Slaves Phase.. Thu Jul 23 14:59:23 2015 - [info] Thu Jul 23 14:59:23 2015 - [info] The latest binary log file/position on all slaves is mysql-bin.000014:107 Thu Jul 23 14:59:23 2015 - [info] Latest slaves (Slaves that received relay log files to the latest): Thu Jul 23 14:59:23 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:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 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:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] The oldest binary log file/position on all slaves is mysql-bin.000014:107 Thu Jul 23 14:59:23 2015 - [info] Oldest slaves: Thu Jul 23 14:59:23 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:59:23 2015 - [info] Replicating from 192.168.8.7(192.168.8.7:3306) Thu Jul 23 14:59:23 2015 - [info] mys

MHA安装配置(八)