maxscale启动有问题
来源:5-20 MaxScale实例演示

zhusx
2021-06-24
操作系统:centos7
maxscale版本:maxscale-2.0.1-2.centos.7.x86_64.rpm
docker部署的3个mysql容器, mysql做为主服务器,mysql2,mysql3作为从服务器, 主从复制已配置成功(已验证主库的ddl会同步到另外两个从库)。
maxscale启动没有报错,但是4006端口没有监听,只有监听6603.
进入maxadmin控制台,list servers, 有看到三个服务,但是状态都是down, 查看缓存的用户信息:show dbusers “Read-Write Service”, 提示:Invalid argument: Read-Write Service。
附上完整的配置:maxscale.cnf
[maxscale]
threads=1
[server1]
type=server
address=1.116.26.66
port=3306
protocol=MySQLBackend
[server2]
type=server
address=1.116.26.66
port=3307
protocol=MySQLBackend
[server3]
type=server
address=1.116.26.66
port=3308
protocol=MySQLBackend
[MySQL Monitor]
type=monitor
module=mysqlmon
servers=server1,server2,server3
user=scalemon
passwd=123456
monitor_interval=1000
[Read-Write Service]
type=service
router=readwritesplit
servers=server1,server2,server3
user=maxscale
passwd=123456
max_slave_connections=100%
max_slave_replication_lag=60
[MaxAdmin Service]
type=service
router=cli
[Read-Write Listener]
type=listener
service=Read-Write Service
protocol=MySQLClient
port=4006
[MaxAdmin Listener]
type=listener
service=MaxAdmin Service
protocol=maxscaled
port=6603
socket=default
1回答
-
sqlercn
2021-06-26
MySQL是什么版本的?
022021-07-09
相似问题