I’ve got two machines. On 1 machine there are MariaDB and Prometheus installed. On the second machine I’ve got Grafana monitoring software installed. I monitor user statistics from the 1 machine by using Prometheus and Percona dashboards in Grafana.
On the 1 machine I have mariadb-server with a lot of different databases like
db1_access db1_users db1_selects db2_access db2_users db3_selects and so on...
My question is:
Is it possible to monitor each database separately? Like create variable with query for each particular database in Grafana and see the user statistics form only e.g. db1_users?
It seems to me that Prometheus can only recognize one server or another and cannot access particular database on server…
Thanks for any help in advance!