GBase数据库——常用命令

针对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 |