1.F:\guass300(集群成功)
60gb 变成了90gb
2.admin/Admin@123
查看状态
3.gs_om -t status --detail 查看状态
[omm@GaussDB200 roo]$ source ${BIGDATA_HOME}/mppdb/.mppdbgs_profile
[omm@GaussDB200 roo]$
[omm@GaussDB200 roo]$ gs_om -t status --detail
[ CMServer State ]
node node_ip instance state
---------------------------------------------------------------------------------
1 GaussDB200 192.168.211.144 1 /opt/GaussDB200/app/mppdb/cm/cm_server Primary
[ Cluster State ]
cluster_state : Normal
redistributing : No
balanced : Yes
[ Coordinator State ]
node node_ip instance state
---------------------------------------------------------------------------------------
1 GaussDB200 192.168.211.144 5001 /opt/GaussDB200/data/mppdb/data1/coordinator Normal
[ Central Coordinator State ]
node node_ip instance state
---------------------------------------------------------------------------------------
1 GaussDB200 192.168.211.144 5001 /opt/GaussDB200/data/mppdb/data1/coordinator Normal
[ GTM State ]
node node_ip instance state
---------------------------------------------------------------------------
1 GaussDB200 192.168.211.144 1001 /opt/GaussDB200/app/mppdb/gtm P Primary
[ Datanode State ]
node node_ip instance state
---------------------------------------------------------------------------------------
1 GaussDB200 192.168.211.144 6001 /srv/BigData/mppdb/data1/master1 P Primary Normal
1 GaussDB200 192.168.211.144 6002 /srv/BigData/mppdb/data1/master2 P Primary Normal
1 GaussDB200 192.168.211.144 6003 /srv/BigData/mppdb/data1/master3 P Primary Normal
1 GaussDB200 192.168.211.144 6004 /srv/BigData/mppdb/data1/master4 P Primary Normal
1 GaussDB200 192.168.211.144 6005 /srv/BigData/mppdb/data1/master5 P Primary Normal
1 GaussDB200 192.168.211.144 6006 /srv/BigData/mppdb/data1/master6 P Primary Normal
[omm@GaussDB200 roo]$
4.查看主节点的进程
[omm@GaussDB200 roo]$ ps -ef | grep cm_server ## 查询主CM Server的进程
omm 19972 1 4 12:59 ? 00:01:05 /opt/GaussDB200/app/mppdb/core/bin/cm_server
omm 64737 22064 0 13:25 pts/0 00:00:00 grep --color=auto cm_server
[omm@GaussDB200 roo]$
5.内存尽量控制在35gb 因为物理内存只有36gb
6.
[omm@GaussDB200 roo]$ gsql -d postgres -p 25308
gsql ((GaussDB Kernel V300R002C00 build 8a9c1eb6) compiled at 2019-08-01 18:47:38 commit 6093 last mr 10175 )
NOTICE : The password has been expired, please change the password.
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
postgres=#
7.
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------
PostgreSQL 9.2.4 (GaussDB Kernel V300R002C00 build 8a9c1eb6) compiled at 2019-08-01 18:47:38 commit 6093
last mr 10175 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 5.4.0, 64-bit
(1 row)
postgres=#
参考
gaussdb200 实操 | 海汼部落 高品质的 大数据技术社区
参考2