设为首页 加入收藏

TOP

MHA自动切换步骤及过程剖析(七)
2015-11-21 01:45:19 来源: 作者: 【 】 浏览:8
Tags:MHA 自动 切换 步骤 过程 剖析
30:22 2015 - [info] Latest slaves (Slaves that received relay log files to the latest): Mon Apr 20 14:30:22 2015 - [info] vdbsrv2(192.168.1.7:3306) Version=5.6.22-log (oldest major version between slaves) log-bin:enabled Mon Apr 20 14:30:22 2015 - [info] Replicating from 192.168.1.6(192.168.1.6:3306) Mon Apr 20 14:30:22 2015 - [info] The oldest binary log file/position on all slaves is mysql-bin.000020:313962621 Mon Apr 20 14:30:22 2015 - [info] Oldest slaves: Mon Apr 20 14:30:22 2015 - [info] vdbsrv3(192.168.1.8:3306) Version=5.6.22-log (oldest major version between slaves) log-bin:enabled Mon Apr 20 14:30:22 2015 - [info] Replicating from 192.168.1.6(192.168.1.6:3306) Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] * Phase 3.2: Saving Dead Master's Binlog Phase.. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:23 2015 - [info] Fetching dead master's binary logs.. ###从dead master提取binlog Mon Apr 20 14:30:23 2015 - [info] Executing command on the dead master vdbsrv1(192.168.1.6:3306): save_binary_logs --command=save --start_file=mysql-bin.000020 --start_pos=315514388 --binlog_dir=/data/mysqldata --output_file=/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog --handle_raw_binlog=1 --disable_log_bin=0 --manager_version=0.56 Creating /var/tmp if not exists.. ok. Concat binary/relay logs from mysql-bin.000020 pos 315514388 to mysql-bin.000020 EOF into /var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog .. Binlog Checksum enabled Dumping binlog format description event, from position 0 to 120.. ok. Dumping effective binlog data from /data/mysqldata/mysql-bin.000020 position 315514388 to tail(315514411).. ok. Binlog Checksum enabled Concat succeeded. Mon Apr 20 14:30:23 2015 - [info] scp from root@192.168.1.6:/var/tmp/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog to local:/var/log/masterha/app1/saved_master_binlog_from_vdbsrv1_3306_20150420143022.binlog succeeded. ###复制dump的binlog到监控节点 Mon Apr 20 14:30:23 2015 - [info] HealthCheck: SSH to vdbsrv2 is reachable. Mon Apr 20 14:30:24 2015 - [info] HealthCheck: SSH to vdbsrv3 is reachable. Mon Apr 20 14:30:24 2015 - [info] Mon Apr 20 14:30:24 2015 - [info] * Phase 3.3: Determining New Master Phase.. Mon Apr 20 14:30:24 2015 - [info] Mon Apr 20 14:30:24 2015 - [info] Finding the latest slave that has all relay logs for recovering other slaves.. ###寻找最近的slave中继日志 Mon Apr 20 14:30:24 2015 - [info] Checking whether vdbsrv2 has relay logs from the oldest position.. ###用于恢复其他slave Mon Apr 20 14:30:24 2015 - [info] Executing command: apply_diff_relay_logs --command=find --latest_mlf=mysql-bin.000020 --latest_rmlp=315514388 --target_mlf=mysql-bin.000020 --target_rmlp=313962621 --server_id=1001 --workdir=/var/tmp --timestamp=20150420143022 --manager_version=0.56 --relay_log_info=/data/mysqldata/relay-log.info --relay_dir=/data/mysqldata/ Opening /data/mysqldata/relay-log.info ... ok. Relay log found at /data/mysqldata, up to vdbsrv2-relay-bin.000003 Fast relay log position search succeeded. Target relay log file/position found. start_file:vdbsrv2-relay-bin.000003, start_pos:6265486. Target relay log FOUND! Mon Apr 20 14:30:24 2015 - [info] OK. vdbsrv2 has all relay logs. Mon Apr 20 14:30:24 2015 - [info] Searching new master from slaves.. ###寻找
首页 上一页 4 5 6 7 8 9 10 下一页 尾页 7/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇使用bbed修改数据 下一篇SqlServer服务远程过程调用失败

评论

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