[maxscale]
threads=auto
logdir=/maxscale/log/
syslog=false
debug=gdb-stacktrace

##MaxGUI##
admin_secure_gui=false
admin_host=0.0.0.0
admin_port=8989

#------------------
[server1]
type=server
address=40.222.xx.x
port=2866
protocol=MariaDBBackend

[server2]
type=server
address=40.222.xx.xx
port=2866
protocol=MariaDBBackend

[server3]
type=server
address=40.222.xx.xx
port=2866
protocol=MariaDBBackend

#------------------
[RW_Listener]
type=listener
service=RW_Service
protocol=MariaDBClient
port=2866
address=0.0.0.0

[RW_Service]
type=service
connection_keepalive=0s
router=readwritesplit
servers=server1,server2,server3
#servers=server1
user=PPFMMON
#####after outputs - maxkeys > maxpasswd 'xxxxx'
password=BFC25790D4780DCFDEE04E236F286776AF2F17AA282DBD0F82D66DC612A15AC9

####only used in readwritesplit
use_sql_variables_in=master
master_accept_reads=false
transaction_replay=true
delayed_retry=true
master_reconnection=true
master_failure_mode=error_on_write
slave_selection_criteria=LEAST_ROUTER_CONNECTIONS
strict_multi_stmt=false
strict_sp_calls=false
disable_sescmd_history=false
max_sescmd_history=50
prune_sescmd_history=true
filters=Hint

##causal read : mysqld variables(session_track_system_variables=last_gtid)
#max_slave_replication_lag=30000s
max_slave_replication_lag=30s
causal_reads=local
causal_reads_timeout=2s

[Hint]
type=filter
module=hintfilter

#------------------
[MariaDB_Monitor]
type=monitor
module=mariadbmon
servers=server1,server2,server3
#servers=server1
user=PPFMMON
#after outputs - maxkeys 'xxx'
password=BFC25790D4780DCFDEE04E236F286776AF2F17AA282DBD0F82D66DC612A15AC9
monitor_interval=2000ms
enforce_read_only_slaves=true

##HA Function All disabled
#cooperative_monitoring_locks=majority_of_running

#servers_no_promotion=server2,server3
auto_failover=false
auto_rejoin=false
handle_events=off
replication_user=repl_user
#after outputs - maxkeys > maxpasswd 'plain-text'
replication_password=162845CEC6C274083736CEE7BD9E2A324B70A780D103EA62A19AD39CBA71EB4A

#end

#------------------