简介
GPCC 监控系统性能指标，分析集群健康状况，并使数据库管理员能够在 Greenplum Database 环境中执行管理任务。它提供了一个本地浏览器的 HTML5 图形控制台，用于查看 Greenplum Database 系统指标和执行某些数据库管理任务。
文档
https://docs.vmware.com/en/VMware-Tanzu-Greenplum-Command-Center/index.html
https://docs.vmware.com/en/VMware-Tanzu-Greenplum-Command-Center/6.8/tanzu-greenplum-command-center/GUID-welcome.html
下载地址
https://network.pivotal.io/products/gpdb-command-center
安装
在master库上安装即可，客户端会自动安装到其它segment。
root用户做准备工作(必须)
GreenPlum在运行过程中，修改软件的权限为gpadmin.gpadmin并不会引起GPDB的宕机，可以放心修改。
修改所有节点的gpdb的目录权限为gpadmin，否则后续安装gpcc会报错（例如：IOError、gpadmin-[CRITICAL]:-gppkg failed. (Reason='')、Permission denied等）：
1chown -R gpadmin.gpadmin /usr/local/greenplum-db-6.19.3
2chown -R gpadmin.gpadmin /usr/local/greenplum-db
创建gpcc安装目录：
1sudo mkdir -p /usr/local/greenplum-cc-6.8.3; chown -R gpadmin:gpadmin /usr/local/greenplum-cc-6.8.3
2sudo ln -s /usr/local/greenplum-cc-6.8.3 /usr/local/greenplum-cc
3
4
5-- 或者
6source /usr/local/greenplum-db/greenplum_path.sh
7gpssh -f /home/gpadmin/conf/all_hosts 'sudo mkdir -p /usr/local/greenplum-cc-6.8.3; chown -R gpadmin:gpadmin /usr/local/greenplum-cc-6.8.3'
8gpssh -f /home/gpadmin/conf/all_hosts 'sudo ln -s /usr/local/greenplum-cc-6.8.3 /usr/local/greenplum-cc'
配置结果：
1[root@mdw1 local]# ll
2lrwxrwxrwx 1 gpadmin gpadmin 29 Jan 12 11:13 greenplum-cc -> /usr/local/greenplum-cc-6.8.3
3drwxr-xr-x 12 gpadmin gpadmin 4096 Jan 12 13:40 greenplum-cc-6.8.3
4lrwxrwxrwx 1 gpadmin gpadmin 30 Dec 26 18:48 greenplum-db -> /usr/local/greenplum-db-6.19.3
5drwxr-xr-x 12 gpadmin gpadmin 4096 Dec 6 12:27 greenplum-db-6.19.3
开始安装
交互式安装
1su - gpadmin
2source /usr/local/greenplum-db/greenplum_path.sh
3unzip greenplum-cc-web-6.8.3-gp6-rhel7-x86_64.zip
4cd greenplum-cc-web-6.8.3-gp6-rhel7-x86_64/
5./gpccinstall-6.8.3 -W
安装过程：
1[gpadmin@mdw1 greenplum-cc-web-6.8.3-gp6-rhel7-x86_64]$ ./gpccinstall-6.8.3 -W
2Password for GPDB user gpmon:
3Where would you like to install Greenplum Command Center? (Default=/usr/local)
4
5Greenplum Command Center will be installed in /usr/local/greenplum-cc-6.8.3
6
7What would you like to name this installation of Greenplum Command Center? (Default=gpcc)
8
9
10What port would you like the gpcc webserver to use? (Default=28080)
11
12
13Would you like to enable SSL/TLS? Yy/Nn (Default=Y)
14n
15
16********************************************************************************
17* WARNING: Your connections to GPCC will be insecure. *
18********************************************************************************
19
20Please choose a display language (Default=English)
211. English
222. Chinese
233. Korean
244. Russian
255. Japanese
262
27
28Could not detect [metrics_collector] in shared_preload_libraries
29Please add it to enable GPCC metrics collection
30
31Would you like to continue with gpcc installation? Yy/Nn (Default=N)
32y
33
34INSTALLATION IN PROGRESS...
35
36********************************************************************************
37* *
38* INSTALLATION IS ALMOST COMPLETED *
39* *
40* The last step is to update the metrics_collector extension, which needs to *
41* restart the Greenplum Database cluster. Please proceed to $GPCC_HOME and *
42* follow the instructions in this file: *
43* *
44* update-extension.txt *
45* *
46* Some new features may not be available before the update is done. *
47* *
48* To use GPCC with the old metrics_collector extension, source gpcc_path.sh *
49* and run 'gpcc start'. *
50* *
51********************************************************************************
静默安装
1su - gpadmin
2source /usr/local/greenplum-db/greenplum_path.sh
3unzip greenplum-cc-web-6.8.3-gp6-rhel7-x86_64.zip
4cd greenplum-cc-web-6.8.3-gp6-rhel7-x86_64/
5
6
7
8cat > /tmp/gpcc_install.conf <<"EOF"
9path = /usr/local
10# Set the display_name param to the string to display in the GPCC UI.
11# The default is "gpcc"
12# display_name = gpcc
13
14master_port = 5432
15web_port = 28080
16rpc_port = 8899
17enable_ssl = false
18# Uncomment and set the ssl_cert_file if you set enable_ssl to true.
19# ssl_cert_file = /etc/certs/mycert
20enable_kerberos = false
21# Uncomment and set the following parameters if you set enable_kerberos to true.
22# webserver_url = <webserver_service_url>
23# krb_mode = 1
24# keytab = <path_to_keytab>
25# krb_service_name = postgres
26# User interface language: 1=English, 2=Chinese, 3=Korean, 4=Russian, 5=Japanese
27language = 2
28EOF
29
30
31./gpccinstall-6.8.3 -c /tmp/gpcc_install.conf
升级extension metrics_collector（必须）
1echo 'source /usr/local/greenplum-cc/gpcc_path.sh' >> ~/.bashrc
2
3source /usr/local/greenplum-cc/gpcc_path.sh
4cd $GPCC_HOME
5cat update-extension.txt
需要做如下的操作：
11. cd /usr/local/greenplum-cc-6.8.3/gppkg
22. Stop GPCC: gpcc stop
33. Drop extension: psql gpperfmon -c 'drop extension metrics_collector'
44. Use "gppkg -q --all" to list packages installed.
55. Remove the old version of the metrics_collector: "gppkg -r <name>-<version>"
66. Install the new version: gppkg -i MetricsCollector-6.8.3_gp_6.19.3-<OS>-<ARCH>.gppkg
77. Restart GPDB
88. Restart GPCC: gpcc start
注意：首次安装只需要执行如下的步骤：
1cd /usr/local/greenplum-cc-6.8.3/gppkg
2gppkg -i MetricsCollector-6.8.3_gp_6.19.3-rhel7-x86_64.gppkg
3gpstop -M fast ; gpstart -a
4gpcc start ; gpcc status
执行过程：
1[gpadmin@mdw1 gppkg]$ gppkg -q --all
220230116:14:58:27:011689 gppkg:mdw1:gpadmin-[INFO]:-Starting gppkg with args: -q --all
3[gpadmin@mdw1 gppkg]$ gppkg -q --all
420230116:14:58:36:011710 gppkg:mdw1:gpadmin-[INFO]:-Starting gppkg with args: -q --all
5[gpadmin@mdw1 gppkg]$ gppkg -i MetricsCollector-6.8.3_gp_6.19.3-rhel7-x86_64.gppkg
620230116:14:59:19:011861 gppkg:mdw1:gpadmin-[INFO]:-Starting gppkg with args: -i MetricsCollector-6.8.3_gp_6.19.3-rhel7-x86_64.gppkg
720230116:14:59:19:011861 gppkg:mdw1:gpadmin-[INFO]:-Installing package MetricsCollector-6.8.3_gp_6.19.3-rhel7-x86_64.gppkg
820230116:14:59:19:011861 gppkg:mdw1:gpadmin-[INFO]:-Validating rpm installation cmdStr='rpm --test -i /usr/local/greenplum-db-6.19.3/.tmp/MetricsCollector-6.8.3-6.19.3.x86_64.rpm --dbpath /usr/local/greenplum-db-6.19.3/share/packages/database --prefix /usr/local/greenplum-db-6.19.3'
920230116:14:59:21:011861 gppkg:mdw1:gpadmin-[INFO]:-Installing MetricsCollector-6.8.3_gp_6.19.3-rhel7-x86_64.gppkg locally
1020230116:14:59:21:011861 gppkg:mdw1:gpadmin-[INFO]:-Validating rpm installation cmdStr='rpm --test -i /usr/local/greenplum-db-6.19.3/.tmp/MetricsCollector-6.8.3-6.19.3.x86_64.rpm --dbpath /usr/local/greenplum-db-6.19.3/share/packages/database --prefix /usr/local/greenplum-db-6.19.3'
1120230116:14:59:21:011861 gppkg:mdw1:gpadmin-[INFO]:-Installing rpms cmdStr='rpm -i --force /usr/local/greenplum-db-6.19.3/.tmp/MetricsCollector-6.8.3-6.19.3.x86_64.rpm --dbpath /usr/local/greenplum-db-6.19.3/share/packages/database --prefix=/usr/local/greenplum-db-6.19.3'
1220230116:14:59:22:011861 gppkg:mdw1:gpadmin-[INFO]:-Completed local installation of MetricsCollector-6.8.3_gp_6.19.3-rhel7-x86_64.gppkg.
1320230116:14:59:22:011861 gppkg:mdw1:gpadmin-[INFO]:--
14==========================================================================
15Metrics Collector installation is complete!
16==========================================================================
1720230116:14:59:22:011861 gppkg:mdw1:gpadmin-[INFO]:-MetricsCollector-6.8.3_gp_6.19.3-rhel7-x86_64.gppkg successfully installed.
18[gpadmin@mdw1 gppkg]$
19[gpadmin@mdw1 gppkg]$ gppkg -q --all
2020230116:14:59:31:011951 gppkg:mdw1:gpadmin-[INFO]:-Starting gppkg with args: -q --all
21MetricsCollector-6.8.3_gp_6.19.3
若是GPCC安装成功，则会在如下位置有库文件，否则不能随便重启GreenPlum，会导致启动失败：
1[root@mdw1 /]# find /usr/local -name metrics_collector*
2/usr/local/greenplum-db-6.19.3/share/postgresql/extension/metrics_collector--1.0.sql
3/usr/local/greenplum-db-6.19.3/share/postgresql/extension/metrics_collector.control
4/usr/local/greenplum-db-6.19.3/lib/postgresql/metrics_collector.so
5[root@mdw1 /]#
6[gpadmin@mdw1 ~]$ ll $GPHOME/share/postgresql/extension/gp_wlm*
7-rw-r--r-- 1 gpadmin gpadmin 856 Dec 6 12:27 /usr/local/greenplum-db-6.19.3/share/postgresql/extension/gp_wlm--0.1.sql
8-rw-r--r-- 1 gpadmin gpadmin 232 Dec 6 12:27 /usr/local/greenplum-db-6.19.3/share/postgresql/extension/gp_wlm.control
9[gpadmin@mdw1 ~]$ ll $GPHOME/share/postgresql/extension/metrics_collector*
10-rw-r--r-- 1 gpadmin gpadmin 846 Dec 6 12:27 /usr/local/greenplum-db-6.19.3/share/postgresql/extension/metrics_collector--1.0.sql
11-rw-r--r-- 1 gpadmin gpadmin 233 Dec 6 12:27 /usr/local/greenplum-db-6.19.3/share/postgresql/extension/metrics_collector.control
12[gpadmin@mdw1 ~]$ ll $GPHOME/lib/postgresql/metrics_collector.so
13-rwxr-xr-x 1 gpadmin gpadmin 3357064 Dec 6 12:27 /usr/local/greenplum-db-6.19.3/lib/postgresql/metrics_collector.so
14[gpadmin@mdw1 ~]$
15[gpadmin@mdw1 ~]$ gppkg -q --all
1620230116:14:58:39:020317 gppkg:mdw1:gpadmin-[INFO]:-Starting gppkg with args: -q --all
17MetricsCollector-6.8.3_gp_6.19.3
安装日志
日志：/usr/local/greenplum-cc-6.8.3/logs
登陆
登陆：http://172.72.6.40:28080
gpmon/lhr
1-- 一般不需要修改
2vi $MASTER_DATA_DIRECTORY/pg_hba.conf
修改用户名和密码：
1echo '*:5432:gpperfmon:gpmon:lhr' > ~/.pgpass
2chmod 600 /home/gpadmin/.pgpass
3
4
5psql -d gpperfmon
6alter user gpmon with password 'lhr';
报错解决
报错：libgssapi_krb5.so: cannot open shared object file: No such file or directory
1[newgp@mdw greenplum-cc-web-6.8.3-gp6-rhel7-x86_64]$ ./gpccinstall-6.8.3 -W
2Failed to connect to database postgres on 152.130.210.107:5432 as newgp: libgssapi_krb5.so: cannot open shared object file: No such file or directory
分析，查看是否有如下的文件：
1ll /usr/lib64/libgssapi_krb5.so
若没有，则需要安装如下的rpm包：
1yum install krb5-libs krb5-devel
Metrics_collector还没有添加到共享预加载库(shared_preload_libraries)中。请添加它以启用指标收集。
在安装完成后，查询监视器报如下的错误：
Metrics_collector还没有添加到共享预加载库(shared_preload_libraries)中。请添加它以启用指标收集。
必须打开GUC gp_enable_query_metrics来启用指标收集。
修复命令如下所示，在master节点执行：
1gpconfig -c shared_preload_libraries -v metrics_collector
2gpconfig -c gp_enable_query_metrics -v on
3gpconfig -c track_activities -v on
4
5gpconfig -s shared_preload_libraries
6gpconfig -s gp_enable_query_metrics
7gpconfig -s track_activities
8
9gpstop -M fast ; gpstart -a
10gpcc stop ; gpcc start ; gpcc status
在重启GreenPlum后，结果如下才可以：
1[gpadmin@mdw1 gpmetrics]$ gpconfig -s shared_preload_libraries
2gpconfig -s gp_enable_query_metrics
3Values on all segments are consistent
4GUC : shared_preload_libraries
5Master value: metrics_collector
6Segment value: metrics_collector
7[gpadmin@mdw1 gpmetrics]$ gpconfig -s gp_enable_query_metrics
8Values on all segments are consistent
9GUC : gp_enable_query_metrics
10Master value: on
11Segment value: on
12[gpadmin@mdw1 gpmetrics]$ gpconfig -s track_activities
13Values on all segments are consistent
14GUC : track_activities
15Master value: on
16Segment value: on
17[gpadmin@mdw1 gpmetrics]$
注意：该步一定要注意，如果配置不正确，会导致GreenPlum这个不能启动，修复起来比较麻烦。
卸载GPCC
参考：https://docs.vmware.com/en/VMware-Tanzu-Greenplum-Command-Center/6.8/tanzu-greenplum-command-center/GUID-topics-setup-uninstall.html
1gpcc --stop
2rm /usr/local/greenplum-cc ## removes the symbolic link
3rm -rf /usr/local/greenplum-cc-version
4
5
6gpconfig -c gp_enable_gpperfmon -v off
7
8
9rm -rf $MASTER_DATA_DIRECTORY/gpperfmon/data/*
10rm -rf $MASTER_DATA_DIRECTORY/gpperfmon/logs/*
11
12
13psql template1 -c 'DROP ROLE gpmon;'
14dropdb gpperfmon
15
若是重新安装相同版本，则不用卸载之前已经安装过的软件。
修改界面为中文
没有直接修改的地方，只能重新安装，重新安装的时候选择中文即可，重新安装之前不需要卸载之前的版本：
1su - gpadmin
2source /usr/local/greenplum-db/greenplum_path.sh
3unzip greenplum-cc-web-6.8.3-gp6-rhel7-x86_64.zip
4cd greenplum-cc-web-6.8.3-gp6-rhel7-x86_64/
5./gpccinstall-6.8.3 -W
总结
1、权限一定要对，否则安装会报错
2、安装分为交互式安装和静默安装
3、一定要检验gpcc是否真的安装成功了。
4、GreenPlum在运行过程中，修改软件的权限为gpadmin.gpadmin并不会引起GPDB的宕机，可以放心修改。
参考
https://blog.csdn.net/weixin_39168541/article/details/122688329
文章转载自DB宝，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
