# https://mariadb.com/kb/en/mariadb-maxscale-25-mariadb-maxscale-configuration-guide/

[maxscale]
threads=4
admin_host                              =       rndmax401
admin_port                              =       8080
query_retries                           =       5
admin_secure_gui                        =       false
admin_pam_readonly_service              =       maxscale
maxlog                                  =       1
auth_read_timeout                       =       10s
#log_info                               =       1
session_trace                           =       200
#[CCRFilter]
#type                                    =       filter
#module                                  =       ccrfilter
#time                                    =       5

[split-router-cache]
type                                    =       filter
module                                  =       cache
hard_ttl                                =       300s
##soft_ttl                              =       25s
storage                                 =       storage_redis
storage_options                         =       server=10.14x.x.xx:6379
enabled                                 =       true
cached_data                             =       shared
invalidate                              =       current
debug                                   =       1
clear_cache_on_parse_errors             =       true
###############################################################################################################
#######################################  TRACK4 Maxscale Configuration  #######################################
###############################################################################################################


[server1-3306]
type                                    =       server
address                                 =       10.1xx.x.xx
port                                    =       3306
priority                                =       1
proxy_protocol                          =       on

[server2-3306]
type                                    =       server
address                                 =       10.1xx.x.xx
port                                    =       3306
priority                                =       2
proxy_protocol                          =       on


[server3-3306]
type                                    =       server
address                                 =       10.1xx.x.xx
port                                    =       3306
priority                                =       3
proxy_protocol                          =       on


[Galera-Monitor-3306]
type                                    =       monitor
module                                  =       galeramon
servers                                 =       server1-3306, server2-3306, server3-3306
user                                    =       maxscale
password                                =       XXXXXX
#disable_master_failback                =       true
root_node_as_master                     =       false
use_priority                            =       true
available_when_donor                    =       true

######################################### non AD users ########################################################

[Splitter-Service-3306]
type                                    =       service
router                                  =       readwritesplit
servers                                 =       server1-3306, server2-3306, server3-3306
user                                    =       maxscale
password                                =       XXXXXX
slave_selection_criteria                =       LEAST_CURRENT_OPERATIONS
#disable_sescmd_history                 =       true
use_sql_variables_in                    =       master
strict_sp_calls                         =       true
connection_timeout                      =       3000s
strict_multi_stmt                       =       true
prune_sescmd_history                    =       true
max_sescmd_history                      =       25
master_reconnection                     =       true
filters                                 =       split-router-cache

[Splitter-Listener-3306]
type                                    =       listener
service                                 =       Splitter-Service-3306
protocol                                =       MariaDBClient
port                                    =       3306
authenticator                           =       mariadbauth
address                                 =       0.0.0.0

########################################## AD users #########################################################
[Splitter-ServiceAD-3306]
type                                    =       service
router                                  =       readwritesplit
servers                                 =       server1-3306, server2-3306, server3-3306
user                                    =       maxscale
password                                =       XXXXXX
slave_selection_criteria                =       LEAST_CURRENT_OPERATIONS
#disable_sescmd_history                 =       true
use_sql_variables_in                    =       master
strict_sp_calls                         =       true
connection_timeout                      =       3000s
strict_multi_stmt                       =       true
prune_sescmd_history                    =       true
max_sescmd_history                      =       25
master_reconnection                     =       true

[Splitter-ListenerAD-3306]
type                                    =       listener
service                                 =       Splitter-ServiceAD-3306
protocol                                =       mariadbclient
port                                    =       9994
authenticator                           =       PAMAuth
address                                 =       0.0.0.0