MySQL Alert configuration - Alerting

Percona Monitoring and Management (PMM) PMM 2.x
1

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
Screen Shot 2021-01-26 at 2.53.11 PM3550×1648 162 KB

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

2
1 Like
3

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

1 Like
4

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

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

1 Like
5

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

1 Like
6

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

1 Like
7

Thanks mathewb !

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

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
Screen Shot 2021-01-29 at 3.17.20 PM3516×2022 245 KB

1 Like
8

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 !!

1 Like
9

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.

1 Like