瀚高數(shù)據(jù)庫
目錄
環(huán)境
文檔用途
詳細(xì)信息

環(huán)境
系統(tǒng)平臺(tái)：N/A
版本：4.5
文檔用途
HAC集群環(huán)境中，因某種特殊原因需要?jiǎng)h除當(dāng)前data目錄并重建數(shù)據(jù)庫，能夠快速搭建集群；避免重新安裝。

詳細(xì)信息
1、所有節(jié)點(diǎn)停止hghac服務(wù)，刪除原data目錄，重新在主節(jié)點(diǎn)initdb（原配置的HAC集群文件不變）

[root@db data]# systemctl stop hghac-vip[root@db data]# initdb -e sm4 -c "echo *******" -D /db/hgdbdata/data

2、啟動(dòng)節(jié)點(diǎn)1的HAC服務(wù)，此時(shí)集群信息顯示異常

[root@db data]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7072987311974756506) +-----------+| Member | Host | Role | State | TL | Lag in MB |+--------+------+------+-------+----+-----------++--------+------+------+-------+----+-----------+[root@db data]# systemctl status hghac-vip

● hghac-vip.service - hghac

Loaded: loaded (/etc/systemd/system/hghac-vip.service; enabled; vendor preset: disabled)Active: failed (Result: exit-code) since Fri 2022-03-18 12:16:07 CST; 3min 7s agoProcess: 44961 ExecStart=/opt/HighGo/tools/hghac/hghac /opt/HighGo/tools/hghac/hghac.yaml (code=exited, status=1/FAILURE)Main PID: 44961 (code=exited, status=1/FAILURE)Mar 18 12:16:05 db systemd[1]: Started hghac.Mar 18 12:16:07 db systemd[1]: hghac-vip.service: main process exited, code=exited, status=1/FAILUREMar 18 12:16:07 db systemd[1]: Unit hghac-vip.service entered failed state.Mar 18 12:16:07 db systemd[1]: hghac-vip.service failed.[root@db data]# systemctl start hghac-vip[root@db data]# systemctl status hghac-vip

● hghac-vip.service - hghac

Loaded: loaded (/etc/systemd/system/hghac-vip.service; enabled; vendor preset: disabled)Active: failed (Result: exit-code) since Fri 2022-03-18 12:19:26 CST; 2min 13s agoProcess: 45581 ExecStart=/opt/HighGo/tools/hghac/hghac /opt/HighGo/tools/hghac/hghac.yaml (code=exited, status=1/FAILURE)Main PID: 45581 (code=exited, status=1/FAILURE)Mar 18 12:19:24 db systemd[1]: Started hghac.Mar 18 12:19:26 db systemd[1]: hghac-vip.service: main process exited, code=exited, status=1/FAILUREMar 18 12:19:26 db systemd[1]: Unit hghac-vip.service entered failed state.Mar 18 12:19:26 db systemd[1]: hghac-vip.service failed.

3、HAC集群日志中會(huì)報(bào)錯(cuò)集群的identifier與原來不一致（因?yàn)橹匦陆◣炝?#xff09;：

[root@db hghalog]# pwd/db/hgdbdata/hghalog[root@db hghalog]# tail -f patroni.log 2022-03-18 12:16:06,807 INFO: Selected new etcd server http://192.168.80.111:23792022-03-18 12:16:06,828 INFO: No PostgreSQL configuration items changed, nothing to reload.2022-03-18 12:16:06,890 CRITICAL: system ID mismatch, node hghaca belongs to a different cluster: 7072987311974756506 != 70762866990207605662022-03-18 12:19:25,967 INFO: Selected new etcd server http://192.168.80.113:23792022-03-18 12:19:25,992 INFO: No PostgreSQL configuration items changed, nothing to reload.2022-03-18 12:19:26,063 CRITICAL: system ID mismatch, node hghaca belongs to a different cluster: 7072987311974756506 != 7076286699020760566

4、各節(jié)點(diǎn)重啟etcd和hghac服務(wù)后，還是報(bào)錯(cuò)如上。

