docker-compose.yml

version: '2'
services:
  pro_mysql:
    container_name: pro_mysql
    image: mysql
    ports:
      - "3309:3306"
    environment:
      - MYSQL_ROOT_PASSWORD=password
      - MYSQL_DATABASE=database
  pro_mysql_exporter:
    container_name: pro_mysql_exporter
    image: prom/mysqld-exporter
    ports:
      - "9104:9104"
    environment:
      - DATA_SOURCE_NAME=root:password@(pro_mysql:3306)/database
  prometheus:
    container_name: prometheus
    image: prom/prometheus
    volumes:
      - /root/Prometheus/prometheus.yml:/etc/prometheus/prometheus.yml
    ports:
      - "20001:9090"
  grafana:
    container_name: grafana
    image: grafana/grafana
    environment:
      - GF_SERVER_ROOT_URL=http://82.156.245.74:20002
      - GF_SECURITY_ADMIN_PASSWORD=admin
    ports:
      - "20002:3000"

prometheus.yml

global:
  scrape_interval:     15s
  evaluation_interval: 15s

alerting:
  alertmanagers:
  - static_configs:
    - targets:

scrape_configs:
  - job_name: 'prometheus'
    static_configs:
      - targets: ['prometheus:9090']

  - job_name: 'mysql'
    scrape_interval: 5s
    static_configs:
      - targets: ['pro_mysql_exporter:9104']

Run

docker network create mysql-monitor #建立一个监控用的 docker network
docker-compose -f docker-compose.yml -p mysql-monitor up -d

访问服务器 http://82.156.245.74:20002/ 本地主机或者服务器 IP，用户名与密码均为：admin

配置

点击 import 引入文档 MySQL.json

出现以下页面代表运行成功