原作者：邓秋爽
- 适用范围
- 问题概述
- 背景介绍
- 原gs_om集群信息
- 原环境ptk
- 背景介绍
- 解决方案
- PTK IP地址变更
- 1、修改ptk相关IP地址,该文件可以使用find去查找，一般存储在安装用户的.ptk/data/cluster_name/topology.yml目录下
- 2、修改之后ptk展示为变更后的IP地址
- Mogdb IP地址变更
- 1、mogdb ip地址变更需要修改postgresql.conf、pg_hba.conf、/etc/hosts
- 2、mogdb ip地址变更还需要修改集群配置文件config.xml(由于是ptk安装的需要生成通过ptk gen-om-xml生成cluster配置文件）
- PTK IP地址变更
适用范围
mogdb 3.0 ptk
问题概述
mogdb 3.0 ptk安装环境IP地址变更
背景介绍
目前需要把Mogdb集群IP地址192.168.56.60变更为192.168.57.60、P地址192.168.56.61变更为192.168.57.61
原gs_om集群信息
[omm@ora121c-node01 ~]$ gs_om -t status --detail
[ Cluster State ]
cluster_state : Normal
redistributing : No
current_az : AZ_ALL
[ Datanode State ]
node node_ip port instance state
------------------------------------------------------------------------------------------
1 ora121c-node01 192.168.56.60 26000 6001 /data/mogdb/data P Primary Normal
2 ora121c-node02 192.168.56.61 26000 6002 /data/mogdb/data S Standby Normal
原环境ptk
[root@ora121c-node01 tool]# /opt/software/ptk/ptk ls
cluster_name | id | addr | user | data_dir | db_version | create_time | comment
-----------------+------+---------------------+------+------------------+------------------------------+---------------------+----------
mogdb_cluster1 | 6001 | 192.168.56.60:26000 | omm | /data/mogdb/data | MogDB 3.0.3 (build 23ba838d) | 2022-12-26 21:29:44 |
| 6002 | 192.168.56.61:26000 | omm | /data/mogdb/data | | |
解决方案
分别修改ptk IP地址和mogdb IP地址
PTK IP地址变更
ptk topology.yml配置文件中的为ptk集群的配置项，将ip改为当前主机的IP，然后ptk就可以顺利的管理数据库实例
1、修改ptk相关IP地址,该文件可以使用find去查找，一般存储在安装用户的.ptk/data/cluster_name/topology.yml目录下
[root@ora121c-node01 software]# more /root/.ptk/data/mogdb_cluster1/topology.yml
global:
cluster_name: mogdb_cluster1
user: omm
group: omm
db_password: pTk6ODdiY2QxN2U9Pj89PD5APnZiS0traWRmcFAwUjFsTERPdDlPcTNySkp6YklQcnNza21fbXljMTJJcTg=
db_port: 26000
base_dir: /data/mogdb
app_dir: /data/mogdb/app
data_dir: /data/mogdb/data
log_dir: /data/mogdb/log
tool_dir: /data/mogdb/tool
tmp_dir: /data/mogdb/tmp
cm_option:
dir: /data/mogdb/cm
cm_server_port: 15300
cm_server_level: 1
db_service_vip: ""
db_servers:
- inst_id: 6001
node_id: 1
host: 192.168.56.60
user: omm
group: omm
db_port: 26000
base_dir: /data/mogdb
app_dir: /data/mogdb/app
data_dir: /data/mogdb/data
log_dir: /data/mogdb/log
tool_dir: /data/mogdb/tool
tmp_dir: /data/mogdb/tmp
ha_ips:
- 192.168.56.60
ha_port: 26001
role: primary
az_name: AZ1
az_priority: 1
ssh_option:
host: 192.168.56.60
port: 22
user: root
password: pTk6NWIwZTlmMjY9Pj48PUBBRHlSM2JmTE9lZ3BvRmNwRlp1Qm92eFBTVzlzVmhVM3hCTU1SZlBvQU9zUDg=
- inst_id: 6002
node_id: 2
host: 192.168.56.61
user: omm
group: omm
db_port: 26000
base_dir: /data/mogdb
app_dir: /data/mogdb/app
data_dir: /data/mogdb/data
log_dir: /data/mogdb/log
tool_dir: /data/mogdb/tool
tmp_dir: /data/mogdb/tmp
ha_ips:
- 192.168.56.61
ha_port: 26001
role: standby
az_name: AZ1
az_priority: 1
ssh_option:
host: 192.168.56.61
port: 22
user: root
password: pTk6NWZjOGU2OWE9Pj89PD0/PGxfN3BVMFZwYUxvT3BGVGM3RGhLdXh1bHlya0xkZGRiTmNINzl0Wmt1dGM=
cm_servers: []
create_time: 2022-12-26T21:29:44.786259787+08:00
update_time: 2022-12-31T02:42:02.407001976+08:00
[root@ora121c-node01 tool]# sed -i 's/192.168.56.60/192.168.57.60/g' /root/.ptk/data/mogdb_cluster1/topology.yml
[root@ora121c-node01 tool]# sed -i 's/192.168.56.61/192.168.57.61/g' /root/.ptk/data/mogdb_cluster1/topology.yml
2、修改之后ptk展示为变更后的IP地址
[root@ora121c-node01 tool]# /opt/software/ptk/ptk ls
cluster_name | id | addr | user | data_dir | db_version | create_time | comment
-----------------+------+---------------------+------+------------------+------------------------------+---------------------+----------
mogdb_cluster1 | 6001 | 192.168.57.60:26000 | omm | /data/mogdb/data | MogDB 3.0.3 (build 23ba838d) | 2022-12-26 21:29:44 |
| 6002 | 192.168.57.61:26000 | omm | /data/mogdb/data | | |
Mogdb IP地址变更
1、mogdb ip地址变更需要修改postgresql.conf、pg_hba.conf、/etc/hosts
[root@ora121c-node01 tool]# sed -i 's/192.168.56.60/192.168.57.60/g' /data/mogdb/data/postgresql.conf /data/mogdb/data/pg_hba.conf /etc/hosts
[root@ora121c-node01 tool]# sed -i 's/192.168.56.61/192.168.57.61/g' /data/mogdb/data/postgresql.conf /data/mogdb/data/pg_hba.conf /etc/hosts
[root@ora121c-node02 tool]# sed -i 's/192.168.56.60/192.168.57.60/g' /data/mogdb/data/postgresql.conf /data/mogdb/data/pg_hba.conf /etc/hosts
[root@ora121c-node02 tool]# sed -i 's/192.168.56.61/192.168.57.61/g' /data/mogdb/data/postgresql.conf /data/mogdb/data/pg_hba.conf /etc/hosts
2、mogdb ip地址变更还需要修改集群配置文件config.xml(由于是ptk安装的需要生成通过ptk gen-om-xml生成cluster配置文件）
[root@ora121c-node01 ]# cd /data/mogdb/tool
[root@ora121c-node01 tool]# /opt/software/ptk/ptk gen-om-xml -f /root/.ptk/data/mogdb_cluster1/topology.yml
/data/mogdb/tool/config_20221231052712.xml
[root@ora121c-node01 tool]# ll
total 138040
-rw-r--r-- 1 root root 1686 Dec 31 05:27 config_20221231052712.xml
drwxr-xr-x. 15 omm omm 4096 Dec 31 02:42 lib
-rw-r--r--. 1 omm omm 65 Oct 22 15:02 MogDB-3.0.3-CentOS-64bit-cm.sha256
-rw-r--r--. 1 omm omm 6414150 Oct 22 15:02 MogDB-3.0.3-CentOS-64bit-cm.tar.gz
-rw-r--r--. 1 omm omm 5079239 Oct 22 15:02 MogDB-3.0.3-CentOS-64bit-Libpq.tar.gz
-rw-r--r--. 1 omm omm 65 Oct 22 15:02 MogDB-3.0.3-CentOS-64bit-om.sha256
-rw-r--r--. 1 omm omm 14149758 Oct 22 15:02 MogDB-3.0.3-CentOS-64bit-om.tar.gz
-rw-r--r--. 1 omm omm 65 Oct 22 15:01 MogDB-3.0.3-CentOS-64bit.sha256
-rw-r--r--. 1 omm omm 107214850 Oct 22 15:01 MogDB-3.0.3-CentOS-64bit.tar.gz
-rw-r--r--. 1 omm omm 8034863 Oct 22 15:02 MogDB-3.0.3-CentOS-64bit-tools.tar.gz
drwxr-xr-x. 3 omm omm 16 Dec 26 21:29 ptk_tool
drwxr-xr-x. 10 omm omm 4096 Oct 22 09:50 script
drwxr-xr-x. 2 omm omm 4096 Oct 22 09:50 simpleInstall
-rw-r--r--. 1 omm omm 65 Oct 22 15:02 upgrade_sql.sha256
-rw-r--r--. 1 omm omm 410305 Oct 22 15:02 upgrade_sql.tar.gz
-rw-r--r--. 1 omm omm 28 Oct 22 09:50 version.cfg
[root@ora121c-node01 tool]# more /data/mogdb/tool/config_20221231052712.xml
<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
<CLUSTER>
<PARAM name="clusterName" value="mogdb_cluster1"></PARAM>
<PARAM name="nodeNames" value="ora121c-node01,ora121c-node02"></PARAM>
<PARAM name="gaussdbLogPath" value="/data/mogdb/log"></PARAM>
<PARAM name="gaussdbAppPath" value="/data/mogdb/app"></PARAM>
<PARAM name="gaussdbToolPath" value="/data/mogdb/tool"></PARAM>
<PARAM name="backIP1s" value="192.168.57.60,192.168.57.61"></PARAM>
<PARAM name="clusterType" value="single-primary-multi-standby"></PARAM>
</CLUSTER>
<DEVICELIST>
<DEVICE sn="ora121c-node01">
<PARAM name="name" value="ora121c-node01"></PARAM>
<PARAM name="azName" value="AZ1"></PARAM>
<PARAM name="azPriority" value="1"></PARAM>
<PARAM name="backIp1" value="192.168.57.60"></PARAM>
<PARAM name="sshIp1" value="192.168.57.60"></PARAM>
<PARAM name="dataNum" value="1"></PARAM>
<PARAM name="dataPortBase" value="26000"></PARAM>
<PARAM name="dataNode1" value="/data/mogdb/data,ora121c-node02,/data/mogdb/data"></PARAM>
<PARAM name="dataNode1_syncNum" value="1"></PARAM>
</DEVICE>
<DEVICE sn="ora121c-node02">
<PARAM name="name" value="ora121c-node02"></PARAM>
<PARAM name="azName" value="AZ1"></PARAM>
<PARAM name="azPriority" value="1"></PARAM>
<PARAM name="backIp1" value="192.168.57.61"></PARAM>
<PARAM name="sshIp1" value="192.168.57.61"></PARAM>
</DEVICE>
</DEVICELIST>
</ROOT>
gs_om -t generateconf -X /data/mogdb/tool/config_20221231052712.xml --distribute发送配置文件到集群的所有节点：
[omm@ora121c-node01 ~]$ gs_om -t generateconf -X /data/mogdb/tool/config_20221231052712.xml --distribute
Generating static configuration files for all nodes.
Creating temp directory to store static configuration files.
Successfully created the temp directory.
Generating static configuration files.
Successfully generated static configuration files.
Static configuration files for all nodes are saved in /data/mogdb/tool/script/static_config_files.
Distributing static configuration files to all nodes.
Successfully distributed static configuration files.
[omm@ora121c-node01 ~]$ gs_om -t status --detail
[ Cluster State ]
cluster_state : Normal
redistributing : No
current_az : AZ_ALL
[ Datanode State ]
node node_ip port instance state
------------------------------------------------------------------------------------------
1 ora121c-node01 192.168.57.60 26000 6001 /data/mogdb/data P Primary Normal
2 ora121c-node02 192.168.57.61 26000 6002 /data/mogdb/data S Standby Normal
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
