设为首页 加入收藏

TOP

MHA自动切换步骤及过程剖析(十)
2015-11-21 01:45:19 来源: 作者: 【 】 浏览:6
Tags: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
首页 上一页 7 8 9 10 下一页 尾页 10/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇使用bbed修改数据 下一篇SqlServer服务远程过程调用失败

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: