# MySQL Alert configuration - Alerting

**URL:** <https://forums.percona.com/t/mysql-alert-configuration-alerting/8950>\
**Category:** PMM 2.x\
**Tags:** pmm\
**Created:** [January 26, 2021, 10:54pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950 "2021-01-26T22:54:00Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![deepthip](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@deepthip](https://forums.percona.com/u/deepthip)\
**Post date:** [January 26, 2021, 10:54pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/1 "2021-01-26T22:54:00Z")

</div>

Hi - I’ve setup PMM using AWS market place AMI . The plan is to use this for PostgreSQL as well at a later point in time, but now it would be just MySQL . I’m trying to configure alerts via the integrated alerting and would like some pointers on how to create new alert rule templates. Any documentation or leads if I can find most commonly used templates would be great.

 ![Screen Shot 2021-01-26 at 2.53.11 PM](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2e675a543181cdcffac344f0069a6d8b4e3d0be8.jpeg)

I’ve uploaded the image of what exactly I’m reffering to above

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [January 27, 2021, 2:37am UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/2 "2021-01-27T02:37:08Z")

</div>

> **[Percona Monitoring and Management, Meet Prometheus Alertmanager - Percona...](https://www.percona.com/blog/2020/02/21/percona-monitoring-and-management-meet-prometheus-alertmanger/)**
>
> Percona Monitoring and Management 2.3.0 now has a more dynamic alerting mechanism for your PMM installations: Integration with Prometheus Alertmanager. 

> **[Configure - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/how-to/configure.html)**
>
> Documentation

> **[Integrating Prometheus Alert Manager with Percona Monitoring and Management...](https://playwithmysql.wordpress.com/2020/04/11/integrating-prometheus-alert-manager-with-percona-monitoring-and-management-pmm/)**
>
> What is Prometheus Alert Manager? Alert Manager is an open source tool used to route the alerts generated by Prometheus to your receiver integration like Slack, PagerDuty, VictorOps, Email, WeChat,…

---

<div class="post-metadata">

**Author:** ![deepthip](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@deepthip](https://forums.percona.com/u/deepthip)\
**Post date:** [January 27, 2021, 4:19pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/3 "2021-01-27T16:19:36Z")

</div>

Thank matthewb, but isn’t integrated alerting different from Alert manager ? I’m looking at setting up integrated alerting to keep it simple. I’m a newbie to PMM , so keeping it as simple as possible. Please suggest

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [January 27, 2021, 7:41pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/4 "2021-01-27T19:41:43Z")

</div>

The integrated alerting provided by Grafana, in my personal opinion, is very difficult to use and only works on a per-graph basis.

> **[PMM Alerting with Grafana: Working with Templated Dashboards - Percona...](https://www.percona.com/blog/2017/02/02/pmm-alerting-with-grafana-working-with-templated-dashboards/)**
>
> In this blog post we will look into more intricate details of PMM Alerting. More specifically, we'll look at how to set up Alerting based on the templated dashboards.

I think you’ll find alertmanager more familiar and easier to work with.

---

<div class="post-metadata">

**Author:** ![deepthip](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@deepthip](https://forums.percona.com/u/deepthip)\
**Post date:** [January 27, 2021, 8:35pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/5 "2021-01-27T20:35:09Z")

</div>

Understood. I will try to work on Alertmanager in that case. Would you also please point me to documentation where I can read up on yaml , so I can build my alerts ? I would avoid having build the alerts from scratch and would prefer to just change the thresholds for any pre-built alerts, but looks like that isn’t an option with either of the alerting mechanisms

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [January 28, 2021, 1:35pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/6 "2021-01-28T13:35:03Z")

</div>

I’m unaware of any pre-built alerts. I think you’ll have to write them from scratch.

---

<div class="post-metadata">

**Author:** ![deepthip](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@deepthip](https://forums.percona.com/u/deepthip)\
**Post date:** [January 29, 2021, 11:18pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/7 "2021-01-29T23:18:44Z")

</div>

Thanks mathewb !

In my earlier post I was referring to the method listed here which says this is different from Grafana alerting

> **[Integrated Alerting - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/using/alerting.html)**
>
> Documentation

In trying to set that up, I don’t understand what is the filters field. Can someone please suggest what needs to go in there and its a madatory field

 ![Screen Shot 2021-01-29 at 3.17.20 PM](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c9c356271cc6a5b45bcaa3ac5fac2083809dfe46.jpeg)

---

<div class="post-metadata">

**Author:** ![deepthip](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@deepthip](https://forums.percona.com/u/deepthip)\
**Post date:** [January 29, 2021, 11:19pm UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/8 "2021-01-29T23:19:44Z")

</div>

If that is way to specify which instances the alert should be triggered for like for example , prod, dev, test etc , How do I configure the filters ? Any help is appreciated !!

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [January 11, 2022, 5:11am UTC](https://forums.percona.com/t/mysql-alert-configuration-alerting/8950/9 "2022-01-11T05:11:06Z")

</div>

Hi @deepthip

In the Filters section, you can mention like environment filter like below.

Ex1: environment=prod  
So that you will get specific alerts only Production servers.

Ex1: environment=prod, environment=qa  
So that you will get specific alerts only Production servers and QA servers.
