144 lines
3.0 KiB
Plaintext
Executable File
144 lines
3.0 KiB
Plaintext
Executable File
[maxscale]
|
|
threads=###threads###
|
|
log_warning=1
|
|
|
|
[MySQL-Monitor]
|
|
type=monitor
|
|
module=mysqlmon
|
|
servers= server1, server2,server3 ,server4
|
|
user=maxskysql
|
|
password= skysql
|
|
script=/###access_homedir###/script/script.sh --event=$EVENT --initiator=$INITIATOR --nodelist=$NODELIST
|
|
events=master_down,master_up, slave_up, server_down ,server_up,lost_master,lost_slave,new_master,new_slave
|
|
monitor_interval=1000
|
|
|
|
[Galera-Monitor]
|
|
type=monitor
|
|
module=galeramon
|
|
servers=gserver1,gserver2,gserver3,gserver4
|
|
script=/###access_homedir###/script/script.sh --event=$EVENT --initiator=$INITIATOR --nodelist=$NODELIST
|
|
events=master_down,master_up, slave_up, server_down ,server_up,lost_master,lost_slave,new_master,new_slave,server_down,server_up,synced_down,synced_up
|
|
disable_master_role_setting=true
|
|
root_node_as_master=false
|
|
user=maxskysql
|
|
password=skysql
|
|
monitor_interval=1000
|
|
|
|
[RW-Split-Router]
|
|
type=service
|
|
router= readwritesplit
|
|
servers=server1, server2, server3,server4
|
|
user=maxskysql
|
|
password=skysql
|
|
slave_selection_criteria=LEAST_ROUTER_CONNECTIONS
|
|
|
|
[RW-Split-Router-Galera]
|
|
type=service
|
|
router= readwritesplit
|
|
servers=gserver1,gserver2,gserver3,gserver4
|
|
user=maxskysql
|
|
password=skysql
|
|
slave_selection_criteria=LEAST_ROUTER_CONNECTIONS
|
|
|
|
[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
|
|
|
|
[RW-Split-Listener-Galera]
|
|
type=listener
|
|
service=RW-Split-Router-Galera
|
|
protocol=MySQLClient
|
|
port=4016
|
|
#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
|
|
#address=localhost
|
|
socket=default
|
|
|
|
[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
|
|
|
|
[gserver1]
|
|
type=server
|
|
address=###galera_server_IP_1###
|
|
port=###galera_server_port_1###
|
|
protocol=MySQLBackend
|
|
|
|
[gserver2]
|
|
type=server
|
|
address=###galera_server_IP_2###
|
|
port=###galera_server_port_2###
|
|
protocol=MySQLBackend
|
|
|
|
[gserver3]
|
|
type=server
|
|
address=###galera_server_IP_3###
|
|
port=###galera_server_port_3###
|
|
protocol=MySQLBackend
|
|
|
|
[gserver4]
|
|
type=server
|
|
address=###galera_server_IP_4###
|
|
port=###galera_server_port_4###
|
|
protocol=MySQLBackend
|
|
|