GBase8c 单机扩容至主备

单机IP：192.168.123.121
待扩容IP：192.168.123.122

一、扩容前提条件。

• 数据库主机上存在镜像包，解压镜像包后，在script目录下执行./gs_expansion命令进行扩容。
• 在新增的扩容备机上创建好与主机上相同的用户和用户组。
• 已存在的数据库节点和新增的扩容节点之间需要建立好root用户互信以及数据库管理用户的互信。
• 正确配置xml文件，在已安装数据库配置文件的基础上，添加需要扩容的备机信息。
• 只能使用root用户执行gs_expansion命令。
• 扩容备机的操作系统与主机保持一致。
• 不允许同时执行2次相同的gs_expansion命令。
• 扩容备节点的操作只能在主节点上执行。

二、单机扩容至主备

1、提前在备机创建与主机上相同的用户和用户组

[gbase@gbase8c-primary script]$ id
uid=1000(gbase) gid=1000(gbase) 组=1000(gbase) 环境=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@gbase8c-standby ~]# useradd gbase
[root@gbase8c-standby ~]# passwd gbase

2、将主备环境用户执行脚本互信

写入hostfile文件，并执行互信脚本，root和安装用户均需要执行

[root@gbase8c-primary script]# cat hostfile
192.168.123.121
192.168.123.122
[root@gbase8c-primary script]# ./gs_sshexkey -f hostfile
Please enter password for current user[root].
[gbase@gbase8c-primary script]$ ./gs_sshexkey -f hostfile
Please enter password for current user[gbase].

3、修改主机原单机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"/>
      <!-- dn -->
      <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>

4、使用root用户执行扩容脚本

[root@gbase8c-primary script]# ./gs_expansion -U gbase -G gbase -X ../gbase_ps.xml -h 192.168.123.122 -L

加了 -L 执行失败可以删掉再重试
过程：

[root@gbase8c-primary script]# ./gs_expansion -U gbase -G gbase -X ../gbase_ps.xml -h 192.168.123.122 -L
Start expansion without cluster manager component.
Database on standby nodes installed finished.

Checking gaussdb and gs_om version.
[GAUSS-35707] Fail to check gaussdb version on:
gbase8c-standby
[GAUSS-35707] Fail to check gs_om version on:
gbase8c-standby
End to check gaussdb and gs_om version.

Start to establish the relationship.
Start to build standby 192.168.123.122.
Failed to start 192.168.123.122 as standby before building.
[GAUSS-35706] Fail to build on all new hosts.
[root@gbase8c-primary script]# ./gs_expansion -U gbase -G gbase -X ../gbase_ps.xml -h 192.168.123.122
Start expansion without cluster manager component.
Start to preinstall database on new nodes.
Start to send soft to each standby nodes.
End to send soft to each standby nodes.
Success to send XML to new nodes
Start to preinstall database step.

Preinstall 192.168.123.122 success
End to preinstall database step.
End to preinstall database on new nodes.

Start to install database on new nodes.
192.168.123.122 install success.
Finish to install database on all nodes.
Database on standby nodes installed finished.

Checking gaussdb and gs_om version.
End to check gaussdb and gs_om version.

Start to establish the relationship.
Start to build standby 192.168.123.122.
Build standby 192.168.123.122 success.
Start to generate and send cluster static file.
End to generate and send cluster static file.

Expansion results:
192.168.123.122:        Success
Expansion Finish.

5、检查状态

[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