Adding PMM dashboards and QAN into Grafana

[Andrew2]

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.

We’ve been attempting to include some of the PMM dashboards into the standard Grafana service using the python script : grafana-dashboards/misc/convert-dash-from-PMM.py at main · percona/grafana-dashboards · GitHub

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?

[matthewb]

Hi Andrew,

@Andrew2

to a centralised Grafana service for all platforms.

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.

@Andrew2

but is it possible to include Query Analyser

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.