maxscale配置文件

[maxscale]
threads=4

##### Write Service, need to set address
[server1]
type=server
address=192.168.0.*
port=3306
protocol=MySQLBackend
sunlight_weight=1

##### Read Service, need to set address
[server2]
type=server
address=192.168.0.*
port=3306
protocol=MySQLBackend
sunlight_weight=4

##### Read Service, need to set address
[server3]
type=server
address=192.168.0.*
port=3306
protocol=MySQLBackend
sunlight_weight=5

[Galera Monitor]
type=monitor
module=galeramon
servers=server1,server2,server3
user=root
passwd=****


[Read-Write Service]
type=service
router=readwritesplit
servers=server1,server2,server3
user=root
passwd=*****
max_slave_connections=100%
enable_root_user=1
weightby=sunlight_weight

[Read-Write Listener]
type=listener
service=Read-Write Service
protocol=MySQLClient
port=4006

[MaxAdmin Service]
type=service
router=cli

[MaxAdmin Listener]
type=listener
service=MaxAdmin Service
protocol=maxscaled
socket=default
port=6603

posted on 2018-01-09 11:52  天涯飞鸿  阅读(358)  评论(0)    收藏  举报

导航