虚拟集群vc管理

虚拟集群VC管理

示例：（方便下面章节的说明）

[gbase@lww-node-1 gcinstall95314]$ gcadmin

CLUSTER STATE:         ACTIVE

====================================

| GBASE GCWARE CLUSTER INFORMATION |

====================================

| NodeName |  IpAddress   | gcware |

------------------------------------

| gcware1  |  10.10.0.82  |  OPEN  |

------------------------------------

| gcware2  | 10.10.2.105  |  OPEN  |

------------------------------------

=====================================================

|       GBASE COORDINATOR CLUSTER INFORMATION       |

=====================================================

|   NodeName   |  IpAddress  | gcluster | DataState |

-----------------------------------------------------

| coordinator1 | 10.10.0.82  |   OPEN   |     0     |

-----------------------------------------------------

| coordinator2 | 10.10.2.105 |   OPEN   |     0     |

-----------------------------------------------------

============================================================

|         GBASE CLUSTER FREE DATA NODE INFORMATION         |

============================================================

| NodeName  |  IpAddress  | gnode | syncserver | DataState |

------------------------------------------------------------

| FreeNode1 | 10.10.4.70| OPEN  |    OPEN    |     0     |

------------------------------------------------------------

| FreeNode2 | 10.10.2.97| OPEN  |    OPEN    |     0     |

------------------------------------------------------------

| FreeNode3 | 10.10.0.82 | OPEN  |    OPEN    |     0     |

------------------------------------------------------------

| FreeNode4 | 10.10.2.229 | OPEN  |    OPEN    |     0     |

------------------------------------------------------------

2 coordinator node

4 free data node

1.1创建VC

配置文件：

[gbase@lww-node-1 ~]$cat e1

<?xml version='1.0' encoding="utf-8"?>

<servers>

    <rack>

        <node ip="10.10.4.70"/>     ---freenode节点信息

        <node ip="10.10.2.97"/>

    </rack>

<vc_name name="vc1"/>            ---vc名称

<comment message="70,97"/>        ---vc备注信息

</servers>

执行创建VC语句：

[gbase@lww-node-1 ~]$ gcadmin createvc e1

parse config file e1

generate vc id: vc00001

add vc information to cluster

add nodes to vc

gcadmin create vc [vc1] successful

按上述相同步骤，创建VC2，最终集群状态如下：

[gbase@lww-node-1 gcinstall95314]$ gcadmin

CLUSTER STATE:         ACTIVE

====================================

| GBASE GCWARE CLUSTER INFORMATION |

====================================

| NodeName |  IpAddress   | gcware |

------------------------------------

| gcware1  |  10.10.0.82  |  OPEN  |

------------------------------------

| gcware2  | 10.10.2.105  |  OPEN  |

------------------------------------

=====================================================

|       GBASE COORDINATOR CLUSTER INFORMATION       |

=====================================================

|   NodeName   |  IpAddress  | gcluster | DataState |

-----------------------------------------------------

| coordinator1 | 10.10.0.82  |   OPEN   |     0     |

-----------------------------------------------------

| coordinator2 | 10.10.2.105 |   OPEN   |     0     |

-----------------------------------------------------

=============================================

|     GBASE VIRTUAL CLUSTER INFORMATION     |

=============================================

|    VcName    | DistributionId |  comment  |

---------------------------------------------

|     vc1      |       1        | 70,97     |

---------------------------------------------

|     vc2      |       2        | 82,229    |

---------------------------------------------

2 virtual cluster: vc1, vc2

2 coordinator node

0 free data node

登录集群查看VC信息如下：

[gbase@lww-node-1 ~]$ gccli -uroot

GBase client 9.5.3.14.121230. Copyright (c) 2004-2020, GBase.  All Rights Reserved.

gbase> show vcs;

+---------+------+---------+

| id      | name | default |

+---------+------+---------+

| vc00001 | vc1  |         |

| vc00002 | vc2  |         |

+---------+------+---------+

2 rows in set (Elapsed: 00:00:00.00)

1.2默认VC

用户可被授权访问多个VC，但只能设置一个默认VC，默认VC也就是在不指定VC时，用户所有使用的VC。

设置默认VC命令：

set default_vc for user_name=vc_name;

取消默认VC命令：

set default_vc for user_name=null;

说明：用户对VC的使用，由权限进行管理，也就是需要对普通用户授予相应VC的相应权限，该用户才可以对相应VC进行相应操作。

1.3修改VC

修改VC名命令：

[gbase@lww-node-1 ~]$ gcadmin renamevc vc2 vc12

gcadmin rename vc [vc2] to [vc12] successful

登录集群查看VC信息如下：

[gbase@lww-node-1 ~]$ gccli -uroot

GBase client 9.5.3.14.121230. Copyright (c) 2004-2020, GBase.  All Rights Reserved.

gbase> show vcs;

+---------+------+---------+

| id      | name | default |

+---------+------+---------+

| vc00001 | vc1  |         |

| vc00002 | vc12  |         |

+---------+------+---------+

2 rows in set (Elapsed: 00:00:00.00)

备注：修改的只是vc名，vc的id信息不会改变。

1.4删除VC

删除VC命令：

[gbase@lww-node-1 ~]$ gcadmin rmvc vc12

check cluster mode ...

check vc [vc12] exist ...

vc [vc12] will be removed

please ensure this is ok, input [Y,y] or [N,n]: y

select count(*) from gbase.nodedatamap where data_distribution_id=2 result is not 0

refreshnodedatamap drop 2 success

gcadmin rmvc vc12 successful

备注：需要将所有用户库删除后才可以删除vc，否则删除vc时会报错。

1.5 VC服务启停

VC服务启动命令：

gcadmin startvc vc1 gbase gbase

VC服务停止命令：

gcadmin stopvc vc1 gbase gbase