database dba 南大通用数据库-Gbase-8a-学习-04-部署分布式集群（8.6版本）

一、环境

名称值cpuIntel® Core™ i5-1035G1 CPU @ 1.00GHz操作系统CentOS Linux release 7.9.2009 (Core)内存3G逻辑核数2节点1-IP192.168.142.10节点2-IP192.168.142.11

二、集群部署

1、解压安装包

[root@localhost pkg]# tar -xvf GBase8a_MPP_Cluster-NoLicense-8.6.2_build43-R33-132743-redhat7-x86_64.tar.bz2

gcinstall/

gcinstall/bundle_data.tar.bz2

gcinstall/InstallTar.py

gcinstall/license.txt

gcinstall/CorosyncConf.py

gcinstall/gbase_data_timezone.sql

gcinstall/CGConfigChecker.py

gcinstall/gcinstall.py

gcinstall/cluster.conf

gcinstall/Restore.py

gcinstall/unInstall.py

gcinstall/fulltext.py

gcinstall/InstallFuns.py

gcinstall/extendCfg.xml

gcinstall/bundle.tar.bz2

gcinstall/BUILDINFO

gcinstall/GetOSType.py

gcinstall/RestoreLocal.py

gcinstall/FileCheck.py

gcinstall/rmt.py

gcinstall/dependRpms

gcinstall/demo.options

gcinstall/rootPwd.json

gcinstall/example.xml

gcinstall/pexpect.py

gcinstall/replace.py

gcinstall/SSHThread.py

gcinstall/loginUserPwd.json

2、配置demo.options

[root@localhost pkg]# cd gcinstall/

[root@localhost gcinstall]# ll

总用量 93016

-rw-r--r--. 1 gbase gbase 292 12月 17 2021 BUILDINFO

-rw-r--r--. 1 root root 2249884 12月 17 2021 bundle_data.tar.bz2

-rw-r--r--. 1 root root 87478657 12月 17 2021 bundle.tar.bz2

-rw-r--r--. 1 gbase gbase 1951 12月 17 2021 CGConfigChecker.py

-rw-r--r--. 1 gbase gbase 309 12月 17 2021 cluster.conf

-rwxr-xr-x. 1 gbase gbase 4167 12月 17 2021 CorosyncConf.py

-rw-r--r--. 1 gbase gbase 434 12月 17 2021 demo.options

-rw-r--r--. 1 root root 154 12月 17 2021 dependRpms

-rw-r--r--. 1 gbase gbase 684 12月 17 2021 example.xml

-rwxr-xr-x. 1 gbase gbase 419 12月 17 2021 extendCfg.xml

-rw-r--r--. 1 gbase gbase 781 12月 17 2021 FileCheck.py

-rw-r--r--. 1 gbase gbase 2700 12月 17 2021 fulltext.py

-rw-r--r--. 1 gbase gbase 4818440 12月 17 2021 gbase_data_timezone.sql

-rwxr-xr-x. 1 gbase gbase 76282 12月 17 2021 gcinstall.py

-rwxr-xr-x. 1 gbase gbase 3362 12月 17 2021 GetOSType.py

-rw-r--r--. 1 gbase gbase 156505 12月 17 2021 InstallFuns.py

-rw-r--r--. 1 gbase gbase 237364 12月 17 2021 InstallTar.py

-rw-r--r--. 1 gbase gbase 1114 12月 17 2021 license.txt

-rwxr-xr-x. 1 gbase gbase 296 12月 17 2021 loginUserPwd.json

-rwxr-xr-x. 1 gbase gbase 75990 12月 17 2021 pexpect.py

-rwxr-xr-x. 1 gbase gbase 25093 12月 17 2021 replace.py

-rw-r--r--. 1 gbase gbase 1715 12月 17 2021 RestoreLocal.py

-rwxr-xr-x. 1 gbase gbase 6622 12月 17 2021 Restore.py

-rw-r--r--. 1 gbase gbase 7312 12月 17 2021 rmt.py

-rwxr-xr-x. 1 gbase gbase 296 12月 17 2021 rootPwd.json

-rw-r--r--. 1 gbase gbase 2717 12月 17 2021 SSHThread.py

-rwxr-xr-x. 1 gbase gbase 21710 12月 17 2021 unInstall.py

[root@localhost gcinstall]# vim demo.options

[root@localhost gcinstall]# cat demo.options

installPrefix= /opt

coordinateHost = 192.168.142.10,192.168.142.11

#coordinateHostNodeID = 234,235,237

dataHost = 192.168.142.10,192.168.142.11

#existCoordinateHost =

#existDataHost =

loginUser= root

loginUserPwd = 'qwer1234'

#loginUserPwdFile = loginUserPwd.json

dbaUser = gbase

dbaGroup = gbase

dbaPwd = 'gbase'

rootPwd = 'qwer1234'

