The database is a critical component of each system that needs monitoring. Amazon RDS provides PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server as a Service. Monitoring an RDS database instance touches multiple parts of AWS. We created a CloudFormation template that you can use to monitor any RDS database instance in a minute.
Each database instance sends metrics to CloudWatch that we can observe with CloudWatch Alarms. We recommend to create alarms for the following metrics:
If a metric crosses the alarm’s threshold, you receive an alert in Slack.
Besides metrics, RDS sends out events if the state of the database instance has changed. E.g., because of a Multi-AZ failover.
We recommend to subscribe to events of the following categories:
- low storage
For each new event, you receive an alert in Slack.
- Create the CloudFormation stack with a single click
- Ensure that you selected the AWS region of your database instance monitoring target
- Set the EndpointId parameter to the ID of your endpoint. You can get this value by asking @marbot for it on your Slack channel.
- Set the DBInstanceIdentifier parameter to the ID of your RDS database instance.
- Review the threshold parameters
- Save by clicking the Create button.