[MaxScale]读写分离配置记录

本文档未完成安装部分

1、基本环境信息：

# 软件版本：
192.168.40.10   MaxScale 6.1.4
192.168.40.11   Mariadb  10.6.5 (Master)
192.168.40.12   Mariadb  10.6.5 (Slave)
192.168.40.13   Mariadb  10.6.5 (Slave)

2、安装Maxscale

# 下载地址 https://downloads.mariadb.com/files/MaxScale
# 

# /etc/maxscale.cnf

[maxscale]
threads=auto
admin_secure_gui=false
admin_host=0.0.0.0
auth_connect_timeout=10s
ms_timestamp=1
syslog=1
maxlog=1
log_notice=1
log_info=0

#/etc/maxscale.cnf.d/demo1.cnf

[dbserver1]
type=server
address=192.168.40.11
port=3306
protocol=MariaDBBackend


[dbserver2]
type=server
address=192.168.40.12
port=3306
protocol=MariaDBBackend

[dbserver3]
type=server
address=192.168.40.13
port=3306
protocol=MariaDBBackend

[demo1-Monitor]
type=monitor
module=galeramon
servers=dbserver1,dbserver2,dbserver3
user=scalemon
password=password2020
monitor_interval=2000

[demo1-Service]
type=service
router=readwritesplit
servers=dbserver1,dbserver2,dbserver3
user=maxscale
password=password2020
enable_root_user=true


[demo1-Listener]
type=listener
service=demo1-Service
protocol=MariaDBClient
address=192.168.40.10
port=3306