# MaxScale documentation: # https://mariadb.com/kb/en/mariadb-maxscale-6/ # Global parameters # # Complete list of configuration options: # https://mariadb.com/kb/en/mariadb-maxscale-6-mariadb-maxscale-configuration-guide/ [maxscale] threads=auto skip_name_resolve=ON # Server definitions # # Set the address of the server to the network # address of a MariaDB server. # [server1] type=server address=172.31.81.1xx port=3306 protocol=MariaDBBackend # Monitor for the servers # # This will keep MaxScale aware of the state of the servers. # MariaDB Monitor documentation: # https://mariadb.com/kb/en/maxscale-6-monitors/ [MariaDB-Monitor] type=monitor module=mariadbmon servers=server1 user=max_user password=R00txxx monitor_interval=2000 # Service definitions # # Service Definition for a read-only service and # a read/write splitting service. # # ReadConnRoute documentation: # https://mariadb.com/kb/en/mariadb-maxscale-6-readconnroute/ #[Read-Only-Service] #type=service #router=readconnroute #servers=server1 #user=myuser #password=mypwd #router_options=slave # ReadWriteSplit documentation: # https://mariadb.com/kb/en/mariadb-maxscale-6-readwritesplit/ [Read-Write-Service] type=service router=readwritesplit servers=server1 user=max_user password=R00txxxx master_accept_reads=true enable_root_user=true max_connections=1000 log_auth_warnings=true # Listener definitions for the services # # These listeners represent the ports the # services will listen on. # #[Read-Only-Listener] #type=listener #service=Read-Only-Service #protocol=MariaDBClient #port=4008 [Read-Write-Listener] type=listener service=Read-Write-Service protocol=MariaDBClient port=4006