Mariadb Cluster修復 / 強迫特定節點開始新叢集
【前言】
架設成為Cluster Mariadb的架構下，經常會因為不明原因而停止Cluster(例如網路 中斷，傳輸品質不佳等等)
0、先停掉三台Mariadb
1、更新/etc/my.cnf.d/server.cnf
原本的設定檔案被改為server.cnf.rpmsave，因此再次改名為server.cnf
2、galera_new_cluster
[ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the updates. To force cluster bootstrap with this node, edit the grastate.dat file manually and set safe_to_bootstrap to 1 .
vi /var/lib/mysql/grastate.dat
已正常啟動
3、啟動172.18.50.235 與 172.18.50.236 節點
啟動前直接
rm -rf /var/lib/mysql/*觀察重點： 是否有在群組內
|
1 2 3 4 5 6 7 8 9 10 11 12 |
View: id: 36a04d39-85e1-11ee-a679-dacab4680194:26797370 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 2 members(3): 0: 340f8764-9a6e-11ef-9a56-f3e7f5dd4481, webmariadb03 1: 954083d9-9a6d-11ef-8b6a-e71d25e3964e, webmariadb02 2: ba7630de-9a6c-11ef-937a-322a47ec5a65, webmariadb01 ================================================= |
如果最後狀態是這樣，表示要再重啟一次
|
1 2 3 4 5 6 7 8 9 10 |
View: id: 36a04d39-85e1-11ee-a679-dacab4680194:26797182 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: 4fb4dafa-9a6d-11ef-b1c1-f2cd4629484e, webmariadb02 ================================================= |