greenplum-cc-web4.0监控安装-白红宇

greenplum-cc-web4.0监控安装

阅读量：2239 次

发布时间：2019-05-09

本文共 2273 字，大约阅读时间需要 7 分钟。

简介：

本文是基于greenplum5.7，greenplum-cc-web4.0安装的。

一、安装greenplum监控的数据库以及创建用户（在gpadmin用户下安装）

1、开启greenplum数据库

[gpadmin@master ~]$ gpstart -a

2、安装gpperfmon数据库，以及为gpmon用户创建密码，端口是greenplum配置的端口

[gpadmin@master ~]$ gpperfmon_install --enable --password gpmon --port 2345

3、重启数据库

[gpadmin@master ~]$ gpstop -M fast -a[gpadmin@master ~]$ gpstart -a

4、检查gp监控是否启动

[gpadmin@master ~]$ ps -ef | grep gpmmon

5、检查gp监控是否监测到greenplum集群中的每台主机

[gpadmin@master ~]$ psql -d 'gpperfmon' -c 'select * from system_now;'

二、正式安装greenplum-cc-web（在gpadmin用户下安装）

1、创建安装目录

[gpadmin@master ~]$ gpssh -f /home/gpadmin/conf/hostlist=> cd /data/greenplum-db  [master1][slave1][slave2][slave3]=> mkdir greenplum-cc-web[master1][slave1][slave2][slave3]=> exit

2、解压，安装

[gpadmin@master ~]$ unzip greenplum-cc-web-4.0.0-LINUX-x86_64.zip[gpadmin@master ~]$ cd greenplum-cc-web-4.0.0-LINUX-x86_64[gpadmin@master greenplum-cc-web-4.0.0-LINUX-x86_64]$ ./gpccinstall-4.0.0 #一直空格I HAVE READ AND AGREE TO THE TERMS OF THE ABOVE PIVOTAL GREENPLUM DATABASEEND USER LICENSE AGREEMENT.Do you agree to the Pivotal Greenplum Command Center End User License Agreement? Yy/Nn (Default=Y)         Where would you like to install Greenplum Command Center? (Default=/usr/local)/opt/greenplum/greenplum-cc-webWhat would you like to name this installation of Greenplum Command Center? (Default=gpcc)What port would you like gpcc webserver to use? (Default=28080)Would you like to enable kerberos? Yy/Nn (Default=N)Would you like enable SSL? Yy/Nn (Default=N)Installation in progress...Successfully installed Greenplum Command Center.We recommend ssh to standby master before starting GPCC webserverTo start the GPCC webserver on the current host, run gpcc start

3、修改环境变量（所有机器）

[gpadmin@master ~]$ vi .bash_profile#添加source /opt/greenplum/greenplum-cc-web/greenplum-cc-web-4.0.0/gpcc_path.sh[gpadmin@master ~]$ source .bash_profile

4、修改pg_hba.conf文件连接

[gpadmin@master ~]$ vi /data/greenplum-db/gpdata/gpmaster/gpseg-1/pg_hba.conf #在最后一行添加这句host     all         gpmon         （本机的ip）/24     md5[gpadmin@master ~]$ gpstop -M fast -a  [gpadmin@master ~]$ gpstart -a[gpadmin@master ~]$ gpcc start