安 装
演练环境
数据库版本:GBase 8a MPP Cluster V95
服务器:10.206.16.106(主安装节点)、10.206.16.108
SSH工具:FinalShell
客户端工具:GBase Data Studio
安装步骤
环境准备
106、108执行如下命令:
$ #root 用户登录
$ #创建gbase用户(密码:gbase)
$ useradd gbase
$ passwd gbase
$ cd /opt/
$ mkdir -p /opt/gbase
$ #授权
$ chown gbase:gbase /opt/gbase/
集群安装
解压软件包
106:
$ tar xjf GBase8a_MPP_Cluster-License-9.5.2.39-redhat7.3-x86_64.tar.bz2
$ cd gcinstall/
$ cp SetSysEnv.py /opt/
执行环境配置脚本
108:
$ #复制环境配置脚本
$ scp root@10.206.16.106:/opt/gcinstall/SetSysEnv.py /opt/
106、108:
$ #运行SetSysEnv.py配置安装环境
$ python SetSysEnv.py --dbaUser=gbase --installPrefix=/opt/gbase --cgroup
数据库安装
106:
$ #DBA用户在主安装节点执行
$ su - gbase
$ cd /opt/gcinstall/
$ vi demp.options
修改demo.options如下(两个节点对称部署):
installPrefix= /opt/gbasecoordinateHost
= 10.206.16.106,10.206.16.108coordinateHostNodeID
= 106,108dataHost
= 10.206.16.106,10.206.16.108
#existCoordinateHost =
#existDataHost =
dbaUser = gbasedbaGroup
= gbasedbaPwd
= 'gbase'rootPwd
= 'Gbase_0312!@'
#rootPwdFile = rootPwd.json
$ ./gcinstall.py --silent=demo.options
# 安装完成后显示如下日志
10.206.16.108 install cluster on host 10.206.16.108 successfully.
10.206.16.106 install cluster on host 10.206.16.106 successfully.
Starting all gcluster nodes...
start service failed on host 10.206.16.108.
start service failed on host 10.206.16.106.
adding new datanodes to gcware...
InstallCluster Successfully.
$ exit
$ su - gbase
$ gcadmin
CLUSTER STATE: ACTIVE
================================================================
| GBASE COORDINATOR CLUSTER INFORMATION |
================================================================
| NodeName | IpAddress | gcware | gcluster | DataState |
----------------------------------------------------------------
| coordinator1 | 10.206.16.106 | OPEN | CLOSE | 0 |
----------------------------------------------------------------
| coordinator2 | 10.206.16.108 | OPEN | CLOSE | 0 |
----------------------------------------------------------------
==============================================================
| GBASE CLUSTER FREE DATA NODE INFORMATION |
==============================================================
| NodeName | IpAddress | gnode | syncserver | DataState |
--------------------------------------------------------------
| FreeNode1 | 10.206.16.106 | CLOSE | OPEN | 0 |
--------------------------------------------------------------
| FreeNode2 | 10.206.16.108 | CLOSE | OPEN | 0 |
--------------------------------------------------------------
0 virtual cluster
2 coordinator node
2 free data node
导入许可证
106:
$ #查看license状态
$ ./chkLicense -n 10.206.16.106,10.206.16.108 -u gbase -p gbase
======================================================================
10.206.16.108
is_exist:no
======================================================================
10.206.16.106
is_exist:no
$ #导入license文件
$ ./License -n 10.206.16.106,10.206.16.108 -f /opt/20220315-02.lic -u gbase -p gbase
======================================================================
Successful node nums: 2
======================================================================
$ #再次查看license状态,已经配置
$ ./chkLicense -n 10.206.16.106,10.206.16.108 -u gbase -p gbase
======================================================================
10.206.16.108
is_exist:yes
version:trial
expire_time:20220615
is_valid:yes
======================================================================
10.206.16.106
is_exist:yes
version:trial
expire_time:20220615
is_valid:yes
106,108:
$ #重启集群服务
$ gcluster_services all stop
$ gcluster_services all start
$ gcadmin
CLUSTER STATE: ACTIVE
================================================================
| GBASE COORDINATOR CLUSTER INFORMATION |
================================================================
| NodeName | IpAddress | gcware | gcluster | DataState |
----------------------------------------------------------------
| coordinator1 | 10.206.16.106 | OPEN | OPEN | 0 |
----------------------------------------------------------------
| coordinator2 | 10.206.16.108 | OPEN | OPEN | 0 |
----------------------------------------------------------------
==============================================================
| GBASE CLUSTER FREE DATA NODE INFORMATION |
==============================================================
| NodeName | IpAddress | gnode | syncserver | DataState |
--------------------------------------------------------------
| FreeNode1 | 10.206.16.106 | OPEN | OPEN | 0 |
--------------------------------------------------------------
| FreeNode2 | 10.206.16.108 | OPEN | OPEN | 0 |
--------------------------------------------------------------
0 virtual cluster
2 coordinator node
2 free data node
生成分布
#一个分片,一个备份,负载均衡模式
$ gcadmin distribution gcChangeInfo.xml p 1 d 1 pattern 1
gcadmin generate distribution ...
NOTE: node [10.206.16.106] is coordinator node, it shall be data node too
NOTE: node [10.206.16.108] is coordinator node, it shall be data node too
gcadmin generate distribution successful
$ gcadmin showdistribution node
Distribution ID: 1 | State: new | Total segment num: 2
============================================================================================
| nodes | 10.206.16.106 | 10.206.16.108 |
--------------------------------------------------------------------------------------------
| primary | 1 | 2 |
| segments | | |
--------------------------------------------------------------------------------------------
|duplicate | 2 | 1 |
|segments 1| | |
============================================================================================
数据库初始化
$ gccli -u root -p
Enter password:
GBase client 9.5.2.39.126761. Copyright (c) 2004-2022, GBase. All Rights Reserved.
gbase> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| performance_schema |
| gbase |
| gctmpdb |
+--------------------+
4 rows in set (Elapsed: 00:00:00.01)
gbase> initnodedatamap;
Query OK, 0 rows affected (Elapsed: 00:00:00.31)