Besides traditional database engine like PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server, AWS offers a cloud-optimized database engine as well: Amazon Aurora. The main benefits of Aurora are: performance, reliability, and scalability. Because Aurora is a fully managed service there are only a few things you have too keep an eye on. We created a CloudFormation template that you can use to monitor any RDS cluster within a minute.
Each cluster 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 will 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 failover.
We recommend to subscribe to events of the following categories:
- low storage
For each new event, you will receive an alert in Slack.
- Ensure that you selected the AWS region of your monitoring target: the database cluster
- Set the EndpointId parameter to the ID of your endpoint. You can get this value by asking @marbot for it in your Slack channel.
- Set the DBClusterIdentifier parameter to the ID of your RDS database cluster.
- Review the threshold parameters
- Save by clicking the Create button.