install greenplum monitor

时间：2010-08-07 来源：zhangzhu1984

安装greenplum的监控一）前期准备 1）创建gpmon角色 create role gpmon with superuser createdb login encrypted password 'gpmon'; 2）编辑master节点的pg_hba.conf文件。 8月6日配置的pg_hba.conf文件 local    all         gpadmin         ident
host     all         gpadmin         127.0.0.1/32    trust
host     all         gpadmin         10.25.115.16/32       trust
host     all         gpadmin         10.25.115.8/32       trust
host      gpperfmon     gpmon          127.0.0.1/24    md5
local     gpperfmon     gpmon          md5 贴出segment的pg_hba.conf文件
# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust
host all all 10.25.115.16/32 trust
host all all 10.25.115.14/32 trust
host all all 10.25.115.17/32 trust
host all all 10.25.115.8/32 trust
host all all 192.168.122.1/32 trust 3）重新加载配置文件 gpstop -u 4）设置监控postgresql.conf参数添加如下内容 #--------------------------------
# GPPERFMON OPTIONS
#--------------------------------
gp_enable_gpperfmon=on
gpperfmon_port=8888 去掉已有参数的注释 #gp_external_enable_exec = on 的# gp_external_enable_exec = on 5）重新加载配置文件，让其生效 gpstop -u 二）开始安装 1）在master安装 2）在segment安装 3）配置Greenplum Performance Monitor Database 1）在master安装

解压
执行 ./greenplum-perfmon-2.0.0.3-RHEL5-x86_64.bin
修改目录权限 chown -R gpadmin /usr/local/greenplum-perfmon-2.0.0.3
加载 source /usr/local/greenplum-perfmon-2.0.0.3/gpperfmon_path.sh
将/usr/local/greenplum-perfmon-2.0.0.3/gpperfmon_path.sh 内容保持到 /etc/profile

2）在segment安装

在主节点压缩包 tar -cvf /usr/local/perfmon.tar /usr/local/greenplum-perfmon-2.0.0.3
将压缩包传输到各节点 gpscp -f /home/gpadmin/seg_hosts /usr/local/perfmon.tar =:/usr/local/
登陆各节点 gpssh -f /home/gpadmin/seg_hosts
解压
设置权限 chown -R gpadmin /usr/local/greenplum-perfmon-2.0.0.3
chgrp -R gpadmin /usr/local/greenplum-perfmon-2.0.0.3

3）配置Greenplum Performance Monitor Database

设置目录参数 chown -R gpadmin:gpadmin /dbfast1/gp-1//gpperfmon
PGPASSWORD='password1234' PGPORT='6432' gpperfmon --setup 我没有使用ssl，端口我改为8888

The quantum value specifies the time in seconds between updates from
performance monitor agents on all segments.
Quantum (between 10 and 60 seconds). [15]: The minimum query run time specifies the cutoff time for queries to log.
Only queries with a run time greater than this value will be logged in
the queries_history table.
Minimum query run time (seconds) [60]: The minimum detailed query run time specifies the cutoff time for queries
to log detailed iterator metrics. Only queries with a run time greater
than this value will have their detailed metrics logged in the
iterators_history table.
Minimum detailed query run time (seconds) [60]: Log file location [/home/gpadmin/gpmaster/gp-1/gpperfmon/logs]:
------------------------
Web Server Configuration
------------------------ gpperfmon runs a small web server for the UI and web API. This web
server by default runs on port 28080, but you may specify any available port.
Web server port [28080]:8888 Do you want to enable SSL for the Web API (Y/N) [Y]:n Done writing lighttpd configuration to /home/gpadmin/gpmaster/gp-1/gpperfmon/conf/lighttpd.conf
Done writing gpperfmon configuration to /home/gpadmin/gpmaster/gp-1/gpperfmon/conf/gpperfmon.conf Greenplum Performance Monitor configuration is now complete. If
at a later date you want to change certain parameters, you can
either re-run 'gpperfmon --setup' or edit the configuration file
located at /home/gpadmin/gpmaster/gp-1/gpperfmon/conf/gpperfmon.conf. You can start monitoring this Greenplum Database instance by running
'gpperfmon --start'.
The web based UI is available at http://vm16:8888/

PGPASSWORD='password1234' PGPORT='6432' gpperfmon --restart 非5432 标准端口，需要加port参数的以gpmon用户执行需要 /dbfast1 目录有对gpmon用户有权限

4）使用浏览器登录 http://10.25.115.16:8888/ 登录使用的用户名为： gpmon
密码是：
PGPASSWORD='password1234' PGPORT='6432' gpperfmon --setup 的初始化的密码登录界面; 登陆后的界面：系统汇总信息系统统计信息查询监控