配置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的访问地址
- 检查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个就真的超了