Grouping servers in grafana/prometheus

[george....@kkbox.com]

I would like to group database servers in grafana dashboards e.g, servers belonging to the same cluster, db-pxc, end up looking like this:

DB-PXC
-Disk_Performance
-db-pxc-1
-db-pxc-2
-db-pxc-3
...
-Disk_Space
-db-pxc-1
-db-pxc-2
-db-pxc-3
...
-MySQL_Overview
-db-pxc-1
-db-pxc-2
-db-pxc-3
...
-MySQL_Table_statistics
-db-pxc-1
-db-pxc-2
-db-pxc-3
...
...
So if i click on the parent dashboard Disk_Space, it displays disk space sub dashboard for each host in the db-pxc cluster (db-pxc-1, db-pxc-2, db-pxc-3, ...). That way i can compare the disk space usage of all my servers in one cluster on a single page. We already have this setup in cacti, but not sure how we can achieve the same with grafana.

We are using Promethues monitoring system, node_exporter & mysqld_exporter for collecting statistics on each individual server, and grafana for viewing the dashboard. To view data of the mysqld and node exporters supported by prometheus in grafana, we are using the Percona Grafana plugin.

[Tobias Schmidt]

I'm not sure what you mean with a sub dashboard, but you can repeat panels in Grafana for a given template variable. Create a node/host template variable http://docs.grafana.org/reference/templating/ and then use the repeated row/panel feature http://docs.grafana.org/reference/templating/#utilizing-template-variables-with-repeating-panels-and-repeating-rows.

The demo node_exporter dashboard on the grafana page uses that to repeat the disk stats panel at the bottom for each mounted disk http://play.grafana.org/dashboard/db/prometheus-demo-dashboard.

--
You received this message because you are subscribed to the Google Groups "Prometheus Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-devel...@googlegroups.com.
To post to this group, send email to prometheus...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-developers/9671a5f9-fc54-4400-9c2a-4b8011a2d715%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[george....@kkbox.com]

I tried to use templating using the documentation you provided. But when i enable Multi-value, the graph disappears.

My mysqld_exporter/node_exporter is using the percona grafana plugin app.

[Tobias Schmidt]

Make sure to write your expressions using the regex selector when you use muli-value or all options. E.g. `foo{label=~"$variable"}`

To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-developers/7968dcba-f6b1-4912-a83c-8b84b03a67dd%40googlegroups.com.