151 lines
2.3 KiB
Plaintext
151 lines
2.3 KiB
Plaintext
[maxscale]
|
|
threads=###threads###
|
|
log_warning=1
|
|
log_debug=1
|
|
|
|
[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
|
|
|
|
[Monitor1]
|
|
type=monitor
|
|
module=mariadbmon
|
|
servers=server1
|
|
user=maxskysql
|
|
password=skysql
|
|
monitor_interval=1000
|
|
|
|
[Monitor2]
|
|
type=monitor
|
|
module=mariadbmon
|
|
servers=server2
|
|
user=maxskysql
|
|
password=skysql
|
|
monitor_interval=1000
|
|
|
|
[Monitor3]
|
|
type=monitor
|
|
module=mariadbmon
|
|
servers=server3
|
|
user=maxskysql
|
|
password=skysql
|
|
monitor_interval=1000
|
|
|
|
[Monitor4]
|
|
type=monitor
|
|
module=mariadbmon
|
|
servers=server4
|
|
user=maxskysql
|
|
password=skysql
|
|
monitor_interval=1000
|
|
|
|
[RWS1]
|
|
type=service
|
|
router=readwritesplit
|
|
servers=server1
|
|
user=maxskysql
|
|
password=skysql
|
|
slave_selection_criteria=ADAPTIVE_ROUTING
|
|
|
|
[RWS1-Listener]
|
|
type=listener
|
|
service=RWS1
|
|
protocol=mariadbclient
|
|
socket=/tmp/rws1.sock
|
|
|
|
[RWS1-As-Server]
|
|
type=server
|
|
protocol=mariadbbackend
|
|
socket=/tmp/rws1.sock
|
|
|
|
[RWS2]
|
|
type=service
|
|
router=readwritesplit
|
|
servers=server2
|
|
user=maxskysql
|
|
password=skysql
|
|
slave_selection_criteria=ADAPTIVE_ROUTING
|
|
|
|
[RWS2-Listener]
|
|
type=listener
|
|
service=RWS2
|
|
protocol=mariadbclient
|
|
socket=/tmp/rws2.sock
|
|
|
|
[RWS2-As-Server]
|
|
type=server
|
|
protocol=mariadbbackend
|
|
socket=/tmp/rws2.sock
|
|
|
|
[RWS3]
|
|
type=service
|
|
router=readwritesplit
|
|
servers=server3
|
|
user=maxskysql
|
|
password=skysql
|
|
slave_selection_criteria=ADAPTIVE_ROUTING
|
|
|
|
[RWS3-Listener]
|
|
type=listener
|
|
service=RWS3
|
|
protocol=mariadbclient
|
|
socket=/tmp/rws3.sock
|
|
|
|
[RWS3-As-Server]
|
|
type=server
|
|
protocol=mariadbbackend
|
|
socket=/tmp/rws3.sock
|
|
|
|
[RWS4]
|
|
type=service
|
|
router=readwritesplit
|
|
servers=server4
|
|
user=maxskysql
|
|
password=skysql
|
|
slave_selection_criteria=ADAPTIVE_ROUTING
|
|
|
|
[RWS4-Listener]
|
|
type=listener
|
|
service=RWS4
|
|
protocol=mariadbclient
|
|
socket=/tmp/rws4.sock
|
|
|
|
[RWS4-As-Server]
|
|
type=server
|
|
protocol=mariadbbackend
|
|
socket=/tmp/rws4.sock
|
|
|
|
[SmartQuery]
|
|
type=service
|
|
router=smartrouter
|
|
servers=RWS1-As-Server, RWS2-As-Server, RWS3-As-Server, RWS4-As-Server
|
|
master=RWS1-As-Server
|
|
user=maxskysql
|
|
password=skysql
|
|
|
|
[SmartQuery-Listener]
|
|
type=listener
|
|
service=SmartQuery
|
|
protocol=mariadbclient
|
|
port=4006
|