mysql_exporter 监控

创建 监控用户权限

CREATE USER 'prom_exporter'@'%' IDENTIFIED BY '你的强密码';

GRANT PROCESS, REPLICATION CLIENT, SELECT ON information_schema.* TO 'prom_exporter'@'%';
FLUSH PRIVILEGES;

创建一个 MySQL 配置文件，以便 mysqld_exporter 能够连接到数据库。可以使用以下命令创建或编辑配置文件：

cat my.cnf 
[client]
host=172.16.0.9
port=13307
user=监控数据库用户名
password=监控数据库密码

 

docker compose 部署 mysql_exporter

services:
  mysqlexporter:
    image: prom/mysqld-exporter
    container_name: mysqld_exporter
    restart: always
    ports:
      - "9104:9104"
    volumes:
      - /data/promthues/mysql_exporter/my.cnf:/.my.cnf
    entrypoint:
      - /bin/mysqld_exporter
      - --collect.info_schema.innodb_metrics
      - --collect.info_schema.processlist
      - --collect.perf_schema.tablelocks
      - --collect.perf_schema.eventsstatementssum
      - --collect.perf_schema.replication_applier_status_by_worker
      - --collect.binlog_size

修改promethues 配置

  - job_name: 'mysqld_exporter'
    metrics_path: '/metrics'
    file_sd_configs:
      - files:
        - metrics/mysql_exporter.yaml
        refresh_interval: 2m
        
 cat metrics/mysql_exporter.yaml 
- targets: ['172.16.0.7:9104']
  labels:
    job: mysql-server

 

grafana模板

https://files.cnblogs.com/files/blogs/776379/mysql-export-grafana.json?t=1789451053&download=true