[maxscale] threads = auto logdir = /var/log/maxscale/ log_info = 1 admin_enabled = 1 admin_auth = 1 admin_host = 0.0.0.0 admin_gui = 1 admin_ssl_key = /var/lib/maxscale/server-key.pem admin_ssl_cert = /var/lib/maxscale/server-cert.pem admin_ssl_ca_cert = /var/lib/maxscale/ca-cert.pem [server1] type = server address = 10.0.2.133 port = 3306 protocol = MariaDBBackend [server2] type = server address = 10.0.2.47 port = 3306 protocol = MariaDBBackend [server3] type = server address = 10.0.2.254 port = 3306 protocol = MariaDBBackend [MariaDB-Monitor] type = monitor module = mariadbmon servers = server1,server2,server3 user = maxuser password = XXXX monitor_interval = 5000ms [Database-Firewall] type = filter module = dbfwfilter action = block rules = /etc/maxscale.modules.d/firewall.txt [Read-Write-Listener] type = listener service = Read-Write-Service protocol = MariaDBClient port = 4006 [Database-Firewall-Listener] type = listener service = Database-Firewall-Service protocol = MariaDBClient port = 4004 [Read-Write-Service] type = service router = readwritesplit servers = server1,server2,server3 user = maxuser password = XXXX max_sescmd_history = 1500 causal_reads = 1 causal_reads_timeout = 10s transaction_replay = 1 transaction_replay_max_size = 1Mi delayed_retry = 1 master_reconnection = 1 master_failure_mode = fail_on_write [Database-Firewall-Service] type = service router = readconnroute servers = server1 user = maxuser password = XXXX filters = Database-Firewall