I have a table like this:
And would like to merge all columns that have the same name while preserving time (the goal is to display this in a state timeline pannel)
Is there any way of doing this that would not need intervention if some other node (let’s say mysql10) were to appear ?
I’m using Grafana v11.6.0
Hello !
This was indeed the right direction ! Thank you for the hint.
I switched the transformation to Long time series and added the Merge series/tables transformation to get your result. After that I could partition by values using the member_host field and got the result I wanted !
Here are my query and tranformations for anyone that wants to monitor Group Replication using data from the Prometheus mysqld_exporter:
PromQL query :
max by(member_host, member_state) (mysql_perf_schema_replication_group_member_info{replication_set=~"$replication_set"})
Transformations:
The result:
You’re very welcome!
Glad to hear it helped—feel free to reach out if you need anything else. Happy dashboarding!
