neverlock
7/1/2017 - 7:13 AM

maxscale.cbf

maxscale]
threads=4

[Galera Monitor]
type=monitor
module=galeramon
servers=svr_10095,svr_10096,svr_10097
user=maxadmin
passwd=jkdskjsdfkjlfdskjdsfkjsdjkf
monitor_interval=10000
disable_master_failback=1

[MyCache]
type=filter
module=cache
storage=storage_inmemory
soft_ttl=30
hard_ttl=45
cached_data=shared
max_size=500Mi
selects=assume_cacheable

[fetch]
type=filter
module=regexfilter
match=fetch
replace=select

[RW]
type=service
router=readwritesplit
servers=svr_10095,svr_10096,svr_10097
user=maxadmin
passwd=ioldskjlsdfjksdfjksdfjlksdfjksdfjklsdf
max_slave_connections=100%
router_options=slave_selection_criteria=LEAST_CURRENT_OPERATIONS

[RR]
type=service
router=readconnroute
router_options=synced
servers=svr_10095,svr_10096,svr_10097
user=maxadmin
passwd=kjdsjklsdfjksdfkjlsdfjksdfjksdfjksdfkl
filters=MyCache
[DebugInterface]
type=service
router=debugcli

[CLI]
type=service
router=cli

[RWlistener3308]
type=listener
service=RW
protocol=MySQLClient
address=0.0.0.0
port=3308

[RWlistener3309]
type=listener
service=RR
protocol=MySQLClient
address=0.0.0.0
port=3309

[RWlistener]
type=listener
service=RW
protocol=MySQLClient
address=0.0.0.0
port=4008

[RRlistener]
type=listener
service=RR
protocol=MySQLClient
address=0.0.0.0
port=4006

[Debug Listener]
type=listener
service=DebugInterface
protocol=telnetd
address=127.0.0.1
port=4442
[CLI Listener]
type=listener
service=CLI
protocol=maxscaled
address=127.0.0.1
port=6603

[svr_10095]
type=server
address=10.0.9.5
port=3306
protocol=MySQLBackend

[svr_10096]
type=server
address=10.0.9.6
port=3306
protocol=MySQLBackend

[svr_10097]
type=server
address=10.0.9.7
port=3306
protocol=MySQLBackend