返回首页

gbase数据、南大通用产品文档:GBase8c示例

更新日期:2024年09月11日

示例一:升级前使用新包进行前置操作。
[gbase@gbasehost ~]$ gs_preinstall -U gbase -G gbase -X
/data/xml/3node_3c3d_1m2s_etcd.xml
Parsing the configuration file.
Successfully parsed the configuration file.
Installing the tools on the local node.
Successfully installed the tools on the local node.
Setting pssh path
Successfully set core path.
Distributing package.
Begin to distribute package to tool path.
Successfully distribute package to tool path.
Begin to distribute package to package path.
Successfully distribute package to package path.
Successfully distributed package.
Installing the tools in the cluster.
Successfully installed the tools in the cluster.
Checking hostname mapping.
Successfully checked hostname mapping.
Checking OS version.
Successfully checked OS version.
Creating cluster's path.
Successfully created cluster's path.
Set and check OS parameter.
Setting OS parameters.
Successfully set OS parameters.
Set and check OS parameter completed.
Preparing CRON service.
Successfully prepared CRON service.
Preparing SSH service.
Successfully prepared SSH service.
Setting user environmental variables.
Successfully set user environmental variables.
Configuring alarms on the cluster nodes.
Successfully configured alarms on the cluster nodes.
Setting the dynamic link library.

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
248
Successfully set the dynamic link library.
Setting pssh path
Successfully set pssh path.
Setting Cgroup.
Successfully set Cgroup.
Set ARM Optimization.
Successfully set ARM Optimization.
Preinstalling secbox.
Successfully installed secbox.
Setting finish flag.
Successfully set finish flag.
Preinstallation succeeded.
示例二:使用gs_upgradectl 脚本执行就地升级。
[gbase@gbasehost ~]$ gs_upgradectl -t upgrade -X
/data/xml/3node_3c3d_1m2s_etcd.xml
Static configuration matched with old static configuration files.
Performing inplace rollback.
Rollback succeeded.
Checking upgrade environment.
Successfully checked upgrade environment.
Successfully checked upgrade environment.
Successfully started cluster.
Start to do health check.
Successfully checked cluster status.
Backing up current application and configurations.
Successfully backed up current application and configurations.
Stopping the cluster.
Successfully stopped cluster.
Backing up cluster configuration.
Successfully backup hotpatch config file.
Successfully backed up cluster configuration.
Installing new binary.
Restoring cluster configuration.
Successfully restored cluster configuration.
Modifying the socket path.
Successfully modified socket path.
Switch symbolic link to new binary directory.
Successfully switch symbolic link to new binary directory.
Successfully started cluster.
Start to do health check.

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
249
Successfully checked cluster status.
Upgrade main process has been finished, user can do some check now.
Once the check done, please execute following command to commit upgrade:
gs_upgradectl -t commit-upgrade -X /data/xml/3node_3c3d_1m2s_etcd.xml
示例三:使用gs_upgradectl 脚本执行自动回滚,撤销已经成功/失败的升级操作(升级
回滚)。
[gbase@gbasehost ~]$ gs_upgradectl -t auto-rollback -X
/data/xml/3node_3c3d_1m2s_etcd.xml
Static configuration matched with old static configuration files.
Performing inplace rollback.
Checking static configuration files.
Successfully checked static configuration files.
Restoring cluster configuration.
Successfully rollback hotpatch config file.
Successfully restored cluster configuration.
Switch symbolic link to old binary directory.
Successfully switch symbolic link to old binary directory.
Stopping the cluster.
Successfully stopped cluster.
Restoring application and configurations.
Successfully restored application and configuration.
Restoring cluster configuration.
Successfully rollback hotpatch config file.
Successfully restored cluster configuration.
Successfully started cluster.
Successfully cleaned new install path.
Rollback succeeded.
示例四:使用gs_upgradectl 脚本执行升级后提交(升级提交)。
[gbase@gbasehost ~]$ gs_upgradectl -t commit -X
/data/xml/3node_3c3d_1m2s_etcd.xml
Old cluster app path is /data/gauss/app_e67b8bcd
Successfully Cleaned old install path.
Commit binary upgrade succeeded.

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
250

使用“列管理”功能,您可以对数据库所属的数据表中的列进行管理。
列管理功能只能对用户数据库下的表中的列进行操作,对于系统数据库只
显示列名。
下面的章节将根据如下功能详细介绍列管理功能:

增加列

删除列

查看列属性

编辑列属性



GBase 8a MPP Cluster 管理工具手册
南大通用数据技术股份有限公司

- 65 -

|
4 | 2016-06-02 | B
|
153 |