56 lines
910 B
Plaintext
Executable File
56 lines
910 B
Plaintext
Executable File
[maxscale]
|
|
threads=###threads###
|
|
log_warning=1
|
|
|
|
[hints]
|
|
type=filter
|
|
module=hintfilter
|
|
|
|
[RW-Split-Router]
|
|
type=service
|
|
router=readwritesplit
|
|
servers=server1,server2,server3,server4
|
|
max_slave_connections=100%
|
|
use_sql_variables_in=master
|
|
slave_selection_criteria=LEAST_BEHIND_MASTER
|
|
user=maxskysql
|
|
password=skysql
|
|
filters=hints
|
|
|
|
[Client-Interface]
|
|
type=service
|
|
router=cli
|
|
|
|
[RW-Split-Listener]
|
|
type=listener
|
|
service=RW-Split-Router
|
|
protocol=MySQLClient
|
|
port=4006
|
|
socket=/tmp/rwsplit.sock
|
|
|
|
[server1]
|
|
type=server
|
|
address=###node_server_IP_1###
|
|
port=###node_server_port_1###
|
|
protocol=MySQLBackend
|
|
|
|
[server2]
|
|
type=server
|
|
address=###node_server_IP_2###
|
|
port=###node_server_port_2###
|
|
protocol=MySQLBackend
|
|
|
|
[server3]
|
|
type=server
|
|
address=###node_server_IP_3###
|
|
port=###node_server_port_3###
|
|
protocol=MySQLBackend
|
|
|
|
[server4]
|
|
type=server
|
|
address=###node_server_IP_4###
|
|
port=###node_server_port_4###
|
|
protocol=MySQLBackend
|
|
|
|
|