# Alert manager integration, receiving 3 alerts for mysql and 1 alert for postgres

**URL:** <https://forums.percona.com/t/alert-manager-integration-receiving-3-alerts-for-mysql-and-1-alert-for-postgres/8238>\
**Category:** PMM 2.x\
**Created:** [November 4, 2020, 11:36am UTC](https://forums.percona.com/t/alert-manager-integration-receiving-3-alerts-for-mysql-and-1-alert-for-postgres/8238 "2020-11-04T11:36:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![phani111](https://avatars.discourse-cdn.com/v4/letter/p/5f9b8f/32.png) [@phani111](https://forums.percona.com/u/phani111)\
**Post date:** [November 4, 2020, 11:36am UTC](https://forums.percona.com/t/alert-manager-integration-receiving-3-alerts-for-mysql-and-1-alert-for-postgres/8238/1 "2020-11-04T11:36:03Z")

</div>

Have integrated pmm2 with

Both Mysql and Postgres have 3 exporters defined when we created a system in PMM

Have created 3 systems and details as follows

1. postgres-prod1

Exporters:-

postgres\_exporter\_agent\_id\_9e585436-28f9-4821-878a-ebb4fe1464ce\_hr-5s

postgres\_exporter\_agent\_id\_9e585436-28f9-4821-878a-ebb4fe1464ce\_lr-1m0s

postgres\_exporter\_agent\_id\_9e585436-28f9-4821-878a-ebb4fe1464ce\_mr-10s

==============================================================

1. postgres-test

Exporters:-

postgres\_exporter\_agent\_id\_6bcf3f79-96ec-442b-bb53-9556b04686cb\_hr-5s

postgres\_exporter\_agent\_id\_6bcf3f79-96ec-442b-bb53-9556b04686cb\_lr-1m0s

postgres\_exporter\_agent\_id\_6bcf3f79-96ec-442b-bb53-9556b04686cb\_mr-10s

==========================================================

1. mysql-test

Exporters:-

mysqld\_exporter\_agent\_id\_a46bb1de-bebb-45ca-bde2-e31e82eb0159\_hr-5s

mysqld\_exporter\_agent\_id\_a46bb1de-bebb-45ca-bde2-e31e82eb0159\_lr-1m0s

mysqld\_exporter\_agent\_id\_a46bb1de-bebb-45ca-bde2-e31e82eb0159\_mr-10s

================================================

When postgres is down we are getting only one alert from alert manager which is having the postgres\_exporter\_agent\_id\_9e585436-28f9-4821-878a-ebb4fe1464ce\_hr-5s

but where as when mysql is down we are getting 3 alerts

mysqld\_exporter\_agent\_id\_a46bb1de-bebb-45ca-bde2-e31e82eb0159\_hr-5s

mysqld\_exporter\_agent\_id\_a46bb1de-bebb-45ca-bde2-e31e82eb0159\_lr-1m0s

mysqld\_exporter\_agent\_id\_a46bb1de-bebb-45ca-bde2-e31e82eb0159\_mr-10s

For Postgres we are getting only below alert [-5s] but not [-1m0s,-10s]

postgres\_exporter\_agent\_id\_9e585436-28f9-4821-878a-ebb4fe1464ce\_hr-5s

When both postgres and mysql have 3 jobs each why only postgres we are getting 1 alert only for -5s but for mysql we are getting 3 alerts for the three jobs [-5s,-1m0s,-10s]

alertmanager.yml

prometheus.yml

rules.yml attached

[files.zip](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/4209d649571dc07e0e29896d3b7dd1f3db064a46.zip)

[files.zip](https://forums.percona.com/uploads/short-url/9qcAvwwPVqqbnM3fAYLI0w31V9c.zip) (1.55 KB)

---

<div class="post-metadata">

**Author:** ![alexey.palazhchenko](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alexey.palazhchenko/32/35_2.png) [@alexey.palazhchenko](https://forums.percona.com/u/alexey.palazhchenko)\
**Post date:** [December 2, 2020, 9:56am UTC](https://forums.percona.com/t/alert-manager-integration-receiving-3-alerts-for-mysql-and-1-alert-for-postgres/8238/2 "2020-12-02T09:56:23Z")

</div>

Under the hood, mysqld\_exporter returns “mysql\_up” metric for each job/resolution. So you have to use aggregation in your alerting rule. For example: “min by (service\_name, node\_name) (mysql\_up) == 0”.