Research monitor/instrumentation for an RDS

[sudhara]

Overview

As a Developer, I want to know how the RDS monitoring is done to ensure the stability and uptime of the applications using RDS.

Action Items

• Research different tools to monitor RDS usage

AWS RDS Performance Insights, Cloudwatch and RDS Log files.

Setup alerts using AWS SNS monitoring for certain keywords in the log files or filters in the cloudwatch logs.

https://aws.amazon.com/blogs/database/monitor-amazon-rds-for-postgresql-and-amazon-aurora-for-postgresql-database-log-errors-and-set-up-notifications-using-amazon-cloudwatch

• Monitor the database memory, CPU and storage settings and setup alerts if it reaches beyond a threshold value. Refer to the best practices of "Routine vacuuming' for postgres database in AWS

• Research PGSnapper for monitoring postgres RWS database