#rootPwdFile = rootPwd.json

dbRootPwd = ''

#mcastAddr = 226.94.1.39

mcastPort = 5493

参数名描述installPrefix指定安装目录。coordinateHost所有 coordinator 节点 IP 列表，IP 地址之间用“,”分隔。coordinateHostNodeID支持对 IPV6 地址的输入，当集群节点为 IPV4 地址，则该参数无效，可不用设置；当集群节点为 IPV6 地址，则用户必须手动设置该参数，该参数为若干个正整数，需要与 coordinateHost 中的 IP 一一对应，用逗号隔开。例如：coordinateHostNodeID = 1,2,3。existCoordinateHost所有已存在的 coordinator 节点 IP 列表，IP 地址之间用“,”分隔。existDataHost所有已存在的 data 节点 IP 列表，IP 地址之间用“,”分隔。loginUser通过该用户 ssh 到集群各节点，再 su 切换到 root 用户执行命令，该参数必须使用。默认用户为 root。该用户所属用户组必须也是 loginUser。loginUserPwd表示用户 loginUser 在集群节点密码相同的方式；loginUserPwdFile表示支持用户 loginUser 在集群节点不同密码的方式。二者不能兼用，否则报错，可以根据密码的异同选择参数使用，必须使用其一。默认密码均为 111111。dbaUser操作系统中的数据库管理员用户，默认gbase。dbaGroup操作系统中的数据库管理员用户的用户组，默认gbase。dbaPwd操作系统中的数据库管理员用户的密码。rootPwd操作系统中的root用户密码。rootPwdFile该参数支持 root 用户在多节点不同密码方式，与参数rootPwd 不能同时使用，否则报错。默认密码 111111。dbRootPwd数据库 root 用户密码。安装集群时无需设置，仅在集群升级、扩容、节点替换时使用生效。mcastAddr组播地址，缺省值为 226.94.1.39，组播方式会引起网络风暴，因此不建议使用此方式，如果将 mcastAddr 参数删除，则会按照 UDPU 方式进行安装，我们建议用户按此方式安装。mcastPort组播端口，缺省值为 5493，如果按照 UDPU 方式安装，则此参数无效。

3、安装软件

[root@localhost gcinstall]# ./gcinstall.py --silent=demo.options

显示如下表示成功

192.168.142.11 Installing gcluster.

192.168.142.10 Install gcluster on host 192.168.142.10 successfully.

192.168.142.11 Install gcluster on host 192.168.142.11 successfully.

192.168.142.10 Install gcluster on host 192.168.142.10 successfully.

Starting all gcluster nodes...

Adding new datanodes to gcware...

InstallCluster Successfully

4、查看集群状态

[root@localhost gcinstall]# gcadmin

CLUSTER STATE: ACTIVE

CLUSTER MODE: NORMAL

=====================================================================

| GBASE COORDINATOR CLUSTER INFORMATION |

=====================================================================

---------------------------------------------------------------------

---------------------------------------------------------------------

---------------------------------------------------------------------

=================================================================

| GBASE DATA CLUSTER INFORMATION |

=================================================================

-----------------------------------------------------------------

-----------------------------------------------------------------

-----------------------------------------------------------------

5、设置分布式策略

[root@localhost gcinstall]# su - gbase

上一次登录：日 8月 7 20:29:00 CST 2022pts/3 上

[gbase@localhost ~]$ cd /opt/pkg/gcinstall/

[gbase@localhost gcinstall]$ vim gcChangeInfo.xml

[gbase@localhost gcinstall]$ cat gcChangeInfo.xml

[gbase@localhost gcinstall]$ gcadmin distribution gcChangeInfo.xml p 1 d 0

gcadmin generate distribution ...

[warning]: parameter [d num] is 0, the new distribution will has no segment backup

please ensure this is ok, input y or n: y

NOTE: node [192.168.142.10] is coordinator node, it shall be data node too

NOTE: node [192.168.142.11] is coordinator node, it shall be data node too

gcadmin generate distribution successful

参数描述p每一个节点的分片数。d副本数量。pattern number数据分布模式，pattern 1 为负载均衡模式，pattern 2 为高可用模式。默认模式1。

注意： gcChangeInfo.xml 文件中 rack 内 node 数量需要大于参数 p 的值（每个节点存放主分片的数量），否则会出现如下错误：

[gbase@localhost gcinstall]$ gcadmin distribution gcChangeInfo.xml p 2 d 0

gcadmin generate distribution ...

[warning]: parameter [d num] is 0, the new distribution will has no segment backup

please ensure this is ok, input y or n: y

rack[1] node number:[2] shall be greater than segment number each node:[2]

please modify file [gcChangeInfo.xml] and try again

gcadmin generate distribution failed

6、检查集群分布策略

[gbase@localhost gcinstall]$ gcadmin showdistribution