[root@db ~]# /opt/HighGo/tools/hghac/etcd/amd64/etcdctl endpoint status --write-out=table+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| ENDPOINT | ID | VERSION | DB SIZE | IS LEADER | IS LEARNER | RAFT TERM | RAFT INDEX | RAFT APPLIED INDEX | ERRORS |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| http://192.168.80.111:2379 | ddbfd190d03ca278 | 3.4.15 | 20 kB | false | false | 218 | 1686066 | 1686066 | || http://192.168.80.112:2379 | 1c703f0b65f7bddb | 3.4.15 | 20 kB | false | false | 218 | 1686066 | 1686066 | || http://192.168.80.113:2379 | 92255e8f5c9ebfcd | 3.4.15 | 20 kB | true | false | 218 | 1686066 | 1686066 | |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+[root@db ~]# systemctl start hghac-vip[root@db ~]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7072987311974756506) +-----------+| Member | Host | Role | State | TL | Lag in MB |+--------+------+------+-------+----+-----------++--------+------+------+-------+----+-----------+

5、原因分析：因?yàn)閑tcd的庫文件中記錄了此信息，需重新生成etcd的相關(guān)信息

[root@db etcd]# pwd/opt/HighGo/tools/etcd[root@db etcd]# lshgdw1.etcd[root@db etcd]# pwd/opt/HighGo/tools/etcd[root@db etcd]# lshgdw1.etcd[root@db etcd]# mv hgdw1.etcd hgdw1.etcd.bak <--所有節(jié)點(diǎn)都改名此目錄或刪除此目錄[root@db etcd]# systemctl stop etcd[root@db etcd]# systemctl start etcd[root@db etcd]# pwd/opt/HighGo/tools/etcd[root@db etcd]# lltotal 0drwx------ 3 root root 20 Mar 18 12:34 hgdw1.etcddrwx------. 3 root root 20 Mar 18 12:27 hgdw1.etcd.bak <--重啟etcd會(huì)重新生成該目錄及其下的所有文件，[root@db etcd]# /opt/HighGo/tools/hghac/etcd/amd64/etcdctl endpoint status --write-out=table+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| ENDPOINT | ID | VERSION | DB SIZE | IS LEADER | IS LEARNER | RAFT TERM | RAFT INDEX | RAFT APPLIED INDEX | ERRORS |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| http://192.168.80.111:2379 | ddbfd190d03ca278 | 3.4.15 | 20 kB | true | false | 2 | 8 | 8 | || http://192.168.80.112:2379 | 1c703f0b65f7bddb | 3.4.15 | 20 kB | false | false | 2 | 8 | 8 | || http://192.168.80.113:2379 | 92255e8f5c9ebfcd | 3.4.15 | 20 kB | false | false | 2 | 8 | 8 | |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+[root@db etcd]# [root@db etcd]# systemctl start hghac-vip <--此時(shí)啟動(dòng)HAC，集群信息顯示正常[root@db etcd]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7076286699020760566) ----+---------+----+-----------+-----------------+| Member | Host | Role | State | TL | Lag in MB | Pending restart |+--------+---------------------+--------+---------+----+-----------+-----------------+| hghaca | 192.168.80.111:5866 | Leader | running | 2 | | * |+--------+---------------------+--------+---------+----+-----------+-----------------+[root@db etcd]#

啟動(dòng)其他節(jié)點(diǎn)的HAC，結(jié)果如下：

[root@db etcd]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7076286699020760566) -----+---------+----+-----------+-----------------+| Member | Host | Role | State | TL | Lag in MB | Pending restart |+--------+---------------------+---------+---------+----+-----------+-----------------+| hghaca | 192.168.80.111:5866 | Leader | running | 2 | | * || hghacb | 192.168.80.112:5866 | Replica | running | 2 | 0 | * || hghacc | 192.168.80.113:5866 | Replica | running | 2 | 0 | * |+--------+---------------------+---------+---------+----+-----------+-----------------+

總結(jié)

以上是生活随笔為你收集整理的HAC集群中，计划重新初始化数据库使用原集群配置的操作方法的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。