grafana 监控本地cpu gp监控工具

转载

mob64ca140f67e3 2024-06-02 15:53:56

文章标签 grafana 监控本地cpu greenplum 数据库 UI Customer 文章分类 云原生云计算

文章目录

概述
下载
安装前准备

安装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 gpmmon
gpadmin  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 5432
gpadmin  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_us
er | 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_ra
te | 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 |        17
88 |        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 license
agreement before installing
********************************************************************************

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

PIVOTAL GREENPLUM DATABASE END USER LICENSE AGREEMENT

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

This EULA is a legally binding document between you (meaning the person or
the entity that obtained the Software under the terms and conditions of
this EULA, is agreeing to be bound by the terms and conditions of this
EULA, 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 a
country outside the United States in which Pivotal has a local sales
subsidiary; and (iii) GoPivotal International Limited, if Customer is
located 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_segs

这里这个命令的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 name
test

The display name is shown as the "server" in the web interface and does not need to be
a 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 user
credentials. In order to protect user names and passwords, it is recommended
that 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)
n
Done 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 file
at /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 test
Starting instance test ...
Greenplum Command Center UI for instance 'test' - [RUNNING on PORT: 28080, pid 20836]
[gpadmin@mdw ~]$