133 lines
2.0 KiB
Plaintext
133 lines
2.0 KiB
Plaintext
[maxscale]
|
|
threads=4
|
|
admin_auth=false
|
|
log_info=1
|
|
admin_host=::
|
|
|
|
[MySQL-Monitor]
|
|
type=monitor
|
|
module=mysqlmon
|
|
servers=server1,server2,server3,server4
|
|
user=maxskysql
|
|
password=skysql
|
|
monitor_interval=10000
|
|
|
|
[RW-Split-Router]
|
|
type=service
|
|
router=readwritesplit
|
|
servers=server1,server2,server3,server4
|
|
user=maxskysql
|
|
password=skysql
|
|
max_slave_connections=100%
|
|
|
|
[SchemaRouter-Router]
|
|
type=service
|
|
router=schemarouter
|
|
servers=server1,server2,server3,server4
|
|
user=maxskysql
|
|
password=skysql
|
|
auth_all_servers=1
|
|
|
|
[RW-Split-Hint-Router]
|
|
type=service
|
|
router=readwritesplit
|
|
servers=server1,server2,server3,server4
|
|
user=maxskysql
|
|
password=skysql
|
|
max_slave_connections=100%
|
|
filters=Hint
|
|
|
|
[Read-Connection-Router]
|
|
type=service
|
|
router=readconnroute
|
|
router_options=master
|
|
servers=server1
|
|
user=maxskysql
|
|
password=skysql
|
|
filters=QLA
|
|
|
|
[Hint]
|
|
type=filter
|
|
module=hintfilter
|
|
|
|
[recurse3]
|
|
type=filter
|
|
module=tee
|
|
service=RW-Split-Router
|
|
|
|
[recurse2]
|
|
type=filter
|
|
module=tee
|
|
service=Read-Connection-Router
|
|
|
|
[recurse1]
|
|
type=filter
|
|
module=tee
|
|
service=RW-Split-Hint-Router
|
|
|
|
[QLA]
|
|
type=filter
|
|
module=qlafilter
|
|
log_type=unified
|
|
append=false
|
|
flush=true
|
|
filebase=/tmp/qla.log
|
|
|
|
[CLI]
|
|
type=service
|
|
router=cli
|
|
|
|
[Read-Connection-Listener]
|
|
type=listener
|
|
service=Read-Connection-Router
|
|
protocol=MySQLClient
|
|
port=4008
|
|
|
|
[RW-Split-Listener]
|
|
type=listener
|
|
service=RW-Split-Router
|
|
protocol=MySQLClient
|
|
port=4006
|
|
|
|
[SchemaRouter-Listener]
|
|
type=listener
|
|
service=SchemaRouter-Router
|
|
protocol=MySQLClient
|
|
port=4010
|
|
|
|
[RW-Split-Hint-Listener]
|
|
type=listener
|
|
service=RW-Split-Hint-Router
|
|
protocol=MySQLClient
|
|
port=4009
|
|
|
|
[CLI-Listener]
|
|
type=listener
|
|
service=CLI
|
|
protocol=maxscaled
|
|
socket=default
|
|
|
|
[server1]
|
|
type=server
|
|
address=###node_server_IP_1###
|
|
port=###node_server_port_1###
|
|
protocol=MySQLBackend
|
|
|
|
[server2]
|
|
type=server
|
|
address=###node_server_IP_2###
|
|
port=###node_server_port_2###
|
|
protocol=MySQLBackend
|
|
|
|
[server3]
|
|
type=server
|
|
address=###node_server_IP_3###
|
|
port=###node_server_port_3###
|
|
protocol=MySQLBackend
|
|
|
|
[server4]
|
|
type=server
|
|
address=###node_server_IP_4###
|
|
port=###node_server_port_4###
|
|
protocol=MySQLBackend
|