方法一

docker-compose.yml 

  1. version: "3"
  3. services:
  4.   mysql:
  5.     container_name: mysql8
  6.     image: mysql/mysql-server:8.0.18-1.1.13
  7.     command: --default-authentication-plugin=mysql_native_password
  8.     ports:
  9.       - 3306:3306
  10.       - 33060:33060
  11.     environment:
  12.       MYSQL_ROOT_PASSWORD: 123456
  13.       MYSQL_USER: hxy
  14.       MYSQL_PASSWORD: hxy
  15.     volumes:
  16.       - ./conf:/etc/mysql/conf.d
  17.       - ./data:/var/lib/mysql
  18.     networks:
  19.       - mysql-monitor-network
  21.   mysqld-exporter:
  22.     container_name: mysqld-exporter
  23.     image: prom/mysqld-exporter:v0.12.1
  24.     ports:
  25.       - 9104:9104
  26.     environment:
  27.       DATA_SOURCE_NAME: "hxy:hxy@(mysql:3306)/"
  28.     networks:
  29.       - mysql-monitor-network
  30.     depends_on:
  31.       - mysql
  33.   prometheus:
  34.     container_name: prometheus
  35.     image: prom/prometheus:v2.23.0
  36.     ports:
  37.       - 9090:9090
  38.     volumes:
  39.       - ./prometheus/prometheus.yml:/etc/prometheus/prometheus.yml
  40.       - ./prometheus/data:/prometheus
  41.     networks:
  42.       - mysql-monitor-network
  44.   grafana:
  45.     container_name: grafana
  46.     container_name: grafana
  47.     image: grafana/grafana:7.3.4
  48.     ports:
  49.       - 3000:3000
  50.     volumes:
  51.       # 数据存储位置
  52.       - ./grafana/data:/var/lib/grafana
  53.     networks:
  54.       - mysql-monitor-network
  56. networks:
  57.   mysql-monitor-network:

所有容器必须在同个网络中，不然网络互相隔离，访问不到对方

prometheus.yml 内容如下
**

  1. # my global config
  2. global:
  3.   scrape_interval:     15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.
  4.   evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.
  5.   # scrape_timeout is set to the global default (10s).
  7. # Alertmanager configuration
  8. alerting:
  9.   alertmanagers:
  10.   - static_configs:
  11.     - targets:
  12.       # - alertmanager:9093
  14. # Load rules once and periodically evaluate them according to the global 'evaluation_interval'.
  15. rule_files:
  16.   # - "first_rules.yml"
  17.   # - "second_rules.yml"
  19. # A scrape configuration containing exactly one endpoint to scrape:
  20. # Here it's Prometheus itself.
  21. scrape_configs:
  22.   # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.
  23.   - job_name: 'prometheus'
  25.     # metrics_path defaults to '/metrics'
  26.     # scheme defaults to 'http'.
  28.     static_configs:
  29.     - targets: ['localhost:9090']
  31.   - job_name: 'mysql8'
  32.     static_configs:
  33.     - targets: ['mysqld-exporter:9104']

mysql8 的链接地址，可以写 mysqld-exporter 的vip，也可以使用容器名称代替，如上

下一步需要登录 grafana ，添加数据源。访问 localhost:3000 ，在设置里面添加数据源
image.png
image.png
同理， url 可以使用vip，也可以使用容器名称，然后添加 mysql dashboard 模版
image.png
id 为 7362 ，注意不要用 12826 或 9777 ，因为后面两个模版，好像不是用于mysql master版本的，会显示不出数据，因为模版有问题，导入完模版就能看到数据啦

image.png

方法二

除了将几个容器都放到同个 docker-compose.yml 外，也可以将其拆分开来，方便管理

首先创建一个外部 network ，用于不同容器之间通讯

  1. $ docker network create grafana-monitor-network

mysql docker-compose.yml 

  1. version: "3"
  3. services:
  4.   mysql:
  5.     container_name: mysql8
  6.     image: mysql/mysql-server:8.0.18-1.1.13
  7.     command: --default-authentication-plugin=mysql_native_password
  8.     ports:
  9.       - 3306:3306
  10.       - 33060:33060
  11.     environment:
  12.       MYSQL_ROOT_PASSWORD: 123456
  13.       MYSQL_USER: hxy
  14.       MYSQL_PASSWORD: hxy
  15.     volumes:
  16.       - ./conf:/etc/mysql/conf.d
  17.       - ./data:/var/lib/mysql
  18.     networks:
  19.       - mysql-network
  20.       - grafana-monitor-network
  22.   mysqld-exporter:
  23.     container_name: mysqld-exporter
  24.     image: prom/mysqld-exporter:v0.12.1
  25.     ports:
  26.       - 9104:9104
  27.     environment:
  28.       DATA_SOURCE_NAME: "hxy:hxy@(mysql:3306)/"
  29.     networks:
  30.       - mysql-network
  31.       - grafana-monitor-network
  32.     depends_on:
  33.       - mysql
  35. networks:
  36.   mysql-network:
  37.   grafana-monitor-network:
  38.     external: true

这里将 mysql 跟 mysqld-exporter 放一起， mysqld-exporter 依赖 mysql 一起启动

prometheus docker-compose.yml 

  1. version: "3"
  3. services:
  4.   prometheus:
  5.     container_name: prometheus
  6.     image: prom/prometheus:v2.23.0
  7.     ports:
  8.       - 9090:9090
  9.     volumes:
  10.       - ./prometheus.yml:/etc/prometheus/prometheus.yml
  11.       - ./data:/prometheus
  12.     networks:
  13.       - grafana-monitor-network
  14. networks:
  15.   grafana-monitor-network:
  16.     external: true

prometheus.yml 

  1. # my global config
  2. global:
  3.   scrape_interval:     15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.
  4.   evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.
  5.   # scrape_timeout is set to the global default (10s).
  7. # Alertmanager configuration
  8. alerting:
  9.   alertmanagers:
  10.   - static_configs:
  11.     - targets:
  12.       # - alertmanager:9093
  14. # Load rules once and periodically evaluate them according to the global 'evaluation_interval'.
  15. rule_files:
  16.   # - "first_rules.yml"
  17.   # - "second_rules.yml"
  19. # A scrape configuration containing exactly one endpoint to scrape:
  20. # Here it's Prometheus itself.
  21. scrape_configs:
  22.   # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.
  23.   - job_name: 'prometheus'
  25.     # metrics_path defaults to '/metrics'
  26.     # scheme defaults to 'http'.
  28.     static_configs:
  29.     - targets: ['localhost:9090']
  31.   - job_name: 'mysql8'
  32.     static_configs:
  33.     - targets: ['mysqld-exporter:9104']

grafana docker-compose.yml 

  1. version: "3"
  3. services:
  4.   grafana:
  5.     container_name: grafana
  6.     image: grafana/grafana:7.3.4
  7.     ports:
  8.       - 3000:3000
  9.     volumes:
  10.       # 数据存储位置
  11.       - ./data:/var/lib/grafana
  12.     networks:
  13.       - grafana-monitor-network
  15. networks:
  16.   grafana-monitor-network:
  17.     external: true

grafana 默认用户名密码为 admin/admin