MHA自动切换步骤及过程剖析(十)
- [info] -- Slave diff log generation on host vdbsrv3(192.168.1.8:3306) succeeded.
Mon Apr 20 14:30:37 2015 - [info] Generating relay diff files from the latest slave succeeded.
Mon Apr 20 14:30:37 2015 - [info]
Mon Apr 20 14:30:37 2015 - [info] * Phase 4.2: Starting Parallel Slave Log Apply Phase..
Mon Apr 20 14:30:37 2015 - [info]
Mon Apr 20 14:30:37 2015 - [info] -- Slave recovery on host vdbsrv3(192.168.1.8:3306) started, pid: 7735.
Check tmp log /var/log/masterha/app1/vdbsrv3_3306_20150420143022.log if it takes time..
Mon Apr 20 14:30:43 2015 - [info]
Mon Apr 20 14:30:43 2015 - [info] Log messages from vdbsrv3 ...
Mon Apr 20 14:30:43 2015 - [info]
Mon Apr 20 14:30:37 2015 - [info] Sending binlog.. ###这部分则是在原master宕机后未发送的binlog部分
Mon Apr 20 14:30:38 2015 - [info] scp from local:/var/log/masterha/app1/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog to
root@vdbsrv3:/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog succeeded.
Mon Apr 20 14:30:38 2015 - [info] Starting recovery on vdbsrv3(192.168.1.8:3306)..
Mon Apr 20 14:30:38 2015 - [info] Generating diffs succeeded.
Mon Apr 20 14:30:38 2015 - [info] Waiting until all relay logs are applied.
Mon Apr 20 14:30:38 2015 - [info] done.
Mon Apr 20 14:30:38 2015 - [info] Getting slave status..
Mon Apr 20 14:30:38 2015 - [info] This slave(vdbsrv3)'s Exec_Master_Log_Pos equals to Read_Master_Log_Pos(mysql-bin.000020:313962621).
No need to recover from Exec_Master_Log_Pos.
Mon Apr 20 14:30:38 2015 - [info] Connecting to the target slave host vdbsrv3, running recover script..
Mon Apr 20 14:30:38 2015 - [info] Executing command
: apply_diff_relay_logs --command=apply --slave_user='mha' --slave_host=vdbsrv3
--slave_ip=192.168.1.8 --slave_port=3306 --apply_files=/var/tmp/relay_from_read_to_latest_vdbsrv3_3306_20150420143022.binlog,
/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog --workdir=/var/tmp --target_version=5.6.22-log
--timestamp=20150420143022 --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56 --slave_pass=xxx
Mon Apr 20 14:30:43 2015 - [info]
Concat all apply files to /var/tmp/total_binlog_for_vdbsrv3_3306.20150420143022.binlog ..
Copying the first binlog file /var/tmp/relay_from_read_to_latest_vdbsrv3_3306_20150420143022.binlog to
/var/tmp/total_binlog_for_vdbsrv3_3306.20150420143022.binlog.. ok.
Dumping binlog head events (rotate events), skipping format description events from
/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog.. Binlog Checksum enabled
dumped up to pos 120. ok.
/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog has effective binlog events from pos 120.
Dumping effective binlog data from /var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog position 120 to tail(143).. ok.
Concat succeeded.
All apply target binary logs are concatinated at /var/tmp/total_binlog_for_vdbsrv3_3306.20150420143022.binlog .
Applying differential binary/relay log files /var/tmp/relay_from_read_to_latest_vdbsrv3_3306_20150420143022.binlog,
/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog on vdbsrv3:3306. This may take long time...
Applying log files succeeded.
Mon Apr 20 14:30:43 2015 - [info] All relay logs were successfully applied.
Mo