|
ql-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]
Thu Jul 23 14:59:23 2015 - [info] * Phase 3.2: Saving Dead Master's Binlog Phase..
Thu Jul 23 14:59:23 2015 - [info]
Thu Jul 23 14:59:23 2015 - [info] Fetching dead master's binary logs..
Thu Jul 23 14:59:23 2015 - [info] Executing command on the dead master mysql-mha02(192.168.8.7:3306): save_binary_logs --command=save --start_file=mysql-bin.000014 --start_pos=107 --binlog_dir=/var/lib/mysql/logs --output_file=/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56
Creating /var/log/masterha/node if not exists.. ok.
Concat binary/relay logs from mysql-bin.000014 pos 107 to mysql-bin.000014 EOF into /var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog ..
Dumping binlog format description event, from position 0 to 107.. ok.
Dumping effective binlog data from /var/lib/mysql/logs/mysql-bin.000014 position 107 to tail(126).. ok.
Concat succeeded.
Thu Jul 23 14:59:23 2015 - [info] scp from root@192.168.8.7:/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog to local:/var/log/masterha/manager/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog succeeded.
Thu Jul 23 14:59:23 2015 - [info] HealthCheck: SSH to mysql-mha01 is reachable.
Thu Jul 23 14:59:24 2015 - [info] HealthCheck: SSH to mysql-mha03 is reachable.
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] * Phase 3.3: Determining New Master Phase..
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] Finding the latest slave that has all relay logs for recovering other slaves..
Thu Jul 23 14:59:24 2015 - [info] All slaves received relay logs to the same position. No need to resync each other.
Thu Jul 23 14:59:24 2015 - [info] Searching new master from slaves..
Thu Jul 23 14:59:24 2015 - [info] Candidate masters from the configuration file:
Thu Jul 23 14:59:24 2015 - [info] Non-candidate masters:
Thu Jul 23 14:59:24 2015 - [info] New master is mysql-mha01(192.168.8.6:3306)
Thu Jul 23 14:59:24 2015 - [info] Starting master failover..
Thu Jul 23 14:59:24 2015 - [info]
From:
mysql-mha02(192.168.8.7:3306) (current master)
+--mysql-mha01(192.168.8.6:3306)
+--mysql-mha03(192.168.8.8:3306)
To:
mysql-mha01(192.168.8.6:3306) (new master)
+--mysql-mha03(192.168.8.8:3306)
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] * Phase 3.3: New Master Diff Log Generation Phase..
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] This server has all relay logs. No need to generate diff files from the latest slave.
Thu Jul 23 14:59:24 2015 - [info] Sending binlog..
Thu Jul 23 14:59:24 2015 - [info] scp from local:/var/log/masterha/manager/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog to root@mysql-mha01:/var/log/masterha/node/saved_master_binlog_from_mysql-mha02_3306_20150723145922.binlog succeeded.
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] * Phase 3.4: Master Log Apply Phase..
Thu Jul 23 14:59:24 2015 - [info]
Thu Jul 23 14:59:24 2015 - [info] *NO |