hgdb HAC集群中，计划重新初始化数据库使用原集群配置的操作方法（一）

lk_db

已于 2022-04-02 14:28:48 修改

阅读量2.5k

点赞数

分类专栏： Highgo DB 文章标签：数据库

于 2022-03-18 12:49:19 首次发布

本文链接：https://blog.csdn.net/lk_db/article/details/123571928

版权

本文档介绍了在hgdb HAC集群中，如何在保持原配置不变的情况下，重新初始化数据库的详细操作流程。首先，停止所有节点的hghac服务并删除data目录，然后在主节点上使用initdb。接着，启动节点发现集群状态异常，通过检查日志发现系统ID不匹配。解决方法是删除或备份etcd目录，重启etcd服务，最后重新启动HAC服务，集群恢复正常。

摘要由CSDN通过智能技术生成

1、所有节点停止hghac服务，删除原data目录，重新在主节点initdb（原配置的HAC集群文件不变）
[root@db data]# systemctl stop hghac-vip
[root@db data]# initdb -e sm4 -c "echo *******" -D /db/hgdbdata/data

2、启动节点1的HAC服务，此时集群信息显示异常
[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 ago
Process: 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/FAILURE
Mar 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 Fr