# greenplum的监控配置 gpcc 标签（空格分隔）： greenplum系列 --- [toc] ---- ## 一： 关于gpcc的介绍 ``` Pivotal Greenplum Command Center6.3 (gpcc 监控平台) 安装GP监控的数据库和用户等信息 执行Greenplum DB数据库的gpperfmon_install工具,完成GP监控软件安装的前期准备工作 gpperfmon_install工具的功能大致是： 创建greenplum监控用数据库(gpperfmon) 创建greenplum监控用数据库角色(gpmon) 配置greenplum数据库接受来自perfmon监控的链接文件(pg_hba.conf和.pgpass) 设置postgresql.conf文件，增加启用监控的参数。（这些参数默认会添加在文件的末尾） 下载地址： https://network.pivotal.io/products/pivotal-gpdb/ greenplum-cc-web-6.5.0-gp6-rhel7-x86_64.zip ``` ![image_1f9ftglrsv4l1j3sbfr1ok97vhp.png-240.5kB][1] ## 二：gpcc的部署： ``` su - gpadmin gpperfmon_install --enable --password gpmon --port 5432 ``` ![image_1f9ftptmf1lf8142rqj0or5s5a16.png-364.8kB][2] ``` 主要修改了如下东西： ``` ![image_1f9ftroa11ii317jf19am7oq0d20.png-170.1kB][3] ``` 配置文件 /greenplum/gpdata/master/gpseg-1/postgresql.conf 访问权限 /greenplum/gpdata/master/gpseg-1/pg_hba.conf ``` ![image_1f9ftvvb11tn6j0vspv1l022nu2d.png-52.1kB][4] ![image_1f9fu0ol21igmidkoav1p8ooc72q.png-157kB][5] ``` /greenplum/gpdata/master/gpseg-1/gpperfmon/conf/ 生成一个配置文件 gpperfmon.conf /greenplum/gpdata/master/gpseg-1/gpperfmon/logs 日志路径 ``` ![image_1f9fu8c961avc1djd19kf90g35j37.png-243.2kB][6] ``` 当master 挂掉之后启用 standby 的时候涉及同步问题 cd /greenplum/gpdata/master/gpseg-1 scp pg_hba.conf gpadmin@192.168.100.12:/greenplum/gpdata/master/gpseg-1/ scp ~/.pgpass gpadmin@192.168.100.12:~/ ``` ![image_1f9fuels418h3jjp1uko16aj7o93k.png-84.1kB][7] ``` 下面安装 greenplum-cc-web 配置 使用gpadmin用户安装 unzip greenplum-cc-web-6.5.0-gp6-rhel7-x86_64.zip cd greenplum-cc-web-6.5.0-gp6-rhel7-x86_64 ./gpccinstall-6.5.0 ``` ![image_1f9fuga061evd1mv9pug1vid1dgi41.png-72.2kB][8] ![image_1f9fulg8q8qf1tc01j93g811cqc4e.png-172.2kB][9] ![image_1f9fumabjmon18ir14nrscvep4r.png-160kB][10] ``` 将 gpcc_path.sh 写入 环境变量当中 vim .bash_profile ---- source /greenplum/greenplum-cc-6.5.0/gpcc_path.sh ---- vim .bashrc ---- source /greenplum/greenplum-cc-6.5.0/gpcc_path.sh ---- ``` ![image_1f9fuoke719lv1sllf0jh7fjt758.png-92.7kB][11] ![image_1f9fv0943t3n1s5qqvm1qfd1dfm6l.png-143.5kB][12] ![image_1f9fv106v1d6712v11kja1307jn572.png-142.8kB][13] ![image_1f9fv1fppf615egk0n1ef21g937f.png-140kB][14] ``` 重新加载环境变量 （所有机器） source .bashrc source .bash_profile ``` ``` cd /greenplum/gpdata/master/gpseg-1/ vim pg-hba.conf 增加一行授权 host gpperfmon gpmon 192.168.100.11/32 md5 ``` ![image_1f9fv7m9r1k2f193r1jkmf12mri89.png-65.7kB][15] ``` 启动gpcc gpcc start ``` ![image_1f9fv73n82trbm016dp1tm71p1p7s.png-87.1kB][16] ![image_1f9fv8u0fsos149ljh6k11agp8m.png-237.3kB][17] ![image_1f9fva6ddldivn31tcb19l1a9993.png-372.2kB][18] ![image_1f9fvarqhcd21ion1ofm1mg0c4o9g.png-303.8kB][19] ![image_1f9fvc1b11u26dg414g5sbf11ib9t.png-455kB][20] [1]: http://static.zybuluo.com/zhangyy/vp7kngh68lemzvoixdq6gc1c/image_1f9ftglrsv4l1j3sbfr1ok97vhp.png [2]: http://static.zybuluo.com/zhangyy/vc5ra10q2dw4thhrm72obbg9/image_1f9ftptmf1lf8142rqj0or5s5a16.png [3]: http://static.zybuluo.com/zhangyy/qxbp4ynlwk8tkrrdhx7luu19/image_1f9ftroa11ii317jf19am7oq0d20.png [4]: http://static.zybuluo.com/zhangyy/bgho5vmesusgvwtq2i2eg33f/image_1f9ftvvb11tn6j0vspv1l022nu2d.png [5]: http://static.zybuluo.com/zhangyy/knyuxr3rbbmmc4k8hy07bhn6/image_1f9fu0ol21igmidkoav1p8ooc72q.png [6]: http://static.zybuluo.com/zhangyy/hiqky9m9ldbnwdynxjbjryq5/image_1f9fu8c961avc1djd19kf90g35j37.png [7]: http://static.zybuluo.com/zhangyy/pl7oiorjfyiu2wtzj9r43ng6/image_1f9fuels418h3jjp1uko16aj7o93k.png [8]: http://static.zybuluo.com/zhangyy/qm5d88j14r0wyqx8prauzx7r/image_1f9fuga061evd1mv9pug1vid1dgi41.png [9]: http://static.zybuluo.com/zhangyy/sr8yw5yw4k3xbc7xlpjmci39/image_1f9fulg8q8qf1tc01j93g811cqc4e.png [10]: http://static.zybuluo.com/zhangyy/2pew4plse725bc0d9dlrugff/image_1f9fumabjmon18ir14nrscvep4r.png [11]: http://static.zybuluo.com/zhangyy/0fz3qs5n7hklpxrj4mrc37dl/image_1f9fuoke719lv1sllf0jh7fjt758.png [12]: http://static.zybuluo.com/zhangyy/i4l7kqmwyp06u1hnz8zt69gs/image_1f9fv0943t3n1s5qqvm1qfd1dfm6l.png [13]: http://static.zybuluo.com/zhangyy/mqx391w0p70j8sn9r2h2n8du/image_1f9fv106v1d6712v11kja1307jn572.png [14]: http://static.zybuluo.com/zhangyy/ddyjfqrt1awgvbmfymamrvr4/image_1f9fv1fppf615egk0n1ef21g937f.png [15]: http://static.zybuluo.com/zhangyy/mrv6h8bqjqmbiz0v5kdr5ek8/image_1f9fv7m9r1k2f193r1jkmf12mri89.png [16]: http://static.zybuluo.com/zhangyy/zd6bbb539luk7sb2k73qkb65/image_1f9fv73n82trbm016dp1tm71p1p7s.png [17]: http://static.zybuluo.com/zhangyy/7wzxetn30u1sjx01tlvxm5ge/image_1f9fv8u0fsos149ljh6k11agp8m.png [18]: http://static.zybuluo.com/zhangyy/vw7x8ov78ors1v3ac4jyr2kc/image_1f9fva6ddldivn31tcb19l1a9993.png [19]: http://static.zybuluo.com/zhangyy/5tc8jyrcals7l5ojbrnordyh/image_1f9fvarqhcd21ion1ofm1mg0c4o9g.png [20]: http://static.zybuluo.com/zhangyy/dfqwj84zwzsuhi08nmj2ttec/image_1f9fvc1b11u26dg414g5sbf11ib9t.png