E02 GBase 8a MPP Cluster V95 集群管理练习

最新推荐文章于 2024-03-27 15:26:12 发布
最新推荐文章于 2024-03-27 15:26:12 发布
阅读量3.9k 收藏 29
点赞数 2
文章标签： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wiserhowe/article/details/118219948
版权

GBase 8a MPP Cluster 集群管理练习

一、集群服务管理

  • ①　查看集群状态
    [gbase@node173 ~]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

============================================================================
|                                    GBASE DATA CLUSTER INFORMATION         |
============================================================================
| NodeName |  IpAddress   | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node3   | 172.16.9.175 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
  • ②　查看集群服务
    [gbase@node173 ~]$ gcluster_services all info
gcware is running
gcluster is running
gcrecover is running
gbase is running
syncserver is running

③　停止集群服务
[gbase@node173 ~]$ gcluster_services all stop

Stopping GCMonit success!
Stopping gcrecover :                                       [  OK  ]
Stopping gcluster :                                        [  OK  ]
Stopping gcware :                                          [  OK  ]
Stopping gbase :                                           [  OK  ]
Stopping syncserver :                                      [  OK  ]

在另一个节点上使用gcadmin查看集群状态
[gbase@node174 ~]$ gcadmin

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 | CLOSE  |  CLOSE   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

============================================================================
|                            GBASE DATA CLUSTER INFORMATION                 |
============================================================================
| NodeName |  IpAddress   | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | CLOSE |    CLOSE   |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node3   | 172.16.9.175 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------

开启管理节点所有集群服务
[gbase@node173 ~]$ gcluster_services all start

Starting gcware :                                          [  OK  ]
Starting gcluster :                                        [  OK  ]
Starting gcrecover :                                       [  OK  ]
Starting gbase :                                           [  OK  ]
Starting syncserver :                                      [  OK  ]
Starting GCMonit success!

集群状态恢复正常。

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

============================================================================
|                        GBASE DATA CLUSTER INFORMATION                     |
============================================================================
| NodeName |  IpAddress   | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   | 172.16.9.175 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------

关闭数据节点集群服务
[gbase@node175 ~]$ gcluster_services all stop

Stopping GCMonit success!
Stopping gbase :                                           [  OK  ]
Stopping syncserver :                                      [  OK  ]

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 | CLOSE  |  CLOSE   |     0     |
---------------------------------------------------------------

============================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
============================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node3   |               172.16.9.175               |       1        | CLOSE |    CLOSE   |     0     |
----------------------------------------------------------------------------

注：仔细查看每次gcadmin显示出的集群状态
④　恢复一个服务进程
[gbase@node175 ~]$ gcluster_services gbase start

Starting gbase :                                           [  OK  ]

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 | CLOSE  |  CLOSE   |     0     |
---------------------------------------------------------------

=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               172.16.9.173               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               172.16.9.174               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               172.16.9.175               |       1        | OPEN  |    CLOSE   |     0     |
---------------------------------------------------------------------------------------------------------

⑤　恢复另一个服务进程
[gbase@node175 ~]$ gcluster_services syncserver start

Starting gbase :                                           [  OK  ]

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 | CLOSE  |  CLOSE   |     0     |
---------------------------------------------------------------

=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               172.16.9.173               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               172.16.9.174               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               172.16.9.175               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------

注：此时并没有恢复GCMonit进程。所以，进程异常关闭，不会自动拉起。
再此操作syncserver进程关闭：
[gbase@node175 ~]$ gcluster_services syncserver stop

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 | CLOSE  |  CLOSE   |     0     |
---------------------------------------------------------------

=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               172.16.9.173               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               172.16.9.174               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               172.16.9.175               |       1        | OPEN  |    CLOSE   |     0     |
---------------------------------------------------------------------------------------------------------

⑥开启gcmonit 工具
[gbase@node175 ~]$ gcmonit --start