Distribution ID: 1 | State: new | Total segment num: 2

Primary Segment Node IP Segment ID Duplicate Segment node IP

========================================================================================================================

| 192.168.142.10 | 1 | |

------------------------------------------------------------------------------------------------------------------------

| 192.168.142.11 | 2 | |

========================================================================================================================

7、初始化节点数据分布

[gbase@localhost gcinstall]$ gccli

gbase> initnodedatamap;

Query OK, 0 rows affected, 1 warning (Elapsed: 00:00:01.87)

gbase>

这里就安装完成了，后面大家就可以正常操作数据库，命令类似于MySql。

8、错误记录

之前部署的错误记录，暂时未找到原因，后面知道原因了，和大家说一下解决办法，猜想会不会是资源不足。

我这里用的是一个虚机2G内存，1个核。

[root@localhost gcinstall]# ./gcinstall.py --silent=demo.options

*********************************************************************************

Thank you for choosing GBase product!

Please read carefully the following licencing agreement before installing GBase product:

TIANJIN GENERAL DATA TECHNOLOGY CO., LTD. LICENSE AGREEMENT

READ THE TERMS OF THIS AGREEMENT AND ANY PROVIDED SUPPLEMENTAL LICENSETERMS (COLLECTIVELY "AGREEMENT") CAREFULLY BEFORE OPENING THE SOFTWAREMEDIA PACKAGE. BY OPENING THE SOFTWARE

MEDIA PACKAGE, YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCESSING THE SOFTWARE ELECTRONICALLY, INDICATE YOUR ACCEPTANCE OF THESE TERMS. IF YOU DO NOT AGREE TO ALL THESE TERMS, PROMPTLY RETURN THE UNUSED SOFTWARE TO YOUR PLACE OF PURCHASE FOR A REFUND.

1. CHINESE GOVERNMENT RESTRICTED. If Software is being acquired by or on behalf of the Chinese Government , then the Government's rights in Software and accompanying documentatio

n will be only as set forth in this Agreement.

2. GOVERNING LAW. Any action related to this Agreement will be governed by Chinese law: "COPYRIGHT LAW OF THE PEOPLE'S REPUBLIC OF CHINA","PATENT LAW OF THE PEOPLE'S REPUBLIC OF

CHINA","TRADEMARK LAW OF THE PEOPLE'S REPUBLIC OF CHINA","COMPUTER SOFTWARE PROTECTION REGULATIONS OF THE PEOPLE'S REPUBLIC OF CHINA". No choice of law rules of any jurisdiction will apply."

*********************************************************************************

Do you accept the above licence agreement ([Y,y]/[N,n])? y

*********************************************************************************

Welcome to install GBase products

*********************************************************************************

Environmental Checking on gcluster nodes.

CoordinateHost:

192.168.217.66 192.168.217.67

DataHost:

192.168.217.66 192.168.217.67

Are you sure to install GCluster on these nodes ([Y,y]/[N,n])? [Y,y] or [N,n] : y

192.168.217.67 Start install on host 192.168.217.67

192.168.217.66 Start install on host 192.168.217.66

192.168.217.67 mkdir /opt_prepare on host 192.168.217.67.

192.168.217.66 Start install on host 192.168.217.66

192.168.217.67 Copying InstallFuns.py to host 192.168.217.67:/opt_prepare

192.168.217.66 Start install on host 192.168.217.66

192.168.217.67 Copying RestoreLocal.py to host 192.168.217.67:/opt_prepare

192.168.217.66 Start install on host 192.168.217.66

192.168.217.67 Copying pexpect.py to host 192.168.217.67:/opt_prepare

192.168.217.66 Start install on host 192.168.217.66

192.168.217.67 Copying bundle.tar.bz2 to host 192.168.217.67:/opt_prepare

192.168.217.66 Start install on host 192.168.217.66

192.168.217.67 Copying bundle_data.tar.bz2 to host 192.168.217.67:/opt_prepare

192.168.217.66 mkdir /opt_prepare on host 192.168.217.66.

192.168.217.67 Installing gcluster.

192.168.217.66 mkdir /opt_prepare on host 192.168.217.66.

192.168.217.67 Installing gcluster.

192.168.217.66 mkdir /opt_prepare on host 192.168.217.66.

192.168.217.67 Installing gcluster.

192.168.217.66 mkdir /opt_prepare on host 192.168.217.66.

192.168.217.67 Installing gcluster.

192.168.217.66 mkdir /opt_prepare on host 192.168.217.66.

192.168.217.67 Installing gcluster.

192.168.217.66 mkdir /opt_prepare on host 192.168.217.66.

192.168.217.67 Installing gcluster.

192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare

192.168.217.67 Installing gcluster.

192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare

192.168.217.67 Installing gcluster.

192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare

192.168.217.67 Installing gcluster.

192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare