1.增加节点
将新节点启动到local open状态
gSQL> startup;
在新节点清理集群信息（新节点可不执行）
gSQL> ALTER DATABASE RESET LOCAL CLUSTER MEMBER;
将新节点开启到全局开启
gSQL> alter system open global database;
创建或增加新节点进入集群（主节点执行）
gSQL> create cluster group g2 cluster member g2n1 host ‘192.168.20.16’ port 11111;
gSQL> alter cluster group g2 add cluster member g2n2 host ‘192.168.20.17’ port 11111;
新节点重平衡数据
gSQL> alter database rebalance;
查看节点信息
gSQL> select a.GROUP_NAME,a.GROUP_ID,a.MEMBER_ID, a.MEMBER_NAME,a.MEMBER_HOST, b.STATUS, b.IS_GLOBAL_COORD,b.IS_GROUP_COORD,b.MEMBER_POSITION from dba_cluster a,gv$cluster_member b where a.MEMBER_ID=b.MEMBER_ID and a.MEMBER_POSITION=b.MEMBER_POSITION order by 1,2;
2.删除分组
查看集群信息
gSQL> select * from tech_cluster;
迁移数据
gSQL> alter database REBALANCE EXCLUDE CLUSTER GROUP g3;
删除分组
gSQL> drop cluster group g3;
3.删除节点
关闭需要下线的节点
gSQL> shutdown abort;
查询现在不活跃的节点
gSQL> select a.GROUP_NAME,a.GROUP_ID,a.MEMBER_ID, a.MEMBER_NAME,a.MEMBER_HOST, b.STATUS, b.IS_GLOBAL_COORD,b.IS_GROUP_COORD,b.MEMBER_POSITION from dba_cluster a,gv$cluster_member b where a.MEMBER_ID=b.MEMBER_ID and a.MEMBER_POSITION=b.MEMBER_POSITION order by 1,2 ;
下线不活跃的集群节点
gSQL> ALTER DATABASE DROP INACTIVE CLUSTER MEMBERS;
