CREATE USER 'exporter'@'%' IDENTIFIED BY 'exporter';
GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'exporter'@'%';
GRANT SELECT ON performance_schema.* TO 'exporter'@'%';

docker run -d -p 9104:9104 --network xxnet --name mysql_exporter -e DATA_SOURCE_NAME="exporter:exporter@(mariadb:3306)/" prom/mysqld-exporter:v0.14.0

root@omv:~# cat /etc/prometheus/prometheus.yml
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:

  # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.

  - job_name: "prometheus"



    # metrics_path defaults to '/metrics'

    # scheme defaults to 'http'.



    static_configs:

      - targets: ["localhost:9090"]

# mysql_exporter config

  - job_name: "mysql_metrics"

    metrics_path: '/metrics'

    static_configs:

      - targets: ["mysql_exporter:9104"]
  - job_name: "mysql_metrics2"

    metrics_path: '/metrics'

    static_configs:

      - targets: ["192.168.1.21:32327"]
root@omv:~#

docker run --name prometheus -d -p 9092:9090 -v /etc/prometheus/prometheus.yml:/etc/prometheus/prometheus.yml --network xxnet prom/prometheus

docker run -d -p 3000:3000 --name=grafana --network xxnet grafana/grafana