Greenplum监控工具:GreenplumCCweb 安装使用

2023年 8月 12日 37.8k 0

文章目录概述下载安装前准备安装gpperfmon数据库,以及为gpmon用户创建密码重启数据库检查是否成功启动安装gpcc生成安装目录赋予权限分发安装包到所有的子节点初始化gpcc登录到web界面概述greenplum的一个web界面的监控系统。可以监控数据库的一些状态,节点信息

下载下载greenplum cc的方法有限,我的途径是通过https://network.pivotal.io/products/pivotal-gpdb这个网站,可以下载对应版本的grennplum cc。ps:需要相应的账号

安装前准备安装gpperfmon数据库,以及为gpmon用户创建密码gpperfmon_install --enable --password 123456 --port 5432

这个命令是在greenplum安装完成的时候就已经有的,如果是编译安装,编译的时候一定要加–enable-gpperfmon这个参数,才能保证有这个命令。功能大致是: 创建greenplum监控用数据库(gpperfmon) 创建greenplum监控用数据库角色(gpmon) 配置greenplum数据库接受来自perfmon监控的链接文件(pg_hba.conf和.pgpass) 设置postgresql.conf文件,增加启用监控的参数。(这些参数默认会添加在文件的末尾) 设置pg_hba.conf文件,增加如下信息:

local gpperfmon gpmon md5 host all gpmon 127.0.0.1/28 md5

重启数据库gpstop -r

检查是否成功[gpadmin@mdw ~]$ ps -ef | grep gpmmongpadmin 24206 24197 0 16:03 ? 00:00:01 /usr/local/gpdb-5.6/bin/gpmmon -D /gpdata/gp-5.6/master/gpseg-1/gpperfmon/conf/gpperfmon.conf -p 5432gpadmin 30123 20766 0 17:40 pts/0 00:00:00 grep gpmmon[gpadmin@mdw ~]$ [gpadmin@mdw ~]$ psql -d 'gpperfmon' -c 'select * from system_now;' ctime | hostname | mem_total | mem_used | mem_actual_used | mem_actual_free | swap_total | swap_used | swap_page_in | swap_page_out | cpu_user | cpu_sys | cpu_idle | load0 | load1 | load2 | quantum | disk_ro_rate | disk_wo_rate | disk_rb_rate | disk_wb_rate | net_rp_rate | net_wp_rate | net_rb_rate | net_wb_rate ---------------------+----------+------------+-----------+-----------------+-----------------+------------+-----------+--------------+---------------+----------+---------+----------+-------+-------+-------+---------+--------------+--------------+--------------+--------------+-------------+-------------+-------------+------------- 2018-10-16 17:40:30 | mdw | 1968324608 | 831598592 | 120971264 | 1847353344 | 1073737728 | 20869120 | 0 | 0 | 0.07 | 0.07 | 99.87 | 0 | 0 | 0 | 15 | 0 | 2 | 0 | 8001 | 8 | 7 | 1788 | 1823

确定无误后,就可以安装了

启动安装gpcc生成安装目录我下载的是可执行二进制文件。所以直接赋权运行即可。在这之后,会需要指定一些默认安装目录等信息。不作赘述,按照步骤就可以

[root@mdw gpdata]# ./greenplum-cc-web-3.3.1-LINUX-x86_64.bin

********************************************************************************You must read and accept the Pivotal Greenplum Database end user licenseagreement before installing********************************************************************************

*** IMPORTANT INFORMATION - PLEASE READ CAREFULLY ***

PIVOTAL GREENPLUM DATABASE END USER LICENSE AGREEMENT

IMPORTANT - READ CAREFULLY: This Software contains computer programs andother proprietary material and information, the use of which is subject toand expressly conditioned upon acceptance of this End User LicenseAgreement ("EULA").

This EULA is a legally binding document between you (meaning the person orthe entity that obtained the Software under the terms and conditions ofthis EULA, is agreeing to be bound by the terms and conditions of thisEULA, and is referred to below as "You" or "Customer") and Pivotal (meaning(i) Pivotal Software, Inc., if Customer is located in the United States;and (ii) the local Pivotal sales subsidiary, if Customer is located in acountry outside the United States in which Pivotal has a local salessubsidiary; and (iii) GoPivotal International Limited, if Customer islocated in a country outside the United States in which Pivotal does not..............

赋予权限可以看一下生成的一些文件

[root@mdw gpdata]# ls /usr/local/greenplum-cc-web-3.3.1/usr/local/greenplum-cc-web-3.3.1:bin etc gpcc_path.sh gp-wlm-1.8.3-x86_64.bin instances lib open_source_licenses_GPCC.txt www

这些文件,需要赋予一些权限,就是gpadmin用户的权限修改文件的属组

# chown -R gpadmin:gpadmin /usr/local//greenplum-cc-web-3.3.1

加载环境配置文件

#source /usr/local/greenplum-cc-web-3.3.1/gpcc_path.sh

好是要写在环境变量的环境中的也需将配置安装目录的bin目录定义到环境变量里,方便后面的安装

分发安装包到所有的子节点gpccinstall -f all_segs1这里这个命令的all_segs 是写了所有segement节点信息的文件。如果该命令没有执行成功也可以用scp直接将安装包拷贝到子目录,但是需要注意权限要赋予。

初始化gpcc[gpadmin@mdw ~]$ gpcmdr --setup

The instance name identifies the GPDB cluster this Greenplum Command Center web UI monitors and controls.Instance names can contain letters, digits, and underscores and are not case sensitive.

Please enter the instance nametest

The display name is shown as the "server" in the web interface and does not need to bea hostname.Display names can contain letters, digits, and underscores and ARE case sensitive.

Please enter the display name for this instance:(Press ENTER to use instance name)test

A GPCC instance can be set to manage and monitor a remote Greenplum Database.

Is the master host for the Greenplum Database remote? Yy/Nn (default=N)n

What port does the Greenplum Database use? (default=5432)

Enable kerberos login for this instance? Yy/Nn (default=N)n

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 new web server to use for this instance? (default=28080)

Users logging in to the Command Center must provide database usercredentials. In order to protect user names and passwords, it is recommendedthat SSL be enabled.

Enable SSL for the Web API Yy/Nn (default=N)

Copy the instance to a standby master host Yy/Nn (default=Y)nDone writing webserver configuration to /usr/local/greenplum-cc-web/instances/test/webserver/conf/app.conf

Creating instance at /usr/local/greenplum-cc-web/instances/test

Greenplum Command Center UI configuration is now complete.

To change parameters of this instance, edit the configuration fileat /usr/local/greenplum-cc-web/instances/test/webserver/conf/app.conf

To configure multi-cluster view, edit the configuration file at /usr/local/greenplum-cc-web/instances/test/conf/clusters.conf

The web UI for this instance is located at http://mdw:28080

You can now start the web UI for this instance by running: gpcmdr --start test

初始化成功之后就可以启动服务了

[gpadmin@mdw ~]$ gpcmdr --start testStarting instance test ...Greenplum Command Center UI for instance 'test' - [RUNNING on PORT: 28080, pid 20836][gpadmin@mdw ~]$

登录到web界面在网站中输入IP地址+端口号如192.168.2.61:28080

直接就可以到达登录界面

这里就可以登录了。账户是个gpmon密码是在创建这个用户时的设置的密码,这里是123456

输入点击,就可以了

登录进来后可以看到界面

致此:greenplum-cc-web安装完成本文来源:https://blog.csdn.net/qq_43303221/article/details/83095270

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论