Hi All,
We have a galera mariadb 10.6 version three node cluster. When I tried
installing mysql exporter by following the link
https://computingforgeeks.com/monitoring-mysql-mariadb-with-prometheus-in-five-minutes/?expand_article=1
, I could not get the exporter to detect the mysql service in which it is
running .. These are the logs:
--
/tmp# curl -s <IP>:9104/metrics | grep mysql_up
ts=2023-08-18T11:22:21.544Z caller=exporter.go:152 level=error msg="Error
pinging mysqld" err="dial tcp 127.0.0.1:3306: connect: connection refused"
# HELP mysql_up Whether the MySQL server is up.
# TYPE mysql_up gauge
mysql_up 0
---
But the mariadb service is running on this node:
---
● mariadb.service - MariaDB 10.6.10 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor
preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf, override.conf
Active: active (running) since Wed 2023-05-10 23:10:13 UTC; 3 months 8
days ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 2540463 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 1587 (limit: 618903)
CPU: 2w 5d 9h 34min 28.076s
CGroup: /galera.slice/mariadb.service
└─2540463 /usr/sbin/mariadbd
--wsrep_start_position=d635b506-3dd8-11e8-989e-7aec6efd1673:2862939478
---
Can anyone help me where the fault is ? I have given enough privileges for
the 'mysqld_exporter' user as well.
Thanks
Kumar
--
You received this message because you are subscribed to the Google Groups
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to prometheus-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/prometheus-users/1ec67ca6-aa94-4749-9f0d-13edc4474d4bn%40googlegroups.com.
