Template variables are not supported in alert queries

[Dillon_lu]

Hi all,

version: pmm-admin 1.17.1
I tried to create alert message by PMM with “Template variables are not supported in alert queries”. I searched website and found a solution by Percona: to copy and created a new metric modified the host name.

However, there is a problem. If I monitor a lot of DB instances, does this mean I have to create a lot of new metric?

Is there a way to create alert more convenience ?

Thanks,
Dillon

[Peter]

Current solution is not perfect for sure. If you monitor a lot of instances you may want to create dashboard which triggers when any of the instances exceed threshold.
For example if you monitor replication lag you may look for max seconds_behind_master among the fleet of slaves and have alert triggered when it happens. The problem with such approach is of course you would not directly see which host triggered it.

[Dillon_lu]

@Peter;54323

Current solution is not perfect for sure. If you monitor a lot of instances you may want to create dashboard which triggers when any of the instances exceed threshold.
For example if you monitor replication lag you may look for max seconds_behind_master among the fleet of slaves and have alert triggered when it happens. The problem with such approach is of course you would not directly see which host triggered it.

Hi Peter,
Thanks.