活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

实验目的：验证GBase 8a GNode的高可用性
实验环境：VMware3节点2副本GBase 8a集群
实验步骤：
一、查看当前集群状态

```
[gbase@gbasenode3 ~]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

====================================
| GBASE GCWARE CLUSTER INFORMATION |
====================================
| NodeName |  IpAddress   | gcware |
------------------------------------
| gcware1  | 192.192.1.61 |  OPEN  |
------------------------------------
| gcware2  | 192.192.1.62 |  OPEN  |
------------------------------------
| gcware3  | 192.192.1.63 |  OPEN  |
------------------------------------
======================================================
|       GBASE COORDINATOR CLUSTER INFORMATION        |
======================================================
|   NodeName   |  IpAddress   | gcluster | DataState |
------------------------------------------------------
| coordinator1 | 192.192.1.61 |   OPEN   |     0     |
------------------------------------------------------
| coordinator2 | 192.192.1.62 |   OPEN   |     0     |
------------------------------------------------------
| coordinator3 | 192.192.1.63 |   OPEN   |     0     |
------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               192.192.1.62               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               192.192.1.61               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               192.192.1.63               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
```

二、依次关闭节点2上的gcmmonit、gcmonit及gbase服务

```
[gbase@gbasenode2 ~]$ ps -ef|grep gcmmonit
gbase     24282      1  0 08:41 ?        00:00:38 /opt/gbase/192.192.1.62/gcluster/server/bin/gcmmonit --start
gbase    100976  99514  0 23:09 pts/0    00:00:00 grep --color=auto gcmmonit
[gbase@gbasenode2 ~]$ 
[gbase@gbasenode2 ~]$ kill -9 24282
[gbase@gbasenode2 ~]$ gcmonit.sh stop
Stopping GCMonit success!
[gbase@gbasenode2 ~]$ ps -ef|grep gcmmonit
gbase    101008  99514  0 23:10 pts/0    00:00:00 grep --color=auto gcmmonit
[gbase@gbasenode2 ~]$ gcmonit.sh status
Get Program Status Error!
echo Info: [gcmonit] gcmonit not running
[gbase@gbasenode2 ~]$ gcluster_services gbase stop
Stopping gbase :                                           [  OK  ]
```

此时，查看集群状态：

```
[gbase@gbasenode2 ~]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

====================================
| GBASE GCWARE CLUSTER INFORMATION |
====================================
| NodeName |  IpAddress   | gcware |
------------------------------------
| gcware1  | 192.192.1.61 |  OPEN  |
------------------------------------
| gcware2  | 192.192.1.62 |  OPEN  |
------------------------------------
| gcware3  | 192.192.1.63 |  OPEN  |
------------------------------------
======================================================
|       GBASE COORDINATOR CLUSTER INFORMATION        |
======================================================
|   NodeName   |  IpAddress   | gcluster | DataState |
------------------------------------------------------
| coordinator1 | 192.192.1.61 |   OPEN   |     0     |
------------------------------------------------------
| coordinator2 | 192.192.1.62 |   OPEN   |     0     |
------------------------------------------------------
| coordinator3 | 192.192.1.63 |   OPEN   |     0     |
------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               192.192.1.62               |       1        | CLOSE |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               192.192.1.61               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               192.192.1.63               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
```

验证集群数据读写，预期是集群读写正常：

```
[gbase@gbasenode2 ~]$ gccli -u root -p
Enter password: 

GBase client Free Edition 9.5.3.28.12509af27. Copyright (c) 2004-2026, GBase.  All Rights Reserved.
gbase> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| gbase              |
| gctmpdb            |
| bankqh             |
| gclusterdb         |
| wencheng           |
+--------------------+
7 rows in set (Elapsed: 00:00:00.00)

gbase> select * from bankqh.bk_test3;
+------+--------+
| id   | name   |
+------+--------+
|  701 | bankqh |
+------+--------+
1 row in set (Elapsed: 00:00:00.03)
```

结论：能正常查出业务数据。
二、依次关闭节点3上的gcmmonit、gcmonit及gbase服务

```
[gbase@gbasenode3 ~]$ ps -ef|grep gcmmonit
gbase     24135      1  0 08:41 ?        00:00:38 /opt/gbase/192.192.1.63/gcluster/server/bin/gcmmonit --start
gbase    100683 100622  0 23:15 pts/0    00:00:00 grep --color=auto gcmmonit
[gbase@gbasenode3 ~]$ kill -9 24135
[gbase@gbasenode3 ~]$ gcmonit.sh stop
Stopping GCMonit success!
[gbase@gbasenode3 ~]$ gcluster_services gbase stop
Stopping gbase :                                           [  OK  ]
```

查看当前集群状态：

```
[gbase@gbasenode3 ~]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

====================================
| GBASE GCWARE CLUSTER INFORMATION |
====================================
| NodeName |  IpAddress   | gcware |
------------------------------------
| gcware1  | 192.192.1.61 |  OPEN  |
------------------------------------
| gcware2  | 192.192.1.62 |  OPEN  |
------------------------------------
| gcware3  | 192.192.1.63 |  OPEN  |
------------------------------------
======================================================
|       GBASE COORDINATOR CLUSTER INFORMATION        |
======================================================
|   NodeName   |  IpAddress   | gcluster | DataState |
------------------------------------------------------
| coordinator1 | 192.192.1.61 |   OPEN   |     0     |
------------------------------------------------------
| coordinator2 | 192.192.1.62 |   OPEN   |     0     |
------------------------------------------------------
| coordinator3 | 192.192.1.63 |   OPEN   |     0     |
------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               192.192.1.62               |       1        | CLOSE |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               192.192.1.61               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               192.192.1.63               |       1        | CLOSE |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
```

此时，验证能否读取业务数据：

```
[gbase@gbasenode3 ~]$ gccli -u root -p
Enter password: 

GBase client Free Edition 9.5.3.28.12509af27. Copyright (c) 2004-2026, GBase.  All Rights Reserved.

gbase> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| gbase              |
| gctmpdb            |
| bankqh             |
| gclusterdb         |
| wencheng           |
+--------------------+
7 rows in set (Elapsed: 00:00:00.00)

gbase> select * from bankqh.bk_test3;
ERROR 1708 (HY000): (GBA-02EX-0004) Failed to get metadata:
DETAIL: check nodes, no valid node for suffix: n2, 
please execute 'show datacopymap database.table_name;' to see the detail.
gbase> show datacopymap database.table_name;
+---------+------------+----------+
| dp_name | node_id    | dp_state |
+---------+------------+----------+
| NULL    | 1023525056 |        0 |
| NULL    | 1040302272 |        4 |
| NULL    | 1057079488 |        4 |
+---------+------------+----------+
```

实验结论：整体测试符合预期目标，当三节点集群，二个节点离线后，业务数据无法读取，此时也就是说业务会中断。实际生产业务部署中，为了提高系统的稳定性，会采用网络做bond，磁盘做raid5等模式。未通过集群的专用监控管理平台做测试，在监控管理平台界面，预期是当节点2停止服务后，停止节点3的操作被阻断，即要阻断风险操作。



运维管理

GNode高可用测试

GNode高可用测试

评论

热门帖子