Mysql数据库高可用性方案实践
5墨值下载
MYSQL 高可用方案探究
1 前言........................................................................................................................................... 3
2 Lvs+Keepalived+Mysql 单点写入主主同步高可用方案 ...................................................... 3
2.1 方案简介 ....................................................................................................................... 3
2.2 方案架构图 ................................................................................................................... 3
2.3 方案优缺点 ................................................................................................................... 4
2.4 方案实战 ....................................................................................................................... 4
2.4.1 适用场景 ........................................................................................................... 4
2.4.2 实战环境介绍 ................................................................................................... 4
2.4.3 Mysql 的安装和配置 ........................................................................................ 4
2.4.4 Mysql 的主主同步配置 .................................................................................... 4
2.4.5 Lvs 的安装 ........................................................................................................ 4
2.4.6 Keepalived 的安装 .......................................................................................... 5
2.4.7 Keepalived 的配置 .......................................................................................... 5
2.4.8 Master 和 backup 的 realserver 的配置 ...................................................... 7
2.4.9 Master 和 backup 的启动 ................................................................................ 8
2.4.10 高可用方案测试 .............................................................................................. 9
3 Lvs+Keepalived+Mysql 单点写入读负载均衡主主同步高可用方案 .................................. 9
3.1 方案简介 ....................................................................................................................... 9
3.2 方案架构图 ................................................................................................................... 9
3.3 方案优缺点 ................................................................................................................... 9
3.4 适用场景 ..................................................................................................................... 10
3.5 方案实战 ..................................................................................................................... 10
3.5.1 实战环境介绍 ................................................................................................. 10
3.5.2 Mysql 的安装和配置 ...................................................................................... 10
3.5.3 Mysql 的主主同步配置 .................................................................................. 10
3.5.4 Lvs 的安装 ...................................................................................................... 10
3.5.5 Keepalived 的安装 ........................................................................................ 11
3.5.6 Keepalived 的配置 ........................................................................................ 11
3.5.7 Master 和 backup 的 realserver 的配置 .................................................... 15
3.5.8 Master 和 backup 的启动 .............................................................................. 16
4 Heartbeat 高可用 Mysql 主主同步方案 .............................................................................. 16
4.1 方案简介 ..................................................................................................................... 16
4.2 方案优缺点 ................................................................................................................. 16
4.3 方案架构图 ................................................................................................................. 17
4.4 适用场景 ..................................................................................................................... 17
4.5 方案实战 ..................................................................................................................... 17
4.5.1 实战环境介绍 ................................................................................................. 17
4.5.2 Mysql 的安装和配置 ...................................................................................... 17
4.5.3 Mysql 的主主同步配置 .................................................................................. 17
4.5.4 Heardbeat 的安装 .......................................................................................... 17
4.5.5 Heartbeat 的配置 .......................................................................................... 18
4.5.6 Heartbeat 的启动 .......................................................................................... 19
4.5.7 方案测试 ......................................................................................................... 19
4.5.8 监控方案 ......................................................................................................... 19
5 Heartbeat+DRBD+mysql 高可用方案 .................................................................................... 20
5.1 方案简介 ..................................................................................................................... 20
5.2 方案优缺点 ................................................................................................................. 20
5.3 方案架构图 ................................................................................................................. 20
5.4 方案适用场景 ............................................................................................................. 20
5.5 方案实战 ..................................................................................................................... 20
5.5.1 实战环境介绍 ................................................................................................. 20
5.5.2 DRBD 的安装 .................................................................................................... 20
5.5.3 DRBD 的配置 .................................................................................................... 21
5.5.4 DRBD 的管理维护 ............................................................................................ 21
5.5.5 Heartbeat 的安装 .......................................................................................... 23
5.5.6 Heartbeat 的配置 .......................................................................................... 23
5.5.7 Heartbeat 的管理 .......................................................................................... 25
5.5.8 Heartbeat+DRBD 测试 .................................................................................... 25
5.5.9 Heartbeat+DRBD 监控 .................................................................................... 25
6 MMM 高可用 mysql 方案 .......................................................................................................... 25
6.1 方案简介 ..................................................................................................................... 25
6.2 方案优缺点 ................................................................................................................. 26
6.3 方案架构图 ................................................................................................................. 26
6.4 适用场景 ..................................................................................................................... 26
6.5 方案实战 ..................................................................................................................... 26
6.5.1 实战环境介绍 ................................................................................................. 26
6.5.2 MMM 的安装 ...................................................................................................... 27
6.5.3 MMM 的配置 ...................................................................................................... 27
6.5.4 MMM 的管理 ...................................................................................................... 30
6.5.5 MMM 架构的测试 .............................................................................................. 30
6.5.6 MMM 架构的监控 .............................................................................................. 30
7 参考文献 ................................................................................................................................. 31
of 31
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论