Starting gcmonit success!
Starting syncserver :                                      [  OK  ]
Starting gcmmonit success!

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               172.16.9.173               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               172.16.9.174               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               172.16.9.175               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------

注：GCMonit开启后，异常关闭的进程会自动拉起。

二、集群模式

① 修改管理节点 173 集群模式为只读
[gbase@node173 ~]$ gcadmin switchmode readonly

========== switch cluster mode...
switch pre mode:                 [NORMAL]
switch mode to                   [READONLY]
switch after mode:               [READONLY]

[gbase@node173 ~]$ gcadmin

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  READONLY
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

============================================================================
|                  GBASE DATA CLUSTER INFORMATION                          |
============================================================================
| NodeName |  IpAddress   | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node3   | 172.16.9.175 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------

②此时尝试对数据库写操作
[gbase@node173 ~]$ gccli

GBase client 9.5.2.35.125594. Copyright (c) 2004-2021, GBase.  All Rights Reserved.

gbase> create database testdb;

由于集群处于readonly模式，该SQL的执行被阻塞。

③在管理节点 174 切换集群模式为normal：
[gbase@node174 ~]$ gcadmin switchmode normal

========== switch cluster mode...
  switch pre mode:                 [READONLY]
  switch mode to                   [NORMAL]
  switch after mode:               [NORMAL]

等待大约 5 分钟，173 阻塞的SQL命令会继续执行，无需人为干预。其执行结果如下：

Query OK, 1 row affected (Elapsed: 00:05:00.16)

④验证testdb库创建是否成功：
gbase> show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| gbase              |
| gctmpdb            |
| gclusterdb         |
| testdb             |
+--------------------+
6 rows in set (Elapsed: 00:00:00.01)

⑤修改集群模式为recovery
[gbase@node173 ~]$ gcadmin switchmode recovery

========== switch cluster mode...
  switch pre mode:                 [NORMAL]
  switch mode to                   [RECOVERY]
  switch after mode:               [RECOVERY]

[gbase@node173 ~]$ gcadmin

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  RECOVERY
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

============================================================================
|                        GBASE DATA CLUSTER INFORMATION                     |
============================================================================
| NodeName |  IpAddress   | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node3   | 172.16.9.175 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------

[gbase@node173 ~]$ gccli

GBase client 9.5.2.35.125594. Copyright (c) 2004-2021, GBase.  All Rights Reserved.
gbase>use testdb;
gbase>select database();
ERROR 1707 (HY000): gcluster command error: (GBA-02CO-0002) Currently,gcluster is at recovery mode,current operation isn't allowed.

[gbase@node173 ~]$ gcadmin switchmode normal

========== switch cluster mode...
  switch pre mode:                 [RECOVERY]
  switch mode to                   [NORMAL]
  switch after mode:               [NORMAL]

[gbase@node173 ~]$ gcadmin

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               172.16.9.173               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               172.16.9.174               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               172.16.9.175               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------

[gbase@node173 ~]$ gccli

GBase client 9.5.2.35.125594. Copyright (c) 2004-2021, GBase.  All Rights Reserved.

gbase>use testdb;
gbase>select database();

+------------+
| database() |
+------------+
| testdb    |
+------------+
1 row in set (Elapsed: 00:00:00.00)

三、集群日志

  • 关闭一个节点的所有集群服务
    [gbase@node175 ~]$ gcluster_services all stop
Stopping GCMonit success!
Stopping gbase :                                           [  OK  ]
Stopping syncserver :                                      [  OK  ]

在管理节点查看集群状态

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 | CLOSE  |  CLOSE   |     0     |
---------------------------------------------------------------

=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |               172.16.9.173               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node2   |               172.16.9.174               |       1        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node3   |               172.16.9.175               |       1        | CLOSE |   CLOSE    |     0     |
---------------------------------------------------------------------------------------------------------

①DDLevent日志

  • 删除用户库：
    gbase> drop database testdb;
Query OK, 0 rows affected (Elapsed: 00:00:00.11)
  • 查看集群状态：
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 | CLOSE  |  CLOSE   |     1     |
---------------------------------------------------------------

