prometheus监控mysql

mysql -uroot -p123456

CREATE USER ‘exporter‘@‘localhost‘ IDENTIFIED BY ‘devops‘;


GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO ‘exporter‘@‘localhost‘;



FLUSH PRIVILEGES;

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz

tar xf mysqld_exporter-0.13.0.linux-amd64.tar.gz -C /opt/

ln -s /opt/mysqld_exporter-0.13.0.linux-amd64 /opt/mysqld_exporter

[root@ops opt]# cat /usr/lib/systemd/system/mysqld_exporter.service 
[Unit]
Description=mysqld_exporter Exporter
Wants=network-online.target
After=network-online.target

[Service]
Environment=DATA_SOURCE_NAME=exporter:devops@tcp/
ExecStart=/opt/mysqld_exporter/mysqld_exporter
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=mysqld_exporter
[Install]
WantedBy=default.target

systemctl start mysqld_exporter.service 
systemctl enable mysqld_exporter.service 

systemctl status mysqld_exporter.service