设为首页 加入收藏

TOP

MHA自动切换步骤及过程剖析(六)
2015-11-21 01:45:19 来源: 作者: 【 】 浏览:7
Tags:MHA 自动 切换 步骤 过程 剖析
0 14:30:22 2015 - [info] Replicating from 192.168.1.6(192.168.1.6:3306) 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] Checking slave configurations.. Mon Apr 20 14:30:22 2015 - [info] read_only=1 is not set on slave vdbsrv2(192.168.1.7:3306). Mon Apr 20 14:30:22 2015 - [info] Checking replication filtering settings.. Mon Apr 20 14:30:22 2015 - [info] Replication filtering check ok. Mon Apr 20 14:30:22 2015 - [info] Master is down! Mon Apr 20 14:30:22 2015 - [info] Terminating monitoring script. Mon Apr 20 14:30:22 2015 - [info] Got exit code 20 (Master dead). Mon Apr 20 14:30:22 2015 - [info] MHA::MasterFailover version 0.56. Mon Apr 20 14:30:22 2015 - [info] Starting master failover. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] * Phase 1: Configuration Check Phase.. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] GTID failover mode = 0 Mon Apr 20 14:30:22 2015 - [info] Dead Servers: Mon Apr 20 14:30:22 2015 - [info] vdbsrv1(192.168.1.6:3306) Mon Apr 20 14:30:22 2015 - [info] Checking master reachability via MySQL(double check)... Mon Apr 20 14:30:22 2015 - [info] ok. Mon Apr 20 14:30:22 2015 - [info] Alive Servers: Mon Apr 20 14:30:22 2015 - [info] vdbsrv2(192.168.1.7:3306) Mon Apr 20 14:30:22 2015 - [info] vdbsrv3(192.168.1.8:3306) Mon Apr 20 14:30:22 2015 - [info] Alive Slaves: 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] 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] Starting Non-GTID based failover. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] ** Phase 1: Configuration Check Phase completed. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] * Phase 2: Dead Master Shutdown Phase.. ###隔离master server Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] Forcing shutdown so that applications never connect to the current master.. Mon Apr 20 14:30:22 2015 - [info] Executing master IP deactivation script: Mon Apr 20 14:30:22 2015 - [info] /tmp/master_ip_failover --orig_master_host=vdbsrv1 --orig_master_ip=192.168.1.6 --orig_master_port=3306 --command=stopssh --ssh_user=root IN SCRIPT TEST====/sbin/ifconfig eth0:0 down==/sbin/ifconfig eth0:0 192.168.1.13/24=== Disabling the VIP on old master: vdbsrv1 Mon Apr 20 14:30:22 2015 - [info] done. Mon Apr 20 14:30:22 2015 - [warning] shutdown_script is not set. Skipping explicit shutting down of the dead master. Mon Apr 20 14:30:22 2015 - [info] * Phase 2: Dead Master Shutdown Phase completed. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] * Phase 3: Master Recovery Phase.. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] * Phase 3.1: Getting Latest Slaves Phase.. Mon Apr 20 14:30:22 2015 - [info] Mon Apr 20 14:30:22 2015 - [info] The latest binary log file/position on all slaves is mysql-bin.000020:315514388 Mon Apr 20 14:
首页 上一页 3 4 5 6 7 8 9 下一页 尾页 6/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇使用bbed修改数据 下一篇SqlServer服务远程过程调用失败

评论

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