mysql-mmm-2.2.1-中文版_mysql读写分离实现

mysql-mmm

需积分: 10 145 浏览量更新于2023-03-16 评论 4 收藏 487KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

MMM Installation Guide

Mysql Master-Master Replication Manager

(mysql-mmm installation Guide)

Version:mysql-mmm-2.2.1

作者：andy.feng

网名：FH.CN

Email：lr@isadba.com

BLOG:http://linuxguest.blog.51cto.com

一、安装环境介绍 ............................................................................................................................................................................ 3

一、确定 MMM 架构（参见手册第二章，典型应用） ......................................................................................................... 3

二、确定操作系统和 mysql 版本及相关信息 ......................................................................................................................... 3

二、安装步骤分析 ............................................................................................................................................................................ 4

三、正式安装 .................................................................................................................................................................................... 4

一、安装系统 ............................................................................................................................................................................ 4

二、安装 mysql .......................................................................................................................................................................... 4

1、检查系统是否安装过 mysql ........................................................................................................................................ 4

2、下载 mysql 软件，编译安装，在四台机器上都需要做 ........................................................................................... 4

三、配置 mysql master-master 复制 ....................................................................................................................................... 5

1、修改 my.cnf 配置 ......................................................................................................................................................... 5

2、创建复制使用的 mysql 用户 ....................................................................................................................................... 6

3、同步数据 ...................................................................................................................................................................... 6

4、配置复制关系 .............................................................................................................................................................. 7

四、安装 mysql-mmm ............................................................................................................................................................. 11

1、安装 agent 和 monitor 需要的 perl 库...................................................................................................................... 11

2、下载安装 mysql-mmm ............................................................................................................................................... 12

3、mysql-mmm 使用的目录和存放文件简介 ............................................................................................................... 12

4、配置 MYSQL-MMM-agentd ........................................................................................................................................ 12

5、启动 MYSQL-mmm_agent ......................................................................................................................................... 14

6、配置 MYSQL-MMM-monitor ....................................................................................................................................... 14

7、启动 MYSQL-MMM-monitor ....................................................................................................................................... 15

8、管理 MYSQL-MMM-monitor ....................................................................................................................................... 16

9、从 2 个 master 架构扩展到 2 个 master 多个 slave 架构（已修正） .................................................................. 16

四、测试 .......................................................................................................................................................................................... 19

一、测试写入数据是否同步 ................................................................................................................................................... 19

二、测试 writer 故障切换 ....................................................................................................................................................... 20

三、测试 db3 的主是否会自动切换 ...................................................................................................................................... 22

四、测试角色优先配置的影响 ............................................................................................................................................... 24