Cluster Nodes dashboard

1

Hi Friends,

I am learning on creating Grafana dashboards and currently trying to create Hypervisor cluster dashboard. I have created variable with regex to filter out matching windows hyper-v servers (based on domain). Now my requirement is to when I select specific host cluster, all the cluster nodes under that host cluster should be plotted. One example is given below.

Host Cluster : testhvcl001.domainname
Cluster Nodes : testhv01.domainname, testhv02.domainname and so on (tried to create regex to cut string before cl001 but not getting any success)

I have variable for Host Cluster is ready but I am not sure on how to proceed to get cluster nodes based on host cluster. Appreciate any help.

Regards,
Vijay

2

Please include what datasource you’re using for us to be able to futher help you.

3

Hi,

Thanks for replying. I am using influxdb as datasource.

Regards,
Vijay

4

You have to use regex for the cluster nodes variable. Something like

SHOW TAG VALUES WITH KEY = "clusterNode" WHERE "hostCluster" =~ /^.*\,$hostCluster$/

Please include query you’ve tried so far if this isn’t working

5

Thanks for your reply. Here is my query.

SHOW TAG VALUES WITH KEY = "host"
Regex : /(.*?hvcl\d\d\d\.my\.domain\.com)/

With this query, I am able to fetch host cluster and display them on drop down menu in dashboard but requirement is when we select host cluster from drop down menu, respective cluster nodes should be graphed.

So lets say, I have a1cl.my.domain.com ( a101.my.domain.com, a102.my.domain.com, a102.my.domain.com) and a2cl.my.domain.com (a201.my.domain.com, a202.my.domain.com).

In dashboard variable drop down, I am able to get a1cl.my.domain.com but when I select this host cluster, all the graphs should be updated with a101, a102 and a103 and same way if I select a2cl.my.domain.com respective graphs should be for a201 and a202.

Is this possible in grafana?

Appreciate your attention.

Regards,
Vijay