Pom依赖
<dependency>
    <groupId>io.micrometer</groupId>
    <artifactId>micrometer-registry-prometheus</artifactId>
</dependency>
项目开启监控
management.endpoint.metrics.enabled=true
management.endpoints.web.exposure.include=*
management.endpoint.prometheus.enabled=true
management.metrics.export.prometheus.enabled=true

docker run -d -p 3000:3000 --name=grafana -v /Users/daitechang/data/grafana:/var/lib/grafana grafana/grafana

http://localhost:3000

导入现成的模版
git clone https://github.com/percona/grafana-dashboards.git

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.11.0/mysqld_exporter-0.11.0.linux-amd64.tar.gz

tar -xvf mysqld_exporter-0.11.0.linux-amd64.tar.gz

数据库设置权限
GRANT REPLICATION CLIENT, PROCESS ON *.* TO 'exporter'@'localhost' identified by '123456';
GRANT SELECT ON performance_schema.* TO 'exporter'@'localhost';
flush privileges;

Running using an environment variable:

创建.my.cnf
[client]
user=exporter
password=123456
hostname=
port=

运行
./mysqld_exporter --config.my-cnf=".my.cnf" &

配置prometheus
- job_name: mysql
    static_configs:
      - targets: ['192.168.1.120:9104']
        labels:
          instance: db1