基于MHA的MySQL的高可用详细总结文档

codedba

2180

31页

81次

2021-03-24

免费下载

资源由 www.eimhe.com 美河学习在线收集提供

Xxxx xxxx

MySQL MHA 文档总结

资源由 www.eimhe.com 美河学习在线收集提供

Xxxx xxxx

MySQL MHA 介绍 ...................................................................................................................................................... 3

操作流程步骤 ............................................................................................................................................................. 4

拓扑图演变 ................................................................................................................................................................. 4

MHA 软件包说明 ...................................................................................................................................................... 6

Manager 工具包 ................................................................................................................................................ 6

Node 工具包 ..................................................................................................................................................... 6

实验环境 ..................................................................................................................................................................... 6

建立 ssh 无密码登录环境 .......................................................................................................................................... 7

manager 公约操作 ....................................................................................................................................... 7

主 mysql 公约操作 ......................................................................................................................................... 8

从 mysql1 公约操作 ......................................................................................................................................... 8

从 mysql2 公约操作 ......................................................................................................................................... 8

主机名 ................................................................................................................................................................. 8

修改 hosts............................................................................................................................................................ 9

测试 ssh 登录 ...................................................................................................................................................... 9

安装 mysql 和配置主从关系 .................................................................................................................................... 10

在线安装 mysql5.5 ............................................................................................................................................ 10

编辑 mysql 配置文件 ........................................................................................................................................ 10

启动 mysql 和查询启动状态 ............................................................................................................................ 11

数据库一致性 ................................................................................................................................................... 12

半同步复制开启 ............................................................................................................................................... 12

配置 mysql 主从 ............................................................................................................................................. 13

测试 mysql 主从 ................................................................................................................................................ 14

部署 MHA .................................................................................................................................................................. 15

安装 MHA Node ................................................................................................................................................ 15

安装 MHA manager ........................................................................................................................................... 16

检查 SSH 配置 ................................................................................................................................................... 18

检查复制情况 ................................................................................................................................................... 19

启动 MHA manager ........................................................................................................................................... 21

停止 MHA manager ........................................................................................................................................... 22

任务计划 ........................................................................................................................................................... 22

配置 vip ............................................................................................................................................................. 22

测试 MHA .................................................................................................................................................................. 24

停止主 mysql ..................................................................................................................................................... 24

查看从 mysql 情况 ............................................................................................................................................ 24

资料（源码包/配置文件） ...................................................................................................................................... 26

参考文章 ................................................................................................................................................................... 26

FAQ .......................................................................................................................................................................... 26

of 31

免费下载

文档被以下合辑收录

墨天轮最受欢迎的技术文档-高可用架构篇（共121篇）

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

关注

文档被以下合辑收录

评论