Prometheus监控MySQL

> wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz
> tar -xzvf mysqld_exporter-0.13.0.linux-amd64.tar.gz
> mv mysqld_exporter-0.13.0.linux-amd64 /usr/local/mysqld_exporter
> chown -R prometheus:prometheus /usr/local/mysqld_exporter

> grant process,replication client,select on *.* to 'agent'@'%' identified by '123456';
> flush privileges;

> vim /usr/local/mysqld_exporter/.my.cnf
[client]
user=agent
password=123456

> vim /usr/lib/systemd/system/mysqld_exporter.service
[Unit]
Description=https://prometheus.io

[Service]
Restart=on-failureExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=.my.cnf 

[Install]
WantedBy=multi-user.target

> systemctl daemon-reload
> systemctl start mysqld_exporter

> vim /usr/local/prometheus/prometheus.yml
scrape_configs:
  # 添加作业并命名
  - job_name: 'mysql'
    # 静态添加node
    static_configs:
    # 指定监控端
    - targets: ['127.0.0.1:9104']

> systemctl reload prometheus.service