[maxscale]

threads=4

skip_name_resolve=true

auth_connect_timeout=20s

query_retries=2

query_classifier_cache_size=0 *(with and without this options)*

writeq_high_water=0 *(with and without this options)*

writeq_low_water=0 *(with and without this options)*

[server1]

type=server

address=1.1.1.1

port=3306

extra_port=8385

proxy_protocol=true

persistpoolmax=500 *(with and without this options)*

#persistmaxtime=5m *(with and without this options)*

protocol=MariaDBBackend

[server2]

type=server

address=1.1.1.2

port=3306

extra_port=8385

proxy_protocol=true

persistpoolmax=500 *(with and without this options)*

#persistmaxtime=5m *(with and without this options)*

protocol=MariaDBBackend

[server3]

type=server

address=1.1.1.3

port=3306

extra_port=8385

proxy_protocol=true

persistpoolmax=500 *(with and without this options)*

#persistmaxtime=5m *(with and without this options)*

protocol=MariaDBBackend

[Replication-Monitor]

type=monitor

module=mariadbmon

servers=server1, server2, server3

user=maxscale

password=passwd

failcount=5

monitor_interval=2s

backend_connect_timeout=3s

backend_connect_attempts=2

backend_write_timeout=60s

backend_read_timeout=60s

auto_failover=true

auto_rejoin=true

enforce_read_only_slaves=on

enforce_simple_topology=true

cooperative_monitoring_locks=majority_of_running

[Write-Service]

type=service

router=readconnroute

router_options=master

connection_keepalive=0s

servers=server1, server2, server3

user=maxscale

password=passwd

[Read-Service]

type=service

router=readconnroute

router_options=slave

connection_keepalive=0s

servers=server1, server2, server3

user=maxscale

password=passwd

[Write-Listener]

type=listener

service=Write-Service

protocol=MariaDBClient

port=33306

[Read-Listener]

type=listener

service=Read-Service

protocol=MariaDBClient

port=33307