Monitoring AWS RDS

• Lets create an free tier rds instance
• AWS provides multiple ways of monitoring databases running on RDS.
• Basic monitoring is called as standard monitoring & if you want to opt for granular details, you can go for advanced monitoring.
• RDS sends all the information for these metrics to AWS CloudWatch which we can view using RDS console or AWS CloudWatch console
• Standard Monitoring:
  • Using Standard Monitoring you can access 15 to 18 metrics depending on RDBMS Engine. The common ones are CPU Utilization, Storage, memory, swap usage, database connections, I/O, latency, throughput, replica lag and so on.
  • Using standard monitoring you can get metrics at one-minute intervals
• Enhanced Monitoring:
  • If you want granular metrics, the you can opt for enhanced monitoring.
  • Using enhanced monitoring, you can access 37 more metrics in addition to standard monitoring, making a total of more than 50 metrics.
  • You can also get the metrcis as low as one-secodnd interval.
  • We can modify the existing database and enable enhanced monitoring or we can set this while creating rds
• Event Notifications:
  • Using Event notifications in RDS, you can quickly get visibility into whats going on in your RDS instances.
  • The event notifications allow you get notifications via AWS SNS when events occur in RDS.
  • There are 17 different categories of events that you can choose from such as
    • availability
    • backup
    • configuration change
    • creation
    • deletion
    • failure
    • failover
    • maintenance
    • recovery
    • restoration
    • …
  • You can choose to get notified on the occurances of those events
  • Modify any thing in your database
• Performance Insights:
  • Performance Insights expands on existing RDS monitoring features to illustrate your databases performance & helps you manage any issues that impact it.
  • With the Performance Insights dashboard, you can visualize the database load & filter the load by waits, SQL statements, hosts or users