MHA切换过程:
1.监测master的状态Ping(SELECT) succeeded, waiting until MySQL doesn't respond..
2.当监控发现master异常时发出warning,并重试4次连接查询,并同时检查SSH状态。
3.读取配置文件,检查其他节点状态。
Reading configuration file /etc/masterha/masterha_default.conf and /etc/masterha/app1.conf again, and trying to connect to all servers to check server status..
经过双一轮检查,宣部master is down!
4.终止监控脚本Terminating monitoring script.
5.进入master failover进程:Starting master failover.(检查各节点状态,GTID based failover,Getting Latest Slaves Phase,)
Phase 1: Configuration Check Phase completed.
Phase 2: Dead Master Shutdown Phase completed.
Phase 3: Master Recovery Phase
Phase 3.1: Getting Latest Slaves Phase
Phase 3.3: Determining New Master Phase.
Phase 3.3: New Master Recovery Phase..(其实应该是3.4)
告知新节点环境binlog和position 并把new master 设置为Set read_only=0 on the new master.
完成master 迁移后,实现VIP迁移
Phase 4: Slaves Recovery Phase
Phase 4.1: Starting Slaves in parallel..
6.输出迁移报告:
----- Failover Report -----
最新文章
- [leetcode] 题型整理之数字加减乘除乘方开根号组合数计算取余
- Java: IO 学习小结
- static 使用,静态变量
- 深入理解CSS中的层叠上下文和层叠顺序
- Distinct<;TSource>;(IEqualityComparer<;TSource>; comparer) 根据列名来Distinct
- 一步步学习NHibernate(10)&mdash;&mdash;连接查询和子查询(2)
- HDU 1242 rescue and 优先级队列的条目
- python django model类型摘要
- Hql整理
- I2S协议
- IOS常用第三方库《转》
- shell脚本的小记
- Eclipse:报错Failed to read artifact descriptor for org.springframework.boot:spring-boot-autoconfigure:jar:2.1.2.
- cf351B Jeff and Furik (树状数组)
- 01_Mybaits逆向工程maven版
- Activiti中子流程:SubProcess,CallActiviti的区别
- Intellij IDEA run coverage之覆盖率测试
- c++ 多态,虚函数、重载函数、模版函数
- 安卓app开发-04- app运行的运行和调试
- 【BZOJ3813】奇数国 线段树+欧拉函数