目 录
一、 目的 ................................................................................................................................................................................... 3
二、 mgr简介 ........................................................................................................................................................................ 3
三、 mgr复制的背景 ............................................................................................................................................................ 3
四、 mgr复制和传统复制的对比 ................................................................................................ ................................ ........ 4
1. 主从复制 ........................................................................................................................................................................... 4
2. 半同步复制 ....................................................................................................................................................................... 4
3. 组复制 ............................................................................................................................................................................... 5
五、 组复制的详细信息 ................................................................ ................................ ........................................................... 6
1.组复制的传输故障检测 ........................................................................................................................................................ 6
2.组复制间成员关系 ................................................................................................................................................................ 6
3.容错机制 ................................................................................................................................................................................ 6
六、 单主模式和多组模式 ....................................................................................................................................................... 7
1. 单主模式 ........................................................................................................................................................................... 7
2. 多主模式 ........................................................................................................................................................................... 7
七、 组复制的搭建 ................................................................................................................................................................... 8
1. 单主模式搭建 ................................................................................................................................................................... 8
2. 多主模式搭建 ................................................................................................................................................................. 16
八、 组复制监控常用相关表 ................................................................................................................................................. 17
1. replication_group_member_stats............................................................................................................................. 17
2. replication_group_members ...................................................................................................................................... 18
3. replication_connection_status ................................................................................................................................ 19
4. replication_applier_status ........................................................................................................................................ 20
九、 mgr单主模式和多主模式的切换 .............................................................................................................................. 20
1. 单主切多主 ........................................................................................................................................................................ 20
2.多主切单主 .......................................................................................................................................................................... 23
十、 mgr异常恢复 ................................ ................................................................ .............................................................. 26
1. 网络异常恢复 ................................................................................................................................................................. 27
2. 数据异常修复 ................................................................................................................................................................. 27
3. 分布式恢复 ................................ ................................ ................................................................ ..................................... 28
十一、 mgr流控（流量控制） ................................ ................................................................ ................................ .......... 35
十二、 mgr性能压测 .......................................................................................................................................................... 36
十三、 问题、限制与总结..................................................................................................................................................... 37
文档被以下合辑收录
评论