[MaxScale]
threads=auto
ms_timestamp=1
maxlog=1
#log_debug=1
#log_info=1
log_notice=1
logdir=/datavolume/maxscale/log
datadir=/datavolume/maxscale/data
cachedir=/datavolume/maxscale/cache
#piddir=/MXS/
writeq_high_water=32M
writeq_low_water=512K


[MaxInfo]
type=service
router=maxinfo
user=wjmonitor
password=xxx

[MaxInfo-JSON]
type=listener
service=MaxInfo
protocol=HTTPD
port=8003

[CLI]
type=service
router=cli

[MaxAdmin_Unix_Listener]
type=listener
service=CLI
protocol=maxscaled
socket=default

[MaxRows]
type=filter
module=maxrows
max_resultset_size=5Gi
max_resultset_return=error

[tblw]
type=service
router=readconnroute
servers=tblw01,tblw02,tblw03,tblw04,tblw05
#servers=server1
user=wjmaxscale
password=xxx
enable_root_user=1
#strict_multi_stmt=false
#strict_sp_calls=false
#use_sql_variables_in=master
#weightby=serv_weight
#disable_sescmd_history=true
filters=MaxRows
#slave_selection_criteria=LEAST_CURRENT_OPERATIONS
#master_failure_mode=fail_instantly
#max_slave_connections=255
#retry_failed_reads=true
#max_sescmd_history=0
#connection_keepalive=0
router_options=synced
#router_options=running


[lsnr_tblw]
type=listener
service=tblw
protocol=MariaDBClient
#socket=/MXS/mysql.sock
port=33306
address=0.0.0.0
authenticator_options=lower_case_table_names=true

[mon_tblw]
type=monitor
module=galeramon
#module=mariadbmon
servers=tblw01,tblw02,tblw03,tblw04,tblw05
#servers=server1
#disable_master_failback=1
user=wjmaxscale
password=xxx
monitor_interval=10000
backend_connect_timeout=600
backend_write_timeout=10
backend_read_timeout=10
use_priority=true

[tblw01]
type=server
address=21.105.20.132
port=33306
protocol=MySQLBackend
priority=1
serv_weight=2
persistpoolmax=1000
persistmaxtime=500

[tblw02]
type=server
address=21.105.20.133
port=33306
protocol=MySQLBackend
priority=2
serv_weight=4
persistpoolmax=1000
persistmaxtime=500

[tblw03]
type=server
address=21.105.20.134
port=33306
protocol=MySQLBackend
priority=2
serv_weight=4
persistpoolmax=1000
persistmaxtime=500


[tblw04]
type=server
address=21.105.20.135
port=33306
protocol=MySQLBackend
priority=2
serv_weight=4
persistpoolmax=1000
persistmaxtime=500


[tblw05]
type=server
address=21.105.20.136
port=33306
protocol=MySQLBackend
priority=2
serv_weight=4
persistpoolmax=1000
persistmaxtime=500