[maxscale] threads=auto # passive=true auth_connect_timeout=10 auth_read_timeout=300 users_refresh_time=1200 query_retries=5 log_throttling=8, 2000, 15000 logdir=/var/log/maxscale [server1] type=server address=workbench.XXXX.eu-west-1.rds.amazonaws.com port=3306 protocol=MariaDBBackend persistpoolmax=100 persistmaxtime=150 log_auth_warnings=true [master-server] type=server address=main.XXXX.eu-west-1.rds.amazonaws.com. port=3306 protocol=MariaDBBackend persistpoolmax=100 persistmaxtime=150 log_auth_warnings=true [this-monitor] type=monitor module=mariadbmon servers=server1,master-server user=${MAXSCALE_USER} password=${MAXSCALE_PASSWORD} monitor_interval=2000 [QueryLogger] type=filter module=qlafilter filebase=/tmp/sql-queries.log log_type=session [this-service] type=service router=readconnroute router_options=slave servers=server1 user=${MAXSCALE_USER} password=${MAXSCALE_PASSWORD} filters=QueryLogger [this-listener] type=listener service=this-service protocol=MySQLClient port=3306 authenticator_options=skip_authentication=true