天天看点

mysql exporter_prometheus + mysqld_exporter + grafana 实现对mysql db的监控

https://blog.csdn.net/hfut_wowo/article/details/78536022

1、参考这篇博文

2、博主的用的是windows版本 prometheus-2.5.0-rc.2.windows-amd64,mysqld_exporter-0.11.0.windows-amd64

3、prometheus和mysqld_exporter下载地址   https://prometheus.io/download/#mysqld_exporter

下载后mysqld_exporter 没有.my.cnf

手动新建一个内容如下

[client]

host=127.0.0.1

user=root

password=root

4、修改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: ['localhost:9090']

- job_name: mysql

static_configs:

- targets: ['localhost:9104']

labels:

instance: mydb

5、其他步骤同上面博文连接所述

6、spring boot集成prometheus

https://dzone.com/articles/creating-visualization-in-grafana