Greenplum-cc-web监控软件安装
来源:互联网 发布:java就业信息管理系统 编辑:程序博客网 时间:2024/06/08 07:56
一环境列表
操作系统 centos6.5 64
Greenplum版本: greenplum-db-4.3.5.3-build-2-RHEL5-x86_64.tar
Greenplum集群环境搭建:参考http://blog.csdn.net/sunziyue/article/details/49026913
需求:在已经搭建的集群环境中安装Greenplum-cc-web
二操作步骤
1集群环境启动状态(在GreenplumMaster节点操作)
启动集群:
[gpadmin@master~]$su - gpadmin
[gpadmin@master~]$source/usr/local/greenplum-db/greenplum_path.sh
[gpadmin@master~]$exportMASTER_DATA_DIRECTORY=/gpmaster/gpseg-1
[gpadmin@master~]$gpstart
[gpadmin@master~]$gpstate
2运行gpperfmon_install命令
[gpadmin@master~]$gpperfmon_install --enable --password 123456 --port 5432
[gpadmin@master1 ~]$ gpperfmon_install --enable --password 123456 --port 5432
20160302:19:02:21:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 psql -f /usr/local/greenplum-db/./lib/gpperfmon/gpperfmon3.sql template1 >& /dev/null
20160302:19:02:29:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 psql -f /usr/local/greenplum-db/./lib/gpperfmon/gpperfmon4.sql gpperfmon >& /dev/null
20160302:19:02:29:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 psql -f /usr/local/greenplum-db/./lib/gpperfmon/gpperfmon41.sql gpperfmon >& /dev/null
20160302:19:02:32:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 psql -f /usr/local/greenplum-db/./lib/gpperfmon/gpperfmon42.sql gpperfmon >& /dev/null
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 psql -f /usr/local/greenplum-db/./lib/gpperfmon/gpperfmonC.sql template1 >& /dev/null
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 psql template1 -c "DROP ROLE IF EXISTS gpmon" >& /dev/null
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 psql template1 -c "CREATE ROLE gpmon WITH SUPERUSER CREATEDB LOGIN ENCRYPTED PASSWORD '123456'" >& /dev/null
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-echo "local gpperfmon gpmon md5" >> /gpmaster/gpseg-1/pg_hba.conf
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-echo "host all gpmon 127.0.0.1/28 md5" >> /gpmaster/gpseg-1/pg_hba.conf
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-touch /home/gpadmin/.pgpass >& /dev/null
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-mv -f /home/gpadmin/.pgpass /home/gpadmin/.pgpass.1456974141 >& /dev/null
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-echo "*:5432:gpperfmon:gpmon:123456" >> /home/gpadmin/.pgpass
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-cat /home/gpadmin/.pgpass.1456974141 >> /home/gpadmin/.pgpass
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-chmod 0600 /home/gpadmin/.pgpass >& /dev/null
20160302:19:02:34:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gp_enable_gpperfmon -v on >& /dev/null
20160302:19:02:42:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gpperfmon_port -v 8888 >& /dev/null
20160302:19:02:48:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gp_external_enable_exec -v on --masteronly >& /dev/null
20160302:19:02:54:002810 gpperfmon_install:master1:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c gpperfmon_log_alert_level -v warning >& /dev/null
20160302:19:02:59:002810 gpperfmon_install:master1:gpadmin-[INFO]:-gpperfmon will be enabled after a full restart of GPDB
gpperfmon_install 做以下工作:
创建greenplum监控用数据库(gpperfmon)
创建greenplum监控用数据库角色(gpmon),后面登陆网页时使用
配置greenplum数据库文件(pg_hba.conf和.pgpass)
设置postgresql.conf文件,增加启用监控相关的参数。
3重启greenplum数据库
[gpadmin@master~]$ gpstop -r
[gpadmin@master~]$ ps -ef |grep gpmmon |grep -v grep
4查看数据收集是否正常
[gpadmin@master~]$psql -d gpperfmon -c 'SELECT * FROM system_now;'
如果有Standby Master节点
配置Greenplum Standby Master节点:
在primarymaster上面执行:
1) 将primary master上面的$MASTER_DATA_DIRECTORY/pg_hba.conf拷贝到standby master的$MASTER_DATA_DIRECTORY/pg_hba.conf
[gpadmin@master~]$ scp $MASTER_DATA_DIRECTORY/pg_hba.conf
gpadmin@Standby:$MASTER_DATA_DIRECTORY/pg_hba.conf
2) 将primary master上面的~/.pgpass拷贝到standby master的~/.pgpass,并且文件权限修改为0600
[gpadmin@master~]$ scp ~/.pgpass gpadmin@Standby:~/.pgpass
[gpadmin@master~]$ ssh gpadmin@ Standby -C "chmod 0600 ~/.pgpass"
5安装GreenplumCommand Center Console
(1)下载greenplum-cc-web安装程序:greenplum-cc-web-1.3.0.2-build-14-RHEL5-x86_64 .zip
解压至/home/gpadmin/,执行 ./greenplum-cc-web-1.3.0.2-build-14-RHEL5-x86_64.bin
********************************************************************************
Do you accept the Pivotal Greenplum Database end user license
agreement? [yes | no]
********************************************************************************
yes
********************************************************************************
Provide the installation path for Greenplum Command Center or
press ENTER to accept the default installation path:
/usr/local/greenplum-cc-web-1.3.0.2-build-14
********************************************************************************
/home/gpadmin/greenplum-cc-web-1.3.0.2-build-14
********************************************************************************
Install Greenplum Command Center into </home/gpadmin/greenplum-cc-web-1.3.0.2-build-14>? [yes | no]
********************************************************************************
yes
********************************************************************************
/home/gpadmin/greenplum-cc-web-1.3.0.2-build-14 does not exist.
Create /home/gpadmin/greenplum-cc-web-1.3.0.2-build-14 ? [ yes | no ]
(Selecting no will exit the installer)
********************************************************************************
yes
Extracting product to /home/gpadmin/greenplum-cc-web-1.3.0.2-build-14
********************************************************************************
Installation complete.
Greenplum Command Center is installed in /home/gpadmin/greenplum-cc-web-1.3.0.2-build-14
To complete the environment configuration, please ensure that the
gpcc_path.sh file is sourced.
********************************************************************************
(2) 将primary master的GP监控软件同时安装到到其他任何节点
[gpadmin@master~]$cd /home/gpadmin
[gpadmin@master~]$vi hostname
slave1
slave2
[gpadmin@master~]$source /home/gpadmin/greenplum-cc-web/gpcc_path.sh
[gpadmin@master~]$gpccinstall -f hostname //执行gpccinstall命令安装到其他节点
6设置CenterConsole(primary master节点操作)
(1)gpadmin用户,停止GP数据库
[gpadmin@master~]$gpstop
(2)启动GP数据库
[gpadmin@master~]source/usr/local/greenplum-db/greenplum_path.sh
[gpadmin@master~]exportMASTER_DATA_DIRECTORY=/gpmaster/gpseg-1
[gpadmin@master~]source /home/gpadmin/greenplum-cc-web/gpcc_path.sh
[gpadmin@master~]gpstart
(3)GP数据库实例起来后,用gpcmdr --setup命令设置Command Center Console:
[gpadmin@master~]gpcmdr --setup
Please enter a new instance name:
> gpminsrtest //gp监控实例名,用于启停监控时指定
The web component of the Greenplum Command Center can connect to a
monitor database on a remote Greenplum Database.
Is the master host for the Greenplum Database remote? Yy|Nn (default=N):
> n //监控节点是否和GP master同节点,N指同节点
The display name is shown in the web interface and does not need to be
a hostname.
What would you like to use for the display name for this instance:
> srtest //GP监控页面显示的名字
What port does the Greenplum Database use? (default=5432):
> 5432
Creating instance schema in GPDB. Please wait ...
The Greenplum Command Center 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.
What port would you like the web server to use for this instance? (default=28080):
> 28080 //访问端口
Users logging in to the Command Center must provide database user
credentials. In order to protect user names and passwords, it is recommended
that SSL be enabled.
Do you want to enable SSL for the Web API Yy|Nn (default=N):
> n
Do you want to enable ipV6 for the Web API Yy|Nn (default=N):
> n
Do you want to enable Cross Site Request Forgery Protection for the Web API Yy|Nn (default=N):
> n
Do you want to copy the instance to a standby master host Yy|Nn (default=Y):
> n
Done writing lighttpd configuration to /home/gpadmin/greenplum-cc-web/./instances/gpminsrtest/conf/lighttpd.conf
Done writing web UI configuration to /home/gpadmin/greenplum-cc-web/./instances/gpminsrtest/conf/gpperfmonui.conf
Done writing web UI clustrs configuration to /home/gpadmin/greenplum-cc-web/./instances/gpminsrtest/conf/clusters.conf
Greenplum Command Center UI configuration is now complete. If
at a later date you want to change certain parameters, you can
either re-run 'gpcmdr --setup' or edit the configuration file
located at /home/gpadmin/greenplum-cc-web/./instances/gpminsrtest/conf/gpperfmonui.conf.
The web UI for this instance is available at http://master1:28080/
You can now start the web UI for this instance by running: gpcmdr --start gpminsrtest
No instances
(4)启动GP监控
[gpadmin@master~]gpcmdr --start gpminsrtest
Starting instance gpminsrtest...
Greenplum Command Center UI for instance 'gpminsrtest' - [RUNNING on PORT: 28080]
[gpadmin@master~]lsof -i :28080 //查看端口状态
7使用浏览器访问http://master1:28080
用户名密码:gpmon/123456
- 安装Greenplum-cc-web监控软件
- Greenplum-cc-web监控软件安装
- 安装Greenplum-perfmon-web监控软件
- Centos6系统安装gpperfmon-cc-web监控
- Centos6系统安装gpperfmon-cc-web监控
- Greenplum学习5--安装iptraf流量监控软件
- kafka web console监控软件的安装
- GreenPlum安装性能监控工具GPCCC(Greenplum Command Center Console)
- Monit监控软件安装
- 监控GreenPlum Segment磁盘空间
- Greenplum安装
- GreenPlum安装
- greenplum安装
- Greenplum 安装
- mycat web监控安装
- MySQL监控软件mytop安装
- Zabbix 监控软件简单安装
- Zabbix 监控软件简单安装
- 排序算法比较
- 中医养生口诀
- openssl 版本号区别
- defineProtocol 使用文档
- Inversion of Control(控制反转)之 Dependency Injection(依赖注入)
- Greenplum-cc-web监控软件安装
- iOS关闭键盘的五种方法(总结的很好的博文)
- SQL Server 2008 数据库同步
- 苹果个人开发者账号如何升级成公司账号
- input propertychange事件,当input的value值发生改变时触发(文本框的值即时搜索)
- 深入浅出的讲解c++多态性
- iOS单例创建
- 虚拟路由器冗余协议【原理篇】VRRP详解
- oracle索引分类及大表分页查询优化(四)