溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

orchestrator+maxscale+mysql5.7GTID主從切換測(cè)試過(guò)程

發(fā)布時(shí)間：2020-06-13 10:17:49 來(lái)源：網(wǎng)絡(luò) 閱讀：498 作者：xingzhehxiang 欄目：MySQL數(shù)據(jù)庫(kù)

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

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全部斷掉時(shí)，maxscale仍然可用，將所有的訪問(wèn)指向master節(jié)點(diǎn)
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、測(cè)試過(guò)程，把原來(lái)的主關(guān)閉，并以從庫(kù)的方式重啟，下面是maxscale自動(dòng)發(fā)現(xiàn)的過(guò)程狀態(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


向AI問(wèn)一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手