gbase8a命令

gbase8a相关文档

# （阿里）实战篇：GBase 8a MPP Cluster 安装部署过程
https://developer.aliyun.com/article/830036

# （腾讯）实战篇：GBase 8a MPP Cluster 安装部署过程
https://cloud.tencent.com/developer/article/1930827

# GBase8a数据库安装
https://www.cnblogs.com/braveym/p/16038595.html

gbase8a安装

修改root密码命令
set password for root = password('123456');

查看集群健康信息
gcadmin

启动/停止/重启
gcluster_services all start/stop/restart

show variables like '%general_log%';

开启日志
set global general_log=1;
日志文件地址
gcluster/log/gcluster/gclusterd.log

gbase8a重启遇到的问题

启动命令：gcluster_services all start
再执行查询命令：gcadmin

会出现报错：[gcadmin] Could not initialize CRM instance error: [122]->[can not connect to any server]

查询启动错误日志地址：gcluster/log/gcluster/system.log
查询节点错误日志地址：gnode/log/gbase/system.log

解决方案：
在集群的每台服务器执行命令：gcluster_services all start
并在主数据节点启动gcware：gcware/sbin/gcware

等一会再次执行查询命令：gcadmin，可查询到已正常启动

激活license注意

激活license注意，要使用./License，要不然会出现：'-bash: /tmp/importLicense: No such file or directory'

例如：./License -n 192.168.1.10,192.168.1.20,192.168.1.30 -f /tmp/mpp.lic -u gbase -p 123456