GBase 8a 管理员常用命令---showdmlstorageevent和showcluster

showdmlstorageevent 命令

语法：
gcadmin showdmlstorageevent [table ID segname nodeip] |]
注：该命令格式与 8.5.1.2 的 showdmlstorageevent 命令相同，但fevent 信息格式有变化，系统中有 DML storage event 时不能对集群进行升级。
功能：
该命令用来显示当前集群有表的元数据和数据文件损坏信息；

示例：

$ gcadmin showdmlstorageevent
Event count:2
Event ID: 5
ObjectName: test.t1
TableID: 26
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 192.168.153.129 FAILURE
Event ID: 6
ObjectName: test.t2
TableID: 32
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 192.168.153.129 FAILURE

showcluster 命令

语法：
gcadmin showcluster [c | d | f]
参数说明：
c：仅显示集群 coordinator 节点信息；
d：仅显示集群 data 节点信息；
f：按照 xml 格式显示集群节点信息。
功能：
显示集群节点信息，若不输入参数 c 或 d 则显示集群所有节点信息。

示例：
显示所有节点信息，示例如下：

$ gcadmin showcluster

CLUSTER STATE: ACTIVE
CLUSTER MODE: NORMAL
===============================================================
| Gbase COORDINATOR CLUSTER INFORMATION |
===============================================================
| NodeName | IpAddress |gcware |gcluster |DataState |
---------------------------------------------------------------
| coordinator1 | 192.168.153.129 | OPEN | OPEN | 0 |
---------------------------------------------------------------
===========================================================
| Gbase DATA CLUSTER INFORMATION |
===========================================================
|NodeName | IpAddress |gnode |syncserver |DataState |
-----------------------------------------------------------
| node1 | 192.168.153.126 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node2 | 192.168.153.129 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node3 | 192.168.153.125 | OPEN | OPEN | 0 |
-----------------------------------------------------------

showcluster 命令显示所有节点

仅显示 coordinator 节点信息，示例如下:

$ gcadmin showcluster c
CLUSTER STATE: ACTIVE
CLUSTER MODE: NORMAL
===============================================================
| Gbase COORDINATOR CLUSTER INFORMATION |
===============================================================
| NodeName | IpAddress |gcware |gcluster |DataState |---------------------------------------------------------------
| coordinator1 | 192.168.153.129 | OPEN | OPEN | 0 |
---------------------------------------------------------------

showcluster 命令仅显示 coordinator 节点

仅显示 data 节点信息，示例如下:

$ gcadmin showcluster d
CLUSTER STATE: ACTIVE
CLUSTER MODE: NORMAL
===========================================================
| Gbase DATA CLUSTER INFORMATION |
===========================================================
|NodeName | IpAddress |gnode |syncserver |DataState |
-----------------------------------------------------------
| node1 | 192.168.153.126 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node2 | 192.168.153.129 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node3 | 192.168.153.125 | OPEN | OPEN | 0 |

showcluster 命令仅显示 data 节点

按照 xml 格式显示 data 节点信息，示例如下:

$ gcadmin showcluster d f



ACTIVED
NORMAL


node1
192.168.153.126
OPEN
OPEN0


node4
192.168.153.129
OPEN
OPEN
0


node5
192.168.153.125
OPEN
OPEN
0

xml 格式显示 data 节点信息

示例如下:

$ gcadmin showcluster | grep -iE "close|offline|unavailable|replace| 1"
| coordinator1 | 192.168.92.129 | OFFLINE | OPEN | 0 |
| coordinator2 | 192.168.92.130 | OPEN | CLOSE | 1 |
| node1 | 192.168.92.129 | OFFLINE | OPEN | 0 |
| node2 | 192.168.92.130 | OPEN | OPEN | 1 |

复制

gbasegbase 8agbase南大通用gbase 8a mpp cluster

GBase 8a 管理员常用命令---showdmlstorageevent和showcluster

大数据系统相关栏目本月热门文章