I have two machines. On the first one I have installed Prometheus and MySQL exporter via repositories and on the second one I have MariaDB database. I’d like to get User Statistics data from the MariaDB database without installing mysql exporter on it.
Is there any configuration example where Prometheus mysql exporter communicate with database remotely?
and-grafana-at-scalegrid/ shows exactly this setup.
See the section “Installing & Configuring MySQL Prometheus Exporter” where it
says “Prometheus requires an exporter for collecting MySQL server metrics.
This exporter can be run centrally on the Prometheus server, or on the
database server.”