1、orchestrator環(huán)境請看上一篇：https://blog.51cto.com/860143/2429558

成都創(chuàng)新互聯(lián)專注于遼中網(wǎng)站建設(shè)服務(wù)及定制，我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗。 熱誠為您提供遼中營銷型網(wǎng)站建設(shè)，遼中網(wǎng)站制作、遼中網(wǎng)頁設(shè)計、遼中網(wǎng)站官網(wǎng)定制、微信小程序定制開發(fā)服務(wù)，打造遼中網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供遼中網(wǎng)站排名全網(wǎng)營銷落地服務(wù)。

2、maxscale安裝

curl?-sS?https://downloads.mariadb.com/MariaDB/mariadb_repo_setup?|?????sudo?bash?-s?--?--mariadb-maxscale-version="2.3"
yum?search?maxscale
sudo?yum?install?maxscale
maxkeys?/var/lib/maxscale/?
maxpasswd?/var/lib/maxscale/?123456
chown?maxscale.maxscale?/var/lib/maxscale/.secrets
vim?/etc/maxscale.cnf
systemctl?start?maxscale
systemctl?status?maxscale.service
cd?/var/log/maxscale/
vim?maxscale.log?
systemctl?start?maxscale

3、maxscale配置文件

[root@mgr1?maxscale]#?cat?/etc/maxscale.cnf
#?MaxScale?documentation:
#?https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-23/

#?Global?parameters
#
#?Complete?list?of?configuration?options:
#?https://mariadb.com/kb/en/mariadb-maxscale-23-mariadb-maxscale-configuration-usage-scenarios/

[maxscale]
threads=auto

#?Server?definitions
#
#?Set?the?address?of?the?server?to?the?network
#?address?of?a?MariaDB?server.
#

[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
#?Monitor?for?the?servers
#
#?This?will?keep?MaxScale?aware?of?the?state?of?the?servers.
#?MariaDB?Monitor?documentation:
#?https://mariadb.com/kb/en/mariadb-maxscale-23-mariadb-monitor/

[MariaDB-Monitor]
type=monitor
module=mariadbmon
servers=server1,server2,server3
user=orchestrator
password=0FFC28BC3A8F402F10B0B798E347FD9B
monitor_interval=2000
#?當(dāng)復(fù)制slave全部斷掉時，maxscale仍然可用，將所有的訪問指向master節(jié)點
detect_stale_master=true

#?Service?definitions
#
#?Service?Definition?for?a?read-only?service?and
#?a?read/write?splitting?service.
#

#?ReadConnRoute?documentation:
#?https://mariadb.com/kb/en/mariadb-maxscale-23-readconnroute/

[Read-Only-Service]
type=service
router=readconnroute
servers=server1,server2,server3
user=orchestrator
password=0FFC28BC3A8F402F10B0B798E347FD9B
router_options=slave


#?ReadWriteSplit?documentation:
#?https://mariadb.com/kb/en/mariadb-maxscale-23-readwritesplit/

[Read-Write-Service]
type=service
router=readwritesplit
servers=server1,server2,server3
user=orchestrator
password=0FFC28BC3A8F402F10B0B798E347FD9B

#?This?service?enables?the?use?of?the?MaxAdmin?interface
#?MaxScale?administration?guide:
#?https://mariadb.com/kb/en/mariadb-maxscale-23-maxadmin-admin-interface/

[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

[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@mgr1?maxscale]#

4、測試過程，把原來的主關(guān)閉，并以從庫的方式重啟，下面是maxscale自動發(fā)現(xiàn)的過程狀態(tài)展示

[root@mgr1?maxscale]#?maxadmin?
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Master,?Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Master,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Down
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Master,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Down
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Master,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Down
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Master,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Slave?of?External?Server,?Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Master,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Slave?of?External?Server,?Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Master,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Slave?of?External?Server,?Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers
Servers.
-------------------+-----------------+-------+-------------+--------------------
Server?????????????|?Address?????????|?Port??|?Connections?|?Status??????????????
-------------------+-----------------+-------+-------------+--------------------
server1????????????|?192.168.56.14???|??3306?|???????????0?|?Master,?Running
server2????????????|?192.168.56.15???|??3306?|???????????0?|?Slave?of?External?Server,?Running
server3????????????|?192.168.56.16???|??3306?|???????????0?|?Slave?of?External?Server,?Running
-------------------+-----------------+-------+-------------+--------------------
MaxScale>?list?servers

本文題目：orchestrator+maxscale+mysql5.7GTID主從切換測試過程
新聞來源：http://www.rwnh.cn/article16/jgpddg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供響應(yīng)式網(wǎng)站、面包屑導(dǎo)航、企業(yè)建站、ChatGPT、做網(wǎng)站、企業(yè)網(wǎng)站制作

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)