1、配置主(100)<->主(101)[参考: [Tony 老师搭建 MySQL 主从服务器](https:
2、配置主(100)<->从(102) [参考: [Tony 老师搭建 MySQL 主从服务器](https:
3、 安装
rpm -vih <http:
rpm -Uvh <http:
4、 yum clean all && yum makecache
5、更改yum源配置
yum search mmm # 查询mmm支持包
yum -y install mysql-mmm-agent.noarch #每个服务器都需要安装mmm代理
yum -y install mysql-mmm* #监控服务器安装监控服务
systemctl status mysql-mmm-agent
systemctl start mysql-mmm-agent
systemctl stop mysql-mmm-agent
systemctl restart mysql-mmm-agent
6、建立账号
CREATE USER repl@
'192.168.71.%'
identified by
'123456'
;
CREATE USER mmm_monitor@
'192.168.71.%'
identified by
'123456'
;
CREATE USER mmm_agent@
'192.168.71.%'
identified by
'123456'
;
7、账号授权
GRANT replication client on *.* to
'mmm_monitor'
@
'192.168.71.%'
identified by
'123456'
; #用于MMM监控服务器使用,在master上建立
GRANT super,replication client ,process on *.* to
'mmm_agent'
@
'192.168.71.%'
identified by
'123456'
; #MMM代理服务,改变故障转移和主从切换
GRANT REPLICATION SLAVE ON *.* TO repl@
'192.168.71.%'
;
8、配置MMM(数据库节点配置,三台均配置)
cd /etc/mysq-mmm/
vim mmm_common.conf
配置< host
default
>:
网口:cluster_interface
pid和bin路径:默认
replication_user:repl
replication_password:123456
agent_user:mmm_agent
agent_password:123456
配置< host db1 >:
ip :192.168.71.244
mode :master
peer:db2
配置 < host db2 > :
ip:192.168.71.223
mode:master
peer:db1
配置< host db3 >:
ip:192.168.71.220
mode:slave
配置< role writer >
hosts : db1,db2
ips:192.168.71.90
mode:exclusive( 唯一的)
配置 < role reader >
hosts:db1,db2,db3
ips:192.168.71.91,192.168.71.92,192.168.71.93
mode:balanced(平衡的)
复制配置文件到其他服务器
scp mmm_common.conf root@192.168.71.223:/etc/mysql-mmm/
scp mmm_common.conf root@192.168.71.220:/etc/mysql-mmm/
vim mysql-agent.conf (三台服务器对应设置为:db1,db2,db3)
9、监控节点配置(192.168.71.220,只配置监控节点)
vim mmm_mon.conf #监控数据文件
配置< host
default
>
monitor_user :mmm_monitor
monitor_password:123456
配置monitor
ping_ips:192.168.71.244,192.168.71.223,192.168.71.220
10、启动MMM服务
/etc/init.d/mysql-mmm-agent start(三台服务器均启动代理服务)
/etc/init.d/mysql-mmm-monitor start (监控服务器启动监控服务)
11、查看监控信息
mmm_control
mmm_control show #查看集群状态
mmm_control checks all #检查集群状态
mmm_control ping #检查与监控服务器连接状态
mmm_control set_online/offline #设置服务器上线/下线
mmm_control help #查看帮助
12、查看服务器虚拟IP状态
13、测试
关闭db1的数据库:/etc/init.d/mysqld stop
查看监控服务器上集群状态:mmm_control show
查看DB3的主从状态