prometheus grafana opengauss-m6米乐安卓版下载

node_exporter

下载

https://github.com/prometheus/node_exporter/releases

启动

nohup /opt/node_exporter/node_exporter --no-collector.softnet > /opt/node_exporter/node_exporter.log 2>&1 &

opengass_exporter

opengauss_exporter使用详情请参考 https://www.modb.pro/db/47407

下载

https://gitee.com/enmotech/opengauss_exporter

配置数据库参数

echo "password_encryption_type=1" >> postgresql.conf
echo "host all opengauss_exporter x.x.x.x/32 md5" >> pg_hba.conf

配置数据库用户

create user opengauss_exporter with password 'opengauss_exporter123' monadmin;
grant usage on schema dbe_perf to opengauss_exporter;
grant select on pg_stat_replication to opengauss_exporter;

配置环境变量

export data_source_name="host=x.x.x.x user=xxx password=xxx port=xxx dbname=xxx sslmode=disable"
or
export data_source_name="postgresql://username:password@hostname:port/dbname?sslmode=disable"
or 
监控多实例
export data_source_name="postgresql://username:password@hostname:port/dbname?sslmode=disable,postgresql://username2:password2@hostname2:port2/dbname2?sslmode=disable"

启动

nohup /opt/opengauss_exporter/opengauss_exporter --config="/opt/opengauss_exporter/default_queries.yaml" --log.level=debug --auto-discover-databases --exclude-databases="template0,template1" --web.listen-address=":9187" --parallel=5 >> /opt/opengauss_exporter/opengauss_exporter.log 2>&1 &

prometheus

下载地址

https://prometheus.io/download/

解压

--以2.31.1版本为例
tar -zxvf prometheus-2.31.1.linux-amd64.tar.gz

编辑配置文件

vim prometheus.yml
# my global config
global:
  scrape_interval:     15s # set the scrape interval to every 15 seconds. default is every 1 minute.
  evaluation_interval: 15s # evaluate rules every 15 seconds. the default is every 1 minute.
  # scrape_timeout is set to the global default (10s).
# alertmanager configuration
alerting:
  alertmanagers:
  - static_configs:
    - targets:
      # - alertmanager:9093
# load rules once and periodically evaluate them according to the global 'evaluation_interval'.
rule_files:
  # - "first_rules.yml"
  # - "second_rules.yml"
# a scrape configuration containing exactly one endpoint to scrape:
# here it's prometheus itself.
scrape_configs:
  # the job name is added as a label `job=` to any timeseries scraped from this config.
  - job_name: 'prometheus'
    # metrics_path defaults to '/metrics'
    # scheme defaults to 'http’.
    static_configs:
    - targets: ['xxx.xxx.xxx.131:9090']
  - job_name: 'node'
    static_configs:
    - targets: ['xxx.xxx.xxx.131:9100']
      labels:
                instance: 'xxx.xxx.xxx.131'
    - targets: ['xxx.xxx.xxx.130:9100']
      labels:
                instance: 'xxx.xxx.xxx.130'
    - targets: ['xxx.xxx.xxx.62:9100']
      labels:
                instance: 'xxx.xxx.xxx.62'
  - job_name: 'mogdb'
    static_configs:
    - targets: ['xxx.xxx.xxx.131:9187']
      labels:
                instance: 'mogdb_131'
    - targets: ['xxx.xxx.xxx.130:9187']
      labels:
                instance: 'mogdb_130'
    - targets: ['xxx.xxx.xxx.62:9187']
      labels:
                instance: 'mogdb_62'

启动prometheus

nohup /opt/prometheus/prometheus --config.file=/opt/prometheus/prometheus.yml --web.enable-lifecycle > /opt/prometheus/prometheus.log 2>&1 &

grafana

下载地址

https://grafana.com/grafana/download
直接rpm下载
wget https://dl.grafana.com/oss/release/grafana-enterprise-8.2.4-1.x86_64.rpm

修改数据存储

---此步骤可以跳过，这里已postgresql为例
---创建数据库及数据库用户
create user grafanaer login encrypted password 'grafanaer';
create database grafana owner grafanaer;
—修改postgresql的pg_hba.cnf文件
vim /data/pg_data/pg_hba.conf
host    all             all             xxx.xxx.xxx.131/32         trust
---修改配置文件
vim /etc/grafana/grafana.ini
type = postgres
host = xxx.xxx.xxx.131:5432
name = grafana
user = grafanaer
password = grafanaer

启动grafana

systemctl daemon-reload
systemctl enable grafana-server.service
systemctl start grafana-server
systemctl status grafana-server

验证

--以网站的方式打开
http://xxx.xxx.xxx:3000
账号：admin
默认密码：admin
注：需要在阿里云ecs的安全组中流入方向打开自定义3000端口

配置数据源

导入dashboard