非常详细的MySQL 5.7 MHA安装部署文档

szrsu
2499
49页
20次
2022-03-18
25墨值下载
MHA 实现 MySQL 主从高可用复制
文档
修订说明
编号
日期
描述
版
本
作者
审核
发布日期
目录 
一、  简述 ................................................................................................................................................5 
二、  MHA ...............................................................................................................................................5 
1  MHA-介绍 ................................................................................................................................5 
2  MHA-工作架构说明 ..............................................................................................................5 
3  MHA-工作原理 .......................................................................................................................6 
4  MHA-软件架构 .......................................................................................................................7 
5  MHA-优势 ................................................................................................................................7 
6  MHA-劣势 ................................................................................................................................8 
三、  MHA 实验架构 ............................................................................................................................8 
1  基本环境 ...................................................................................................................................9 
2  架构设计 ...................................................................................................................................9 
四、  MHA-安装配置 ...........................................................................................................................9 
1  配置主从复制 ..........................................................................................................................9 
2  关闭 relay 日志自动清理 ................................................................................................... 12 
3  安装 Perl 等依赖模块 ......................................................................................................... 12 
4  配置 SSH 登录无密码验证 ................................................................................................ 12 
5  创建用户 mha 管理的账号 ............................................................................................... 13 
6  安装 MHA Node .................................................................................................................. 13 
7  安装 MHA Manager ............................................................................................................ 14 
8  配置 MHA .............................................................................................................................. 15 
五、  MHA-检查 ................................................................................................................................. 17 
1  检查 SSH 配置 ...................................................................................................................... 17 
2  检查整个复制环境状况 ..................................................................................................... 18 
3  检查 MHA Manager 的状态 ............................................................................................. 19 
4  启动 MHA .............................................................................................................................. 19 
5  停止 MHA 方法 .................................................................................................................... 20 
6  设置 relaylog 清理计划 ...................................................................................................... 21 
六、  MHA-功能测试 ........................................................................................................................ 21 
1  故障模拟 ................................................................................................................................ 22 
2  故障切换备选主库的算法 ................................................................................................. 22 
3  修复宕机的 master ............................................................................................................. 23 
4  手动切换 ................................................................................................................................ 23 
七、  另一 MHA 部署案例（参考） .............................................................................................. 27 
1  复制环境 ................................................................................................................................ 28 
2  MHA 简介 .............................................................................................................................. 28 
3  MHA 软件安装 ..................................................................................................................... 30 
3.1  MHA 软件下载 ........................................................................................................ 30 
3.2  MHA NODE 安装 .................................................................................................... 31 
3.3  MHA Manager 安装............................................................................................... 31 
3.4  验证安装................................................................................................................... 32 
3.5  MHA 部署前准备 ................................................................................................... 33 
3.6  MHA 配置 ................................................................................................................. 37 
3.7  MHA 故障转移测试 ............................................................................................... 41 
of 49
25墨值下载
mysql mha
文档被以下合辑收录

墨天轮最受欢迎的技术文档-高可用架构篇（共121篇）
数据库高可用如何实现？这份合辑你或许可以用到！本文为大家整理了墨天轮社区上一些受欢迎的数据库高可用架构实践主题相关文档，包含Oracle、PostgreSQL、MySQL三类数据库，欢迎大家下载查看🌹
文档被以下合辑收录

相关文档

评论
