环境:centos7 mysql5.7
推荐:主从复制,MHA 高可用搭建:/hailanzi/article/details/82183987
master: 192.168.0.180
slave1:192.168.0.160
slave2:192.168.0.154
master 为主,slave1(备主)和slave2 为从 ,本地资源有限我把maxscale 安装在 slave2 上
一、maxscale安装
安装依赖关系
yum install libaio.x86_64 libaio-devel.x86_64 novacom-server.x86_64 libedit -y
MaxScale的下载地址:
官网下载:/files/MaxScale
下载 maxscale rpm 包
wget /MaxScale/2.1.0/centos/7server/x86_64/maxscale-2.1.0-1.centos.7.x86_64.rpm
安装maxscale rpm 包
rpm -ivh maxscale-2.1.0-1.centos.7.x86_64.rpm
在master 上创建监控用户
mysql> grant replication slave,replication client on *.* to scalemon@'%' identified by '123456';
在master 上创建路由用户
mysql> grant select on mysql.* to maxscale@'%' identified by '123456';
mysql> flush privileges;
在slave2 上配置Maxscale服务,配置文件如下:
vi /etc/f
[server1]
type=server
address=192.168.0.154
port=3306
protocol=MySQLBackend
[server2]
type=server
address=192.168.0.160
port=3306
protocol=MySQLBackend
[server3]
type=server
address=192.168.0.180
port=3306
protocol=MySQLBackend
#[Read-Only Service] //注释掉或者删掉这个模块
#type=service
#router=readconnroute
#servers=server1
#user=myuser
#passwd=mypwd
#router_options=slave
[MySQL Monitor]
type=monitor
module=mysqlmon
servers=server1,server2,server3
user=scalemon // 监控用户
passwd=123456 // 监控用户密码
monitor_interval=10000
#[Read-Only Listener] //注释掉或者删掉这个模块
#type=listener
#service=Read-Only Service
#protocol=MySQLClient
#port=4008
[Read-Write Service]
type=service
router=readwritesplit
servers=server1,server2,server3
user=maxscale // 路由用户
passwd=123456 // 路由用户密码
max_slave_connections=100%
启动服务
[root@localhost ~]# maxscale --config=/etc/f
* Error: Failed to open PID file '/var/run/maxscale/maxscale.pid'. (No such file or directory)
报错一个找不到进程的错
//找不到进程 卸载重新安装
[root@localhost src]# rpm -e maxscale-2.1.0-1.x86_64
//重新安装
[root@localhost src]# rpm -ivh maxscale-2.1.0-1.centos.7.x86_64.rpm
测试参考连接/darren-lee/p/7591416.html