资源由 www.eimhe.com 美河学习在线收集提供
xxxx xxxx
xxx 米乐app官网下载的版权所有
目录
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
文档被以下合辑收录
评论