Adding alerts to queries

Mikem · November 17, 2021, 1:35pm

I have an alert on mysql_global_status_wsrep_cluster_size and it works well. I want to add a second query/alert on ‘wsrep_cluster_status’ but 1) I do not know how to associate this query with a different alert. and 2) I am not sure how to compare a literal string i.e. ‘Primary’ using the functions provided (abs, min, max, etc).

Vadim_Yalovets · November 17, 2021, 3:04pm

Hi Mikem,

You should create a new alert rule template and use it in a new alert.

The metric returns number 1 for Primary.

Screenshot 2021-11-17 at 16.59.35

Mikem · November 17, 2021, 10:08pm

I only show tabs for Alert Rules and Notification Channels. How do i add/see Alert Rule Templates?

Mikem · November 17, 2021, 10:11pm

I found it. Thanks for the help.

Mikem · November 18, 2021, 6:50pm

Trying to create an Alert Rule Template but read this on your site -

type (required): PMM currently supports the float type. (More will be available in the future, such as string or bool .)

Does this mean I cannot compare a ‘string’ to a status variable, i.e. ‘wsrep_cluster_status’ ??

I want to create an alert that fires when wsrep_cluster_status <> ‘Primary’

Vadim_Yalovets · November 19, 2021, 10:26am

The metric can have values 1 or 0.

github.com

percona/mysqld_exporter/blob/401f16b4bee56527470b97c19a470eb7f40ab914/collector/collector.go#L45


      
          	}
          	if bytes.Compare(data, []byte("No")) == 0 || bytes.Compare(data, []byte("OFF")) == 0 {
          		return 0, true
          	}
          	// SHOW SLAVE STATUS Slave_IO_Running can return "Connecting" which is a non-running state.
          	if bytes.Compare(data, []byte("Connecting")) == 0 {
          		return 0, true
          	}
          	// SHOW GLOBAL STATUS like 'wsrep_cluster_status' can return "Primary" or "non-Primary"/"Disconnected"
          	if bytes.Compare(data, []byte("Primary")) == 0 {
          		return 1, true
          	}
          	if strings.EqualFold(string(data), "non-Primary") || bytes.Compare(data, []byte("Disconnected")) == 0 {
          		return 0, true
          	}
          	if logNum := logRE.Find(data); logNum != nil {
          		value, err := strconv.ParseFloat(string(logNum), 64)
          		return value, err == nil
          	}
          	value, err := strconv.ParseFloat(string(data), 64)
          	return value, err == nil

Topic		Replies	Views
PMM monitor/alert cluster health PMM 2.x pmm	4	937	October 25, 2021
Alerting using Custom template - Alerting but with Extraneous Labels PMM 2.x	2	791	December 21, 2023
Template variables are not supported in alert queries PMM 1.x	2	1322	July 23, 2019
Can I verify the template of "Integrated Alerting" PMM 2.x	6	719	October 29, 2021
Cluster alert rule on pmm Percona Monitoring and Management (PMM) pmm , mysql , percona	7	267	August 16, 2024

Adding alerts to queries

Related topics