============================================================================
|                            GBASE DATA CLUSTER INFORMATION                 |
============================================================================
| NodeName |  IpAddress   | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node3   | 172.16.9.175 |       1        | CLOSE |   CLOSE    |     1     |
----------------------------------------------------------------------------
  • 查看DDLevent日志：
    [gbase@node174 ~]$ gcadmin showddlevent
Vc event count:1
Event ID:    2
ObjectName: testdb
Fail Node Copy:
------------------------------------------------------

Fail Data Copy:
------------------------------------------------------
NodeIP: 172.16.9.175	FAILURE
  • 创建一个新库：
    gbase> create database testdb1;
  • 在新库内创建一张新表：
    gbase> create table student( sno varchar(20),sname varchar(20),ssex varchar(3),sage int(4),sdept varchar(20));
  • 插入数据:
    gbase> insert into student values (‘200215121’,‘liyong’,‘F’,20,‘CS’);
  • 查看DDLevent日志：
    [gbase@node174 ~]$ gcadmin showddlevent
Vc event count:4
Event ID:    2
ObjectName: testdb
Fail Node Copy:
------------------------------------------------------
NodeID: 3037270188	NodeIP:172.16.9.175	FAILURE

Fail Data Copy:
------------------------------------------------------
NodeIP: 172.16.9.175	FAILURE

Event ID:    3
ObjectName: testdb1
Fail Node Copy:
------------------------------------------------------
NodeID: 3037270188	NodeIP:172.16.9.175	FAILURE

Fail Data Copy:
------------------------------------------------------
NodeIP: 172.16.9.175	FAILURE

Event ID:    5
ObjectName: testdb1.student
Fail Node Copy:
------------------------------------------------------
NodeID: 3037270188	NodeIP:172.16.9.175	FAILURE

Fail Data Copy:
------------------------------------------------------
SegName: n1	NodeIP: 172.16.9.175	FAILURE
SegName: n5	NodeIP: 172.16.9.175	FAILURE
SegName: n4	NodeIP: 172.16.9.175	FAILURE
SegName: n7	NodeIP: 172.16.9.175	FAILURE

Event ID:    6
ObjectName: testdb1.student
Fail Node Copy:
------------------------------------------------------
NodeID: 3037270188	NodeIP:172.16.9.175	FAILURE

Fail Data Copy:
------------------------------------------------------
SegName: n1	NodeIP: 172.16.9.175	FAILURE
SegName: n5	NodeIP: 172.16.9.175	FAILURE
SegName: n4	NodeIP: 172.16.9.175	FAILURE
SegName: n7	NodeIP: 172.16.9.175	FAILURE

②　DMLevent日志
[gbase@node174 ~]$ gcadmin showdmlevent;

Vc event count:1
Event ID:    2
ObjectName: testdb1.student

Fail Data Copy:
------------------------------------------------------
SegName: n1	SCN: 4103 	NodeIP: 172.16.9.175	FAILURE

③　恢复故障节点
[gbase@node175 ~]$ gcluster_services all start

Starting gcware :                                          [  OK  ]
Starting gcluster :                                        [  OK  ]
Starting gcrecover :                                       [  OK  ]
Starting gbase :                                           [  OK  ]
Starting syncserver :                                      [  OK  ]
Starting GCMonit success!

注：系统自动进行数据同步，略等一段时间，DataState状态由“1”转变为“0”。

CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL
===============================================================
|            GBASE COORDINATOR CLUSTER INFORMATION            |
===============================================================
|   NodeName   |  IpAddress   | gcware | gcluster | DataState |
---------------------------------------------------------------
| coordinator1 | 172.16.9.173 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator2 | 172.16.9.174 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------
| coordinator3 | 172.16.9.175 |  OPEN  |   OPEN   |     0     |
---------------------------------------------------------------

