2、maxscale安装curl-sS/MariaDB/mariadb_repo_setup|sudobash-s----mariadb-maxscale-version="2.3"
yumsearchmaxscale
sudoyuminstallmaxscale
maxkeys/var/lib/maxscale/
maxpasswd/var/lib/maxscale/123456
chownmaxscale.maxscale/var/lib/maxscale/.secrets
vim/etc/f
systemctlstartmaxscale
systemctlstatusmaxscale.service
cd/var/log/maxscale/
vimmaxscale.log
systemctlstartmaxscale
3、maxscale配置文件[root@mgr1maxscale]#cat/etc/f
#MaxScaledocumentation:
#/kb/en/mariadb-enterprise/mariadb-maxscale-23/
#Globalparameters
#
#Completelistofconfigurationoptions:
#/kb/en/mariadb-maxscale-23-mariadb-maxscale-configuration-usage-scenarios/
[maxscale]
threads=auto
#Serverdefinitions
#
#Settheaddressoftheservertothenetwork
#addressofaMariaDBserver.
#
[server1]
type=server
address=192.168.56.14
port=3306
protocol=MariaDBBackend
[server2]
type=server
address=192.168.56.15
port=3306
protocol=MariaDBBackend
[server3]
type=server
address=192.168.56.16
port=3306
protocol=MariaDBBackend
#Monitorfortheservers
#
#ThiswillkeepMaxScaleawareofthestateoftheservers.
#MariaDBMonitordocumentation:
#/kb/en/mariadb-maxscale-23-mariadb-monitor/
[MariaDB-Monitor]
type=monitor
module=mariadbmon
servers=server1,server2,server3
user=orchestrator
password=0FFC28BC3A8F402F10B0B798E347FD9B
monitor_interval=2000
#当复制slave全部断掉时,maxscale仍然可用,将所有的访问指向master节点
detect_stale_master=true
#Servicedefinitions
#
#ServiceDefinitionforaread-onlyserviceand
#aread/writesplittingservice.
#
#ReadConnRoutedocumentation:
#/kb/en/mariadb-maxscale-23-readconnroute/
[Read-Only-Service]
type=service
router=readconnroute
servers=server1,server2,server3
user=orchestrator
password=0FFC28BC3A8F402F10B0B798E347FD9B
router_options=slave
#ReadWriteSplitdocumentation:
#/kb/en/mariadb-maxscale-23-readwritesplit/
[Read-Write-Service]
type=service
router=readwritesplit
servers=server1,server2,server3
user=orchestrator
password=0FFC28BC3A8F402F10B0B798E347FD9B
#ThisserviceenablestheuseoftheMaxAdmininterface
#MaxScaleadministrationguide:
#/kb/en/mariadb-maxscale-23-maxadmin-admin-interface/
[MaxAdmin-Service]
type=service
router=cli
#Listenerdefinitionsfortheservices
#
#Theselistenersrepresenttheportsthe
#serviceswilllistenon.
#
[Read-Only-Listener]
type=listener
service=Read-Only-Service
protocol=MariaDBClient
port=4008
[Read-Write-Listener]
type=listener
service=Read-Write-Service
protocol=MariaDBClient
port=4006
[MaxAdmin-Listener]
type=listener
service=MaxAdmin-Service
protocol=maxscaled
socket=default
[root@mgr1maxscale]#
4、测试过程,把原来的主关闭,并以从库的方式重启,下面是maxscale自动发现的过程状态展示[root@mgr1maxscale]#maxadmin
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|SlaveofExternalServer,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|Master,Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|Master,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|Down
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|Master,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|Down
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|Master,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|Down
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|Master,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|SlaveofExternalServer,Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|Master,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|SlaveofExternalServer,Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|Master,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|SlaveofExternalServer,Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server|Address|Port|Connections|Status
-------------------+-----------------+-------+-------------+--------------------
server1|192.168.56.14|3306|0|Master,Running
server2|192.168.56.15|3306|0|SlaveofExternalServer,Running
server3|192.168.56.16|3306|0|SlaveofExternalServer,Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>listservers