GBase8c 主备环境后装CM管理工具

最新推荐文章于 2024-09-15 08:03:51 发布

Titus、

最新推荐文章于 2024-09-15 08:03:51 发布

阅读量423

点赞数 4

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

本文链接：https://blog.csdn.net/Pepsiboy1/article/details/141718591

版权

GBase8c 专栏收录该内容

16 篇文章 1 订阅

订阅专栏

一、后装CM管理工具

⚠注意事项：
(1)、安装CM过程中会出现短暂停机情况，若生产环境需要装CM管理工具需要与应用业务沟通是否可以中断连接。
(2)、安装CM 需提前确认主备状态是否正常。

1、检查集群状态

[gbase@gbase8c-primary ~]$ 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  gbase8c-primary 192.168.123.121 15400      6001 /dbdata/gbase/database/data/dn   P Primary Normal
2  gbase8c-standby 192.168.123.122 15400      6002 /dbdata/gbase/database/data/dn   S Standby Normal

2、修改xml文件

无CM XML文件如下：

<?xml version="1.0" encoding="utf-8"?>
<ROOT>
  <CLUSTER>
    <PARAM name="clusterName" value="gbase" />
    <PARAM name="nodeNames" value="gbase8c-primary,gbase8c-standby"/>
    <PARAM name="gaussdbAppPath" value="/dbdata/gbase/database/app" />
    <PARAM name="gaussdbLogPath" value="/dbdata/gbase/database/log" />
    <PARAM name="tmpMppdbPath" value="/dbdata/gbase/database/tmp"/>
    <PARAM name="gaussdbToolPath" value="/dbdata/gbase/database/tool" />
    <PARAM name="corePath" value="/dbdata/gbase/database/corefile"/>
    <PARAM name="backIp1s" value="192.168.123.121,192.168.123.122"/>
    <PARAM name="sshPort" value="22" />
  </CLUSTER>

  <DEVICELIST>
    <DEVICE sn="gbase8c-primary">
      <PARAM name="name" value="gbase8c-primary"/>
      <PARAM name="azName" value="AZ1"/>
      <PARAM name="azPriority" value="1"/>
      <PARAM name="backIp1" value="192.168.123.121"/>
      <PARAM name="sshIp1" value="192.168.123.121"/>
      <PARAM name="dataNum" value="1"/>
      <PARAM name="dataPortBase" value="15400"/>
      <PARAM name="dataNode1" value="/dbdata/gbase/database/data/dn,gbase8c-standby,/dbdata/gbase/database/data/dn"/>
      <PARAM name="dataNode1_syncNum" value="0"/>
	  
    </DEVICE>

    <DEVICE sn="gbase8c-standby">
      <PARAM name="name" value="gbase8c-standby"/>
      <PARAM name="azName" value="AZ1"/>
      <PARAM name="azPriority" value="1"/>
      <PARAM name="backIp1" value="192.168.123.122"/>
      <PARAM name="sshIp1" value="192.168.123.122"/>
    </DEVICE>
  </DEVICELIST>
</ROOT>

修改后XML文件如下：

<?xml version="1.0" encoding="utf-8"?>
<ROOT>
  <CLUSTER>
    <PARAM name="clusterName" value="gbase" />
    <PARAM name="nodeNames" value="gbase8c-primary,gbase8c-standby"/>
    <PARAM name="gaussdbAppPath" value="/dbdata/gbase/database/app" />
    <PARAM name="gaussdbLogPath" value="/dbdata/gbase/database/log" />
    <PARAM name="tmpMppdbPath" value="/dbdata/gbase/database/tmp"/>
    <PARAM name="gaussdbToolPath" value="/dbdata/gbase/database/tool" />
    <PARAM name="corePath" value="/dbdata/gbase/database/corefile"/>
    <PARAM name="backIp1s" value="192.168.123.121,192.168.123.122"/>
    <PARAM name="sshPort" value="22" />
  </CLUSTER>

  <DEVICELIST>
    <DEVICE sn="gbase8c-primary">
      <PARAM name="name" value="gbase8c-primary"/>
      <PARAM name="azName" value="AZ1"/>
      <PARAM name="azPriority" value="1"/>
      <PARAM name="backIp1" value="192.168.123.121"/>
      <PARAM name="sshIp1" value="192.168.123.121"/>
      <PARAM name="dataNum" value="1"/>
      <PARAM name="dataPortBase" value="15400"/>
      <PARAM name="dataNode1" value="/dbdata/gbase/database/data/dn,gbase8c-standby,/dbdata/gbase/database/data/dn"/>
      <PARAM name="dataNode1_syncNum" value="0"/>

      <!-- CM 添加项，CM配置-->
      <PARAM name="cmsNum" value="1"/>
      <PARAM name="cmDir" value="/dbdata/gbase/database/cm"/>
      <PARAM name="cmServerPortBase" value="15300"/>
      <PARAM name="cmServerListenIp1" value="192.168.123.121,192.168.123.122"/>
      <PARAM name="cmServerHaIp1" value="192.168.123.121,192.168.123.122"/>
      <PARAM name="cmServerlevel" value="1"/>
      <PARAM name="cmServerRelation" value="gbase8c-primary,gbase8c-standby"/>
    </DEVICE>

    <DEVICE sn="gbase8c-standby">
      <PARAM name="name" value="gbase8c-standby"/>
      <PARAM name="azName" value="AZ1"/>
      <PARAM name="azPriority" value="1"/>
      <PARAM name="backIp1" value="192.168.123.122"/>
      <PARAM name="sshIp1" value="192.168.123.122"/>

      <!-- CM 添加项，备机CM安装路径-->
      <PARAM name="cmDir" value="/dbdata/gbase/database/cm"/>
    </DEVICE>
  </DEVICELIST>
