GBase8a 安装gccli客户端

1、添加一个用户 (可使用任意操作系统用户)

[root@keep-gbase8a-gdom ~]# useradd gbase

2、将安装包上传至服务器

软件安装包版本规则如：gccli-9.5.3.xx-OSversion-platform.tar.bz2

3、解压安装包

[gbase@keep-gbase8a-gdom ~]$ tar xjf gccli_MPP_Cluster-9.5.3.27.20_patch.5-redhat7-x86_64.tar.bz2

4、执行安装

[gbase@keep-gbase8a-gdom ~]$ ls
gccli_install  gccli_MPP_Cluster-9.5.3.27.20_patch.5-redhat7-x86_64.tar.bz2
[gbase@keep-gbase8a-gdom ~]$ cd gccli_install/
[gbase@keep-gbase8a-gdom gccli_install]$ chmod 744 gccli_install.sh
[gbase@keep-gbase8a-gdom gccli_install]$ sh gccli_install.sh gccli_standalone.tar.bz2
./gcluster/
./gcluster/server/
./gcluster/server/lib/
./gcluster/server/lib/gbase/
./gcluster/server/bin/
./gcluster/server/bin/gbase
./gcluster/server/bin/dump
./gcluster/config/
./gcluster/config/gbase_8a_gcluster.cnf
Installation finished.
Please run "/home/gbase/gccli_install/gcluster/server/bin/gccli -uUSER -pPASSWORD -hGCLUSTER_NODE_IP" for checking.

5、测试数据库连接

[gbase@keep-gbase8a-gdom ~]$ /home/gbase/gccli_install/gcluster/server/bin/gccli -ugbase -p -h192.168.122.21

参数说明：

参数名称	描 述
-h	指定连接的 IP，连接的 IP 必须是集群的 Coordinator Cluster节点；
-u	指定数据库用户
-p	表示-u 参数指定得数据库用户的密码。

6、配置环境变量

[gbase@keep-gbase8a-gdom ~]$ cat ~/.bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

# 添加这两行
export GCLUSTER_HOME=/home/gbase/gccli_install/gcluster
PATH=$GCLUSTER_HOME/server/bin:$PATH
[gbase@keep-gbase8a-gdom ~]$ source ~/.bash_profile

7、测试gccli

[gbase@keep-gbase8a-gdom ~]$ gccli -ugbase -p -h192.168.122.21