#Prometheus exporter for MySQL server metrics. Supported MySQL versions: 5.1 and up.

The project was forked from https://hub.docker.com/r/prom/mysqld-exporter/

Additional flags

--collect.info_schema.innodbcmp --collect.info_schema.innodbcmpmem

Required mysql grants

CREATE USER 'exporter'@'%' IDENTIFIED BY 'password' WITH MAX_USER_CONNECTIONS 3; GRANT PROCESS, REPLICATION CLIENT, SELECT ON . TO 'exporter'@'%';

Running using Docker-compose

... mysql-exporter: image: adivinho/mysqld-exporter:version1 environment: - DATA_SOURCE_NAME=exporter:password@(dockerct_db_1:3306)/mysql networks: - my-net command: - "--collect.info_schema.innodbcmp" - "--collect.info_schema.innodbcmpmem" ports: - '9104:9104' ...

Prometheus configuration file

global: scrape_interval: 5s external_labels: monitor: 'my-monitor' scrape_configs:

• job_name: 'prometheus' target_groups:
  • targets: ['localhost:9090']
• job_name: 'node-exporter' target_groups:
  • targets: ['node-exporter:9100']
• job_name: 'mysqld_exporter' target_groups:
  • targets: ['dockerct_mysql-exporter_1:9104']