MariaDB MaxScale
1.安装 MaxScale
curl -sS hps://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
yum install maxscale
2.创建相关用户
创建监控用户
create user 'scalemon'@'%' iden#$ed by '123456';
grant replica#on slave, replica#on client on *.* to 'scalemon'@'%';
创建路由用户
create user 'maxscale'@'%' iden#$ed by '123456';
grant select on mysql.* to 'maxscale'@'%';
用户创建完成后,开始配置
3.修改/etc/maxscale.cnf
修改
[server1]
type=server
address=192.168.11.136
port=3306
protocol=MariaDBBackend
[server2]
type=server
address=192.168.11.137
port=3306
protocol=MariaDBBackend
评论0
最新资源