Not the answer you need?
Register and ask your own question!

Template variables are not supported in alert queries

Dillon_luDillon_lu ContributorCurrent User Role Novice
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

Comments

  • PeterPeter Percona CEO Percona Moderator Role
    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_luDillon_lu Contributor Current User Role Novice
    Peter wrote: »
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.