南大通用GBase 8a数据库集群V95版本启动和停止VC内的所有数据节点服务

GBase 8a数据库集群在9.5版里,提供了启动,停止所有数据节点的功能。一般数据节点都很多,几十到上百个,该功能可以快速的停止指定VC或者默认所有数据节点的服务。当然对管理节点是不生效的。

gcadmin stopvc VCNAME dba_user dba_pwd

gcadmin startvc VCNAME dba_user dba_pwd
其中vcname 如果是自建了vc,那么用vcname, 如果是从86升级的,或者默认安装没有创建vc,那么默认的vc是 vcname000001

vcname支持一次启停多个,用逗号分割。

dba_user是数据库的操作系统用户

dba_user是数据库的操作系统用户密码
比如

gcadmin stopvc vcname000001 gbase gbase1234

[gbase@gbase_rh7_001 gcinstall]$ gcadmin startvc vc1 vc2 gbase gbase1234
gcadmin startvc ...
gcadmin startvc check vc exist
gcadmin startvc get vc node list
gcadmin start virtual cluster successful
[gbase@gbase_rh7_001 gcinstall]$


[gbase@gbase_rh7_001 gcinstall]$ gcadmin stopvc vc1 vc2 gbase gbase1234
gcadmin stopvc ...
gcadmin stopvc check vc exist
gcadmin stopvc get vc node list
gcadmin stop virtual cluster successful
[gbase@gbase_rh7_001 gcinstall]$ gcadmin showcluster vc vc1
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

=============================================
|     GBASE VIRTUAL CLUSTER INFORMATION     |
=============================================
|    VcName    | DistributionId |  comment  |
---------------------------------------------
|     vc1      |      1,4       | vc_101    |
---------------------------------------------
=========================================================================================================
|                                 VIRTUAL CLUSTER DATA NODE INFORMATION                                 |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |                10.0.2.101                |      1,4       | CLOSE |   CLOSE    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |                10.0.2.102                |      1,4       | CLOSE |   CLOSE    |     0     |
---------------------------------------------------------------------------------------------------------

2 data node

[gbase@gbase_rh7_001 gcinstall]$ gcadmin showcluster vc vc2
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

=============================================
|     GBASE VIRTUAL CLUSTER INFORMATION     |
=============================================
|    VcName    | DistributionId |  comment  |
---------------------------------------------
|     vc2      |      2,3       | vc_102    |
---------------------------------------------
=========================================================================================================
|                                 VIRTUAL CLUSTER DATA NODE INFORMATION                                 |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |                10.0.2.115                |      2,3       | CLOSE |   CLOSE    |     0     |
---------------------------------------------------------------------------------------------------------

1 data node

[gbase@gbase_rh7_001 gcinstall]$

备注:目前,没有一个命令停止所有管理节点的功能。