该日志在MHA管理主机中,配置文件中你所定义的日志文件中。
在认定master主库宕机之后:故障转移步骤
Thu Jul 27 19:19:56 2017 - [info] * Phase 1: Configuration Check Phase..
Thu Jul 27 19:19:56 2017 - [info]
Thu Jul 27 19:19:56 2017 - [info] GTID failover mode = 1
Thu Jul 27 19:19:56 2017 - [info] Dead Servers:
Thu Jul 27 19:19:56 2017 - [info] 172.25.67.3(172.25.67.3:3306)
Thu Jul 27 19:19:56 2017 - [info] Checking master reachability via MySQL(double check)...
Thu Jul 27 19:19:56 2017 - [info] ok.
Thu Jul 27 19:19:56 2017 - [info] Alive Servers:
Thu Jul 27 19:19:56 2017 - [info] 172.25.67.2(172.25.67.2:3306)
Thu Jul 27 19:19:56 2017 - [info] 172.25.67.4(172.25.67.4:3306)
Thu Jul 27 19:19:56 2017 - [info] Alive Slaves:
Thu Jul 27 19:19:56 2017 - [info] 172.25.67.2(172.25.67.2:3306) Version=5.7.17-log (oldest major version between slaves) log-bin:enabled
Thu Jul 27 19:19:56 2017 - [info] GTID ON
Thu Jul 27 19:19:56 2017 - [info] Replicating from 172.25.67.3(172.25.67.3:3306)
Thu Jul 27 19:19:56 2017 - [info] 172.25.67.4(172.25.67.4:3306) Version=5.7.17-log (oldest major version between slaves) log-bin:enabled
Thu Jul 27 19:19:56 2017 - [info] GTID ON
Thu Jul 27 19:19:56 2017 - [info] Replicating from 172.25.67.3(172.25.67.3:3306)
Thu Jul 27 19:19:56 2017 - [info] Starting GTID based failover.
Thu Jul 27 19:19:56 2017 - [info]
Thu Jul 27 19:19:56 2017 - [info] ** Phase 1: Configuration Check Phase completed.
该第一阶段:配置检查。从上面的日志信息中可以得知死掉的主库是(172.25.67.3),存活的从库是(172.25.67.2/4),版本为5.7.17-log,且开启了GTID。
Thu Jul 27 19:19