Installation MySQL

https://www.digitalocean.com/community/tutorials/monitoring-mysql-and-mariadb-droplets-using-prometheus-mysql-exporter#download-and-install-prometheus-mysql-exporter

sudo groupadd --system prometheus

sudo useradd -s /sbin/nologin --system -g prometheus prometheus

curl -s <https://api.github.com/repos/prometheus/mysqld_exporter/releases/latest> | grep browser_download_url | grep linux-amd64 | cut -d '"' -f 4 | wget -qi -

tar xvf mysqld_exporter*.tar.gz

sudo mv mysqld_exporter-*.linux-amd64/mysqld_exporter /usr/local/bin/

sudo chmod +x /usr/local/bin/mysqld_exporter

mysql -u root -p

CREATE USER 'mysqld_exporter'@'localhost' IDENTIFIED BY 'Pa$$w0rd';

GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysqld_exporter'@'localhost';

FLUSH PRIVILEGES;

EXIT

sudo nano /etc/.mysqld_exporter.cnf

[client]
user=mysqld_exporter
password=Pa$$w0rd

sudo chown root:prometheus /etc/.mysqld_exporter.cnf

sudo nano /etc/systemd/system/mysql_exporter.service

[Unit]
Description=Prometheus MySQL Exporter
After=network.target
User=prometheus
Group=prometheus

[Service]
Type=simple
Restart=always
ExecStart=/usr/local/bin/mysqld_exporter \\
--config.my-cnf /etc/.mysqld_exporter.cnf \\
--collect.global_status \\
--collect.info_schema.innodb_metrics \\
--collect.auto_increment.columns \\
--collect.info_schema.processlist \\
--collect.binlog_size \\
--collect.info_schema.tablestats \\
--collect.global_variables \\
--collect.info_schema.query_response_time \\
--collect.info_schema.userstats \\
--collect.info_schema.tables \\
--collect.perf_schema.tablelocks \\
--collect.perf_schema.file_events \\
--collect.perf_schema.eventswaits \\
--collect.perf_schema.indexiowaits \\
--collect.perf_schema.tableiowaits \\
--collect.slave_status \\
--web.listen-address=0.0.0.0:9104

[Install]
WantedBy=multi-user.target

sudo systemctl daemon-reload

sudo systemctl enable mysql_exporter