We have moved from having disparate monitoring systems where we ran a PMM instance in docker for the databases, to a centralised Grafana service for all platforms.
While the script seems to work okay for standard ‘metrics’ but is it possible to include Query Analyser as this isn’t a standard ‘dashboard’ with a simple graph or table?
How come you just didn’t use PMM for this? Since PMM is already itself, 99% grafana, you could have brought in anything non-standard-PMM into PMM rather than the other way. We have many customers that have done this.
The QAN is a custom component that we created. It uses a ClickHouse backend. I’m not sure if it is available as a datasource. You’d have to expose the CH database outside the docker container and setup a custom scraper.
Grafana is now being used company wide, not just for the Database platforms. I was using PMM when other departments were using other tools, but now it’s centralised into Grafana for everything. In isolation, PMM is excellent, but it would be nice to be able to import all that same functionality into Grafana for scenarios like this
You’re not the first company using Grafana everywhere, we know this is a common use case. The best option we have is that in your main Grafana, you can add a datasource of the PMM instance, and mirror/pull the PMM data into Grafana. That will get you most of PMM. You’ll have to continue using PMM for QAN though.