Mogdb ptk环境IP地址变更

由迪 2023-12-15

原作者：邓秋爽

适用范围
问题概述
- 背景介绍
  - 原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配置文件）

适用范围

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
复制

mogdb

mogdb ptk

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

文章被以下合辑收录

Mogdb 学习记录（共582篇）

Mogdb 学习指南