GBase数据库——常用命令

最新推荐文章于 2024-08-21 15:43:21 发布

MrCode0828

最新推荐文章于 2024-08-21 15:43:21 发布

阅读量1w

点赞数 3

文章标签：数据库操作系统运维

原文链接：http://www.cnblogs.com/BrokenSwitch/p/8472773.html

版权

本文介绍了GBase 8a数据库的常用命令，包括数据库的启停、集群和进程状态查询、数据库访问方法如命令行访问、信息查询如数据库节点和副本情况、版本和参数查询，以及故障定位技巧如查看错误日志和数据库锁情况。

摘要由CSDN通过智能技术生成

针对GBase 8a 版本

1数据库操作与维护

1.1数据库启停

[root@OMMB-66-V10-001 ~]# service gcware stop
Stopping GCMonit success!
Signaling GCRECOVER (gcrecover) to terminate: [ OK ]
Waiting for gcrecover services to unload:.....[ OK ]
Signaling GCSYNC (gc_sync_server) to terminate: [ OK ]
Waiting for gc_sync_server services to unload:.[ OK ]
Signaling GCLUSTERD to terminate: [ OK ]
Waiting for gclusterd services to unload:.........[ OK ]
Signaling GBASED to terminate: [ OK ]
Waiting for gbased services to unload:^[[A.........[ OK ]
Signaling GCWARE (gcware) to terminate: [ OK ]
Waiting for gcware services to unload:.[ OK ]
[root@OMMB-66-V10-001 ~]# service gcware start
Starting GCWARE (gcwexec): [ OK ]
Starting GCMonit success!
Starting GBASED : [ OK ]
Starting GCLUSTERD : [ OK ]
Starting GCSYNC : [ OK ]
Starting GCRECOVER : [ OK ]
[root@OMMB-66-V10-001 ~]# service gcware restart

1.2集群状态查询

[root@zdc3 zdcapp3]# gcadmin
CLUSTER STATE: ACTIVE
CLUSTER MODE: NORMAL
===============================================================
| GBASE COORDINATOR CLUSTER INFORMATION |
===============================================================
| NodeName | IpAddress |gcware |gcluster |DataState |
---------------------------------------------------------------
| coordinator1 | 192.168.250.250 | OPEN | OPEN |