Prometheus. Monitor MySQL server using Prometheus: различия между версиями
Cless (обсуждение | вклад) |
Cless (обсуждение | вклад) |
||
| Строка 5: | Строка 5: | ||
<code>mysql -u -root -p</code> | <code>mysql -u -root -p</code> | ||
<code>CREATE USER 'mysqlexporter'@'localhost' IDENTIFIED BY ' | <code>CREATE USER 'mysqlexporter'@'localhost' IDENTIFIED BY 'PassWord#1';</code> | ||
<code>GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysqlexporter'@'localhost';</code> | <code>GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysqlexporter'@'localhost';</code> | ||
| Строка 30: | Строка 30: | ||
[client] | [client] | ||
user=mysqlexporter | user=mysqlexporter | ||
password= | password=PassWord#1 | ||
<code>chown -R mysqld_exporter:mysqld_exporter /etc/mysql_exporter</code> | <code>chown -R mysqld_exporter:mysqld_exporter /etc/mysql_exporter</code> | ||
Текущая версия на 17:45, 24 декабря 2023
At Client - MySQL Server (192.168.199.181)
mysql -u -root -p
CREATE USER 'mysqlexporter'@'localhost' IDENTIFIED BY 'PassWord#1';
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysqlexporter'@'localhost';
FLUSH PRIVILEGES;
Download mysqld_exporter from the official download page
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.11.0/mysqld_exporter-0.11.0.linux-amd64.tar.gz
tar -xvzf mysqld_exporter-0.11.0.linux-amd64.tar.gz
useradd -rs /bin/false mysqld_exporter
Copy mysqld_exporter file to /usr/bin.
mv mysqld_exporter-0.11.0.linux-amd64/mysqld_exporter /usr/bin
chown mysqld_exporter:mysqld_exporter /usr/bin/mysqld_exporter
mkdir -p /etc/mysql_exporter
nano /etc/mysql_exporter/.my.cnf
[client] user=mysqlexporter password=PassWord#1
chown -R mysqld_exporter:mysqld_exporter /etc/mysql_exporter
chmod 600 /etc/mysql_exporter/.my.cnf
nano /etc/systemd/system/mysql_exporter.service
[Unit] Description=MySQL Server fosslinux After=network.target [Service] User=mysqld_exporter Group=mysqld_exporter Type=simple ExecStart=/usr/bin/mysqld_exporter --config.my-cnf=/etc/mysql_exporter/.my.cnf Restart=always [Install] WantedBy=multi-user.target
systemctl daemon-reload
systemctl enable mysql_exporter
systemctl start mysql_exporter
Web
http://<mysql_Server_IP>:9104/metrics
At Prometheus Server
nano /etc/prometheus/prometheus.yml
... - job_name: 'mysql_exporter_fosslinux' scrape_interval: 5s static_configs: - targets: ['192.168.199.181:9104']
systemctl restart prometheus
Web
http://<prometheus-IP>:9090/targets