一个80后
程序员的笔记

[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
赞(0) 打赏
未经允许不得转载:笨笨天地 » [MaxScale]读写分离配置记录
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