[maxscale]

threads=auto

user=maxscale

ms_timestamp=1

syslog=0

maxlog=1

log_to_shm=0

log_warning=1

log_notice=0

log_info=0

log_debug=0

log_augmentation=0

logdir=/data/maxscale/logs/trace/

datadir=/data/maxscale/data/

libdir=/usr/local/maxscale/lib/maxscale/

cachedir=/data/maxscale/cache/

piddir=/data/maxscale/pid/

execdir=/usr/bin/

[server1]

type=server

address=172.100.10.7

port=3306

protocol=MySQLBackend

serv_weight=3

priority=2

[server2]

type=server

address=172.100.10.6

port=3306

protocol=MySQLBackend

serv_weight=3

priority=1

[Galera Monitor]

type=monitor

module=galeramon

servers=server1,server2

user=maxscale

passwd=password

monitor_interval=10000

use_priority = true

[Read-Write Service]

type=service

router=readwritesplit

servers=server1,server2

user=maxscale

passwd=password

max_slave_connections=100%

weightby=serv_weight

[MaxAdmin Service]

type=service

router=cli

[Read-Write Listener]

type=listener

address = 0.0.0.0

service=Read-Write Service

protocol=MySQLClient

port=4006

[MaxAdmin Listener]

address = 0.0.0.0

type=listener

service=MaxAdmin Service

protocol=maxscaled

port=6603

# ss  -tan|awk 'NR>1{++S[$1]}END{for (a in S) print a,S[a]}'

LISTEN 15

ESTAB 5371

FIN-WAIT-1 8

FIN-WAIT-2 904

TIME-WAIT 99

# ss -a|grep 4006|wc -l

1555

# ss -a|grep 3306|wc -l

3111

# mysql -uroot -p -A test -e "show processlist;"|wc -l

123