如果我们用阿里云的RDS，阿里云会提供mysql的监控面板，今天我们自己搭建一个。

前提

• 需要先安装好Docker环境。

数据流程图

用到的软件

• mysql-exporter。用于导出mysql的监控数据；
• prometheus。用于存储mysql的监控时序数据。
• grafana。用于展示mysql的监控数据

准备docker-compose文件

version: "3.7"
services:
  # mysql容器
  mysql:
    image: mysql
    container_name: mysql
    ports:
      - 3306:3306
    environment:
      MYSQL_ROOT_PASSWORD: "123456"
  # mysql监控参数导出
  mysql-exporter:
    image: prom/mysqld-exporter
    container_name: mysql-exporter
    volumes:
      - ./mysql-exporter/my.cnf:/etc/my.cnf
    ports:
      - 9104:9104
    command:
      - --config.my-cnf=/etc/my.cnf
  # 监控参数存储
  prometheus:
    image: prom/prometheus
    container_name: prometheus
    ports:
      - 9090:9090
    volumes:
      - ./prometheus/etc/prometheus.yml:/etc/prometheus/prometheus.yml
    command: [
        "--config.file=/etc/prometheus/prometheus.yml",
        "--storage.tsdb.path=/prometheus",
        "--storage.tsdb.retention.time=1d", # 设置数据值存储1天
      ]
  # 监控参数展示
  grafana:
    image: grafana/grafana
    container_name: grafana
    ports:
      - "3000:3000"
    volumes:
      - ./grafana:/var/lib/grafana

各个软件的配置

• my.conf。用于设置连接mysql的账号密码。

[client]
user = root
password = 123456

• prometheus.yml。prometheus的配置

# 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:
  - job_name: mysql # To get metrics about the mysql exporter’s targets
    params:
      # Not required. Will match value to child in config file. Default value is `client`.
      auth_module: [client]
    static_configs:
      - targets:
          # mysql的主机地址和端口
          - 172.17.0.1:3306
    relabel_configs:
      - source_labels: [__address__]
        target_label: __param_target
      - source_labels: [__param_target]
        target_label: instance
      - target_label: __address__
        # mysqld_exporter端口和地址
        replacement: 172.17.0.1:9104

运行容器

执行命令

docker-compose up -d

然后浏览器访问: http://127.0.0.1:3000，就可以看到grafana的界面了。

配置数据源

加载模版

在grafana官方搜索mysql模版，我这里用的是 14057，import即可。

查看效果