80 lines
1.2 KiB
Plaintext
Executable File
80 lines
1.2 KiB
Plaintext
Executable File
[maxscale]
|
|
threads=###threads###
|
|
log_warning=1
|
|
|
|
[MySQL-Monitor]
|
|
type=monitor
|
|
module=mysqlmon
|
|
servers=###server_line###
|
|
user=maxskysql
|
|
password= skysql
|
|
|
|
[hints]
|
|
type=filter
|
|
module=hintfilter
|
|
|
|
[regex]
|
|
type=filter
|
|
module=regexfilter
|
|
match=fetch
|
|
replace=select
|
|
|
|
[RW-Split-Router]
|
|
type=service
|
|
router= readwritesplit
|
|
servers=###server_line###
|
|
user=maxskysql
|
|
password=skysql
|
|
max_slave_connections=100%
|
|
use_sql_variables_in=all
|
|
slave_selection_criteria=LEAST_BEHIND_MASTER
|
|
filters=regex|hints
|
|
|
|
[Read-Connection-Router-Slave]
|
|
type=service
|
|
router=readconnroute
|
|
router_options= slave
|
|
servers=server1,server2,server3,server4
|
|
user=maxskysql
|
|
password=skysql
|
|
|
|
[Read-Connection-Router-Master]
|
|
type=service
|
|
router=readconnroute
|
|
router_options=master
|
|
servers=server1,server2,server3,server4
|
|
user=maxskysql
|
|
password=skysql
|
|
|
|
[RW-Split-Listener]
|
|
type=listener
|
|
service=RW-Split-Router
|
|
protocol=MySQLClient
|
|
port=4006
|
|
#socket=/tmp/rwsplit.sock
|
|
|
|
[Read-Connection-Listener-Slave]
|
|
type=listener
|
|
service=Read-Connection-Router-Slave
|
|
protocol=MySQLClient
|
|
port=4009
|
|
|
|
[Read-Connection-Listener-Master]
|
|
type=listener
|
|
service=Read-Connection-Router-Master
|
|
protocol=MySQLClient
|
|
port=4008
|
|
|
|
[CLI]
|
|
type=service
|
|
router=cli
|
|
|
|
[CLI-Listener]
|
|
type=listener
|
|
service=CLI
|
|
protocol=maxscaled
|
|
|
|
socket=default
|
|
|
|
###server###
|