达梦数据库-prometheus连接dem

配置dem

1.配置dem监控平台并添加主机监控和数据库监控
2.从DEM->系统管理->其他功能->prmetheus_metric_nodes 设置推送的数据库监控信息

3.配置Prometheus.yml 去dem/metrics 抓取数据

scrape_configs:
  # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.
  - job_name: 'prometheus'
    static_configs:
    - targets: ['localhost:9090']
    - targets: ['192.168.142.217:9100']
      labels:
         group: 'client-node-exporter'
    - targets: ['192.168.142.217:9161']
      labels:
         group: 'dmdb-node-exporter'
  - job_name: 'dem'
    metrics_path: '/dem/metrics'
    static_configs:
    - targets: ['192.168.142.241:8080'] ##dem的访问地址

4. 检查Prometheus有没有新增dem metrics 数据
   
   注意：
   新增Prometheus_metric_nodes 进行保存提示 列【AVL】 长度超出定义

CREATE TABLE "DEM"."ADMIN_CONFIG"
(
"SEQ" INT,
"GNAME" VARCHAR(256),
"NAME" VARCHAR(256),
"VAL" VARCHAR(256),
"DESCRIPTION" VARCHAR(512),
"INFO" INT);

将VAL 列长度改为8000，大约可以推送400个数据库的信息，超过400个就真的超了