How to setup Cloudwatch SQL monitor?

Question

I have a view on a PostgreSQL RDS instance that lists any ongoing deadlocks. Ideally, there are no deadlocks in the database, causing the view to show nothing, but on rare occasions, there are.

How would I setup an alarm in Cloudwatch to query this view and raise an alarm if any records return?

Answer 1

I found the cool script on Github specifically for this:

A Serverless MySQL RDS Data Collection script to push Custom Metrics to CloudWatch on AWS

---

Basically, there are 2 main possibilities to publish any custom metrics on CloudWatch:

• Via API

  You can run it on a schedule on EC2 instance (AWS example) or as a lambda function (great manual with code examples)

• With CloudWatch agent

  Here is the pretty example for Monitor your Microsoft SQL Server using custom metrics with Amazon CloudWatch and AWS Systems Manager.

---

After all, you should set up CloudWatch alarms with Metric Math and relevant thresholds.

---

Answer 2

It is not possible to configure Amazon CloudWatch to look inside an Amazon RDS database.

You will need some code running somewhere that regularly runs a query on the database and sends a custom metric to Amazon CloudWatch.

For example, you could trigger an AWS Lambda function, or use cron on an Amazon EC2 instance to trigger a script.