</ROOT>

3、主机执行安装

检查 $GPHOME 是否存在 *.cm.tar.gz 安装包

[root@gbase8c-primary script]# su - gbase
[gbase@gbase8c-primary ~]$ cd $GPHOME
[gbase@gbase8c-primary tool]$ ls
gbase                                        GBase8cV5_S5.0.0B29_CentOS_x86_64.sha256   lib        script                    upgrade_sql.sha256  version.cfg
GBase8cV5_Package_bak_9f0c40cd.tar.gz        GBase8cV5_S5.0.0B29_CentOS_x86_64.tar.bz2  libssl     set_elf_runpath.sh        upgrade_sql.tar.gz
GBase8cV5_S5.0.0B29_CentOS_x86_64_cm.tar.gz  gbase_cm.xml                               python3.8  support_system_info.json  venv

执行cm_install 安装CM，

[gbase@gbase8c-primary tool]$ cd $GAUSSHOME/tool/cm_tool/
[gbase@gbase8c-primary cm_tool]$ ./cm_install -X /dbdata/gbase/database/tool/gbase_cm.xml --cmpkg=$GPHOME/GBase8cV5_S5.0.0B29_CentOS_x86_64_cm.tar.gz

安装过程

[gbase@gbase8c-primary cm_tool]$ ./cm_install -X /dbdata/gbase/database/tool/gbase_cm.xml --cmpkg=$GPHOME/GBase8cV5_S5.0.0B29_CentOS_x86_64_cm.tar.gz
Term of primary is invalid or not maximal.
Hint: it seems that the cluster is newly installed, so it's recommended to deploy CM tool while installing the cluster.
Start to install cm tool.
Preparing CM path.
Decompressing CM pacakage.
Creating cluster_manual_start file.
Initializing cm_server.
Initializing cm_agent.
Creating CM ca files.
Please input the password for ca cert:
Please input the password for ca cert again:
Refreshing static and dynamic file using xml file with cm.
Setting om_monitor crontab.
Starting cluster.
[  CMServer State   ]

node               instance state
-----------------------------------
1  gbase8c-primary 1        Primary
2  gbase8c-standby 2        Standby

[   Cluster State   ]

cluster_state   : Normal
redistributing  : No
balanced        : Yes
current_az      : AZ_ALL

[  Datanode State   ]

node               instance state            | node               instance state
----------------------------------------------------------------------------------------------
1  gbase8c-primary 6001     P Primary Normal | 2  gbase8c-standby 6002     S Standby Normal
Install CM tool success.

4、检查集群状态

[gbase@gbase8c-primary cm_tool]$ gs_om -t status --detail
[  CMServer State   ]

node               node_ip         instance                                 state
-----------------------------------------------------------------------------------
1  gbase8c-primary 192.168.123.121 1    /dbdata/gbase/database/cm/cm_server Primary
2  gbase8c-standby 192.168.123.122 2    /dbdata/gbase/database/cm/cm_server Standby

[   Cluster State   ]

cluster_state   : Normal
redistributing  : No
balanced        : Yes
current_az      : AZ_ALL

[  Datanode State   ]

node               node_ip         instance                            state
----------------------------------------------------------------------------------------
1  gbase8c-primary 192.168.123.121 6001 /dbdata/gbase/database/data/dn P Primary Normal
2  gbase8c-standby 192.168.123.122 6002 /dbdata/gbase/database/data/dn S Standby Normal