装置rpm
yum install gnutls libaio.x86_64 libaio-devel.x86_64 novacom-server.x86_64 libedit -y
wget https://downloads.mariadb.com/MaxScale/2.2.0/centos/7server/x86_64/maxscale-2.2.0-1.centos.7.x86_64.rpm
rpm -ivh maxscale-2.2.0-1.centos.7.x86_64.rpm
MaxScale服务器批改配置
vi /etc/maxscale.cnf
[maxscale]threads=1# 主服务器 3306[server1]type=serveraddress=192.168.91.108port=3306protocol=MySQLBackend# 配置从服务器 3306[server2]type=serveraddress=192.168.91.109port=3306protocol=MySQLBackend[MySQL Monitor]type=monitormodule=mysqlmonservers=server1,server2user=rootpasswd=123456monitor_interval=10000detect_stale_master=true[Read-Write Service]type=servicerouter=readwritesplitservers=server1,server2user=rootpasswd=123456max_slave_connections=100%use_sql_variables_in=masterenable_root_user=1max_slave_replication_lag=3600[MaxAdmin Service]type=servicerouter=cli[Read-Write Listener]type=listenerservice=Read-Write Serviceprotocol=MySQLClientport=3306[MaxAdmin Listener]type=listenerservice=MaxAdmin Serviceprotocol=maxscaledsocket=default
启动maxscale服务
maxscale --config=/etc/maxscale.cnfnetstat -ntelp #次要查问3306 端口是否监听
查看maxscale 服务状态
maxadmin> list serversServers.-------------------+-----------------+-------+-------------+--------------------Server | Address | Port | Connections | Status -------------------+-----------------+-------+-------------+--------------------server1 | 主服务器ip | 10336 | 0 | Master, Runningserver2 | 从服务器ip | 10336 | 0 | Slave, Running-------------------+-----------------+-------+-------------+--------------------至此，实现MaxScale中间件实现MySQL读写拆散。