prometheus监控mysql

docker run --name lys-mysql 
  -v $PWD/conf:/etc/mysql/conf.d 
  -v $PWD/logs:/logs 
  -v $PWD/data:/var/lib/mysql 
  -e MYSQL_ROOT_PASSWORD=123456 
  -d  -p 13306:3306 mysql:latest

进入容器内部的mysql

mysql -u root -p

use mysql;

select host,user from user;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

flush privileges;

docker run -d 
  --name mysql_exporter 
  --restart always 
  -p 9104:9104 
  -e DATA_SOURCE_NAME="root:123456@(10.6.8.184:13306)/" 
  prom/mysqld-exporter

  - job_name: 'lysMysql'
    metrics_path: /metrics
    static_configs:
      - targets: ['10.6.8.184:9104']  # 配置被监控的mysql_export地址

下载监控模板地址
https://github.com/percona/grafana-dashboards
下载后上传