============================================================================
|                              GBASE DATA CLUSTER INFORMATION               |
============================================================================
| NodeName |  IpAddress   | DistributionId | gnode | syncserver | DataState |
----------------------------------------------------------------------------
|  node1   | 172.16.9.173 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node2   | 172.16.9.174 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------
|  node3   | 172.16.9.175 |       1        | OPEN  |    OPEN    |     0     |
----------------------------------------------------------------------------

[gbase@node174 ~]$ gcadmin showddlevent;

Vc event count:0

[gbase@node174 ~]$ gcadmin showdmlevent;

Vc event count:0
wiserhowe
关注
  • 2
    点赞
  • 踩
  • 29
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
gbase8s题目.docx
11-26
gbase8s认证题目整理134题
E03 GBase 8a MPP Cluster V95 SQL 综合练习
南大通用郝老师的专栏
06-25 4183
GBase 8a MPP Cluster V95 SQL操作综合练习 一、安全管理 二、数据库对象基本操作 三、SQL查询 四、系统表查询
GBase 8a MPP Cluster学习——初识
hlsong的博客
05-17 620
GBase 8a MPP Cluster（简称“8a集群”）是南大通用公司自主研发、国内领先的大规模分布式并行处理数据库集群系统，具有满足各个数据密集型行业日益增大的数据分析、数据挖掘、数据备份和即席查询等需求。
GBase 8a MPP Cluster 认证培训资料汇总
热门推荐
南大通用郝老师的专栏
07-13 1万+
一、课前准备： 《GBase 8a MPP Cluster GDCA 认证培训课前准备》 https://blog.csdn.net/wiserhowe/article/details/118608321 二、怎样进入高校暑期班202107学习模块： 《高校暑期班202107访问路径》 https://blog.csdn.net/wiserhowe/article/details/118566457 三、课中练习： 《E01 GBase 8a MPP Cluster V95 安装和卸载》 https://b
南大通用GBase 8a集群管理培训资料
09-18
1-GBase 8a MPP Cluster 产品介绍.pdf 2-GBase 8a MPP Cluster 安装部署.pdf 3-GBase 8a MPP Cluster 日常维护.pdf 4-GBase 8a MPP Cluster SQL指南.pdf 5-GBase 8a MPP Cluster 数据加载.pdf 6-GBase 8a MPP Cluster 数据导出.pdf 7-GBase 8a MPP Cluster 日常巡检.pdf 8-GBase 8a MPP Cluster 集群管理-节点替换.pdf GBase 8a MPP Cluster 日常维护数据迁移sql操作练习.pdf
E02 I2C v1.2.7
最新发布
05-28
描述 "E02 I2C 数据读写模块配套上位机软件" 暗示存在一个配套的上位机应用程序，该程序是用于控制和管理E02 I2C模块的。上位机软件通常在个人电脑上运行，与嵌入式系统（如E02 I2C模块）进行通信，执行数据的读取和...
E02_面向对象复习.pdf
11-02
面向对象是程序设计的一种核心思想，它将现实世界中的实体抽象为类，而类的实例化则成为对象。在Java中，面向对象体现在通过类来描述对象的属性和行为，通过对象来调用类中的方法来实现功能。 ...
E02：E02
02-19
【E02：深入理解TypeScript】 在编程领域，TypeScript作为JavaScript的超集，已经逐渐成为开发大型、复杂项目的首选语言。E02，可能是某个教程或系列文章的第二部分，专门探讨了TypeScript的相关知识。让我们深入...
E02：进程基本概念（参考答案）1
08-04
操作系统是计算机系统的核心组成部分，负责管理和控制系统的硬件和软件资源，提供用户接口和服务。在操作系统中，进程管理是一项基础且重要的任务，它涉及到程序的执行、资源分配和调度等多个方面。以下是基于题目给...
E02-WROD.zip
05-09
【标题】"E02-WROD.zip" 指的可能是一个压缩文件，其中包含了与"Word"相关的资源或教程。尽管没有提供具体的标签，我们可以假设这可能是一些关于Microsoft Word使用的文档、模板或者代码示例。由于压缩包内的文件名...
GBase 8a MPP Cluster程序员手册JDBC篇.pdf
08-20
1.1 GBase JDBC 介绍 ....................................... 2 1.2 GBase JDBC 版本 ....................................... 2 1.3 GBase JDBC 与 jdk 的兼容性 ............................. 3 1.4 从旧版本升级到 8.3.81.x 注意事项 ....................... 3 1.5 安装文件 ............................................. 4 2 GBase JDBC
GBase8a-GDCA认证考试-复习参考题
weixin_41826637的博客
03-27 563
为提升产品服务水平定期举办GBase产品认证培训，培训更多GBase数据库专业人员，满足用户快速成长的业务需求，建设GBase产品生态。请注意甄别，根据所学知识综合判断，正确率97%（97分）。
GBase 8a MPP 相关命令整理（好用的很）
林深时觉寒的博客
11-30 365
GBase 8a MPP
南大通用数据库-Gbase-8a-学习-24-全文检索
qq_45111959的博客
10-18 690
没有加双引号，是分开匹配的，只要包含这两个字就可以，所以把’我是小太太啦啦啦阳’也匹配出来。我们加上双引号，太阳是一个组合，不能分开匹配，所以过滤掉了’我是小太太啦啦啦阳’。第二个IS是大写，发现也能匹配上，可能内部是全部转换成大写或小写，再去匹配的。包含“太太”或包含“小“但不能包含“太阳”，把括号来改变执行顺序。包含”太“或”小月亮“, 但不包含”太阳“的。英文字母一个，全文检索不出来。一个数字不对，没有全部匹配出来。英文字母两个以上，测试正常。三个字中满足两个，返回结果。三个字中满足三个，返回结果。
南大通用 gbase8a 认证培训课后题（一）
PY_XAT_SFZL的博客
11-16 871
gbase8a 第一阶段练习题第一次练习（4选4）1234第二次练习（5选5）12345第三次练习（5选3）12345第四次练习（6选4）123456第五次练习（7选4）1234567第六次练习（5选3）12345第七次练习（7选5）1234567 第一次练习（4选4） 1 2 3 4 第二次练习（5选5） 1 2 3 4 5 第三次练习（5选3） 1 2 3 4 5 第四次练习（6选4） 1 2 3 4 5 6 第五次练习（7选4） 1 2 3 4 5 6
2022 十二月 GBase8a 班阶段考试 01 - 数据库运维知识 答案
sinat_38959307的博客
12-15 3239
2022 十二月 GBase8a 班阶段考试 01 - 数据库运维知识
2022十二月GBase8a第一次阶段考试01-数据库运维知识
m0_74310050的博客
12-10 2158
gbase 8a学习系统数据库运维知识
Gbase 8a GDCA考试真题100%
打工之路，一路生花
03-16 2405
本文整理一些Gbase 8a中非常易错得考试真题及答案，而且都是不好搜的。加粗的是正确答案。
GBase 8a MPP Cluster V95 SQL 实用常见命令汇总(E03)
huixinhuiyismile的博客
05-11 547
E03 GBase 8a MPP Cluster V95 SQL 实用常见命令汇总 一、安全管理 使用数据库超户root连接数据库后，创建数据库，创建新用户组和用户，并给新用户组和用户分配相关权限 ①　连接登录集群数据库（默认管理员为root，密码为空） gccli -u用户名 -p密码 gccli -uroot -p ②　给root用户设置密码，保障安全 set password for root =password('Peixun_2021'); ③　创建数据库 create database if
亿咖通E02芯片介绍
05-01
亿咖通科技推出的E02芯片是一款车规级座舱计算模组[^1]。该芯片已经累计出货将近200万片，并且被吉利系以及其他众多汽车企业所采用。E02芯片具有以下特点： - 高性能：E02芯片采用先进的计算技术，具备强大的计算...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值