Assess Health condition following AWS RDS Events

[fogfish]

As a expert user I want to list and filter all events associated with RDS instance so that the availability of these information does not require me to login to AWS console or re-call AWS CLI command.

As a novice user I want to be warned when RDS instance conducted failover operation so that team can conduct the root-cause analysis.

AWS maintains history of "events" about RDS instances. See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html

The tool shall consider failover, backup, etc as a criteria to inform the status. The following events has to be considered:

DB cluster events

• [ ] RDS-EVENT-0072, A failover for the DB cluster has begun within the same Availability Zone.
• [ ] RDS-EVENT-0073, A failover for the DB cluster has begun across Availability Zones.
• [ ] RDS-EVENT-0181, The failover of the global database has started. The process can be delayed because other operations are running on the DB cluster.

DB instance events

• [ ] RDS-EVENT-0006 The DB instance restarted
• [ ] RDS-EVENT-0013 A Multi-AZ failover that resulted in the promotion of a standby instance has started.
• [ ] RDS-EVENT-0089 The DB instance has consumed more than 90% of its allocated storage. You can monitor the storage space for a DB instance using the Free Storage Space metric.
• [ ] RDS-EVENT-0227 The Aurora storage subsystem is running low on space.
• [ ] RDS-EVENT-0026 Offline maintenance of the DB instance is taking place. The DB instance is currently unavailable.
• [ ] RDS-EVENT-0055 The number of tables you have for your DB instance exceeds the recommended best practices for Amazon RDS. Reduce the number of tables on your DB instance.
• [ ] RDS-EVENT-0056 The number of databases you have for your DB instance exceeds the recommended best practices for Amazon RDS. Reduce the number of databases on your DB instance.
• [ ] RDS-EVENT-0189 The gp2 burst balance credits for the RDS database instance are low. To resolve this issue, reduce IOPS usage or modify your storage settings to enable higher performance.