MySQL HA by using Mysql-mmm

MySQL-mmm-twonodes(master)架构Intwonodemaster-mastersetup,MMMusesfiveIPs:singlepermanentIPforeachnodethatisneverchanged,2readerIPs(read-only)and1write

MySQL-mmm-two nodes(master)架构

In two node master-master setup, MMM uses five IPs: single permanent IP for each node

that is never changed, 2 reader IPs (read-only) and 1 writer IP (updates). Last three IPs

are migrating between the nodes depending on node availability.

Normally (no replication failures, no replication delay etc) active master has 2 IPs (reader

and writer), standby master - 1 IP (reader). In case of a failure, both - writer and reader

roles migrate to the working node.

 

测试环境部署

主机              ip              说明

monitor       192.168.1.109     mmm monitor服务器

master         192.168.1.106     数据库服务器(master)

slave1          192.168.1.107     数据库服务器(同样也为master)

 

vip部署

ip                         role                说明 

192.168.1.220      writer           应用连接此ip执行写操作

192.168.1.221      reader          应用连接此ip执行读操作

192.168.1.222      reader          应用连接此ip执行读操作

 

具体安装配置过程：

1.安装MySQL-mmm与master-master复制（略）

 

2.数据库节点创建mmm_monitor与mmm_agent用户

3.所有节点（包括monitor节点）配置/etc/mysql-mmm/mmm_common.conf

所有节点均相同

4.数据库节点配置/etc/mysql-mmm/mmm_agent.conf

5.monitor节点配置/etc/mysql-mmm/mmm_mon.conf

6.MySQL-mmm测试

7.常用命令

 

本文出自 “与IT一起的日子” 博客，网站空间，香港虚拟主机，美国服务器，请务必保留此出处