,server2
#maxscale监控账户
user=monitor
passwd=5A23832649A7C09A5011B99813491542
每隔2s执行监控检查
monitor_interval=2000
#检查复制延迟
detect_replication_lag=true
#当全部slave都不可用时,select查询请求会转发到master。
detect_stale_master=true
# Service definitions
#
# Service Definition for a read-only service
#
# ReadConnRoute documentation:
# https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-22-readconnroute/
# [Read-Only-Service]
# type=service
# router=readconnroute
# servers=server1
# user=myuser
# passwd=mypwd
# router_options=slave
# a read/write splitting service.
# ReadWriteSplit documentation:
#
#maxscale的读写分离服务
[Read-Write-Service]
type=service
router=readwritesplit
servers=server1,server2
#maxscale路由账户
user=router
passwd=5A23832649A7C09A5011B99813491542
#全部slave提供select查询服务
max_slave_connections=100%
#slave超时5秒,请求转发到其他slave
max_slave_replication_lag=5
#预先设置会话变量,例如 set character_set_connection=utf8,character_set_results=utf8,character_set_client=binary
默认是all,在master与slave上执行,设置为master,将只会路由到master执行
use_sql_variables_in=all
#允许root用户登录
enable_root_user=1
# This service enables the use of the MaxAdmin interface
# MaxScale administration guide:
#
#maxscale的管理服务
[MaxAdmin-Service]
type=service
router=cli
# Listener definitions for the services
#
# These listeners represent the ports the
# services will listen on.
#
# [Read-Only-Listener]
# type=listener
# service=Read-Only-Service
# protocol=MariaDBClient
# port=4008
#maxscale读写分离服务的监听端口
[Read-Write-Listener]
type=listener
service=Read-Write-Service
protocol=MariaDBClient
port=4006
#maxscale管理服务的监听端口
[MaxAdmin-Listener]
type=listener
service=MaxAdmin-Service
protocol=maxscaled
socket=default
[root@wallet03 ~]# /etc/init.d/maxscale start
Starting MaxScale: maxscale (pid 1500) is running... [ OK ]
[root@wallet03 ~]# /etc/init.d/maxscale status
Checking MaxScale status: MaxScale (pid 1500) is running..[ OK ]
[root@wallet03 ~]# mysql -utpcc -ptpcc -P 4006 -h 192.168.1.200
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| wallet02 |
+------------+
[root@wallet03 ~]# maxadmin -S /tmp/maxadmin.sock
MaxScale> list servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server &nbs |