MHA +maxscale 实现读写分离高可用架构实战

最新推荐文章于 2025-06-03 07:40:39 发布

wjl7813

最新推荐文章于 2025-06-03 07:40:39 发布

阅读量3k

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/wjl7813/article/details/79184455

本文介绍了使用MHA和MaxScale搭建读写分离高可用架构的过程，包括创建监控和业务账号、配置MaxScale、设置监听和服务，并展示了成功连接和测试数据插入的步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MHA 相关原理 http://mp.blog.youkuaiyun.com/postedit/79183726

MHA http://mp.blog.youkuaiyun.com/postedit/79183743 最佳实战

MySQL读写分离原理相关知识体系 http://blog.youkuaiyun.com/wjl7813/article/details/79184468

本文以第2种方式实现（基于中间代理层实现）

创建监控复制状态账号
grant replication slave, replication client on *.* to scalemon@'192.168.137.%' identified by 'monitor18';

创建业务账号
grant all privileges on mycat.* to user_maxscale@'192.168.137.%' identified by 'H2kXvhaJxRSl';
grant select on *.* to user_maxscale@'192.168.137.%';

mkdir -p /data1/maxscale4007/log/
mkdir -p /data1/maxscale4007/data/
mkdir -p /data1/maxscale4007/cache/
mkdir -p /data1/maxscale4007/pid/
chown -R maxscale:maxscale /data1/maxscale4007
2.1.6.maxsacle创建秘钥

[root@mha-manager opt]# maxpasswd /data1/maxscale4007/data/.secrets monitor18
Failed to encode the password
[root@mha-manager opt]# maxkeys /data1/maxscale4007/data/
[root@mha-manager opt]# maxpasswd /data1/maxscale4007/data/.secrets monitor18
E2D5388FEC655E04F977AFFE91F08240
[root@mha-manager opt]# maxpasswd /data1/maxscale4007/data/.secrets H2kXvhaJxRSl
DAA9A9DD308D222752B398EBC03474EF

vim /etc/maxscale4007.cnf
[maxscale]
threads=auto
maxlog=1
log_to_shm=0
log_warning=1
log_error=1
log_notice=1
log_info=0
log_debug=0
#log_augmentation=1
LimitNOFILE=65536
logdir=/data1/maxscale4007/log/
datadir=/data1/maxscale4007/data/
cachedir=/data1/maxscale4007/cache/
piddir=/data1/maxscale4007/pid/
libdir=/usr/lib64/maxscale/
execdir=/usr/bin/

[server1]
type=server
address=192.168.137.141
port=3389
protocol=MySQLBackend

[server2]
type=server
address=192.168.137.142
port=3389
protocol=MySQLBackend

[MySQL Monitor]
type=monitor
module=mysqlmon
servers=server1,server2
user=scalemon
passwd=E2D5388FEC655E04F977AFFE91F08240