RDS Events versus CloudWatch Alarms

0

Hi

I have an oracle 19c running on RDS in AWS.

I need to setup some monitoring alarms in case DB goes down, CPU utilization goes over 80%, RDS deletion, etc. and received an email alert.

I noticed AWS has several monitoring tools: RDS Server Events, CloudWatch alarms, Enhanced monitoring and Performance Insights.

How do you know which is the most appropriate to use to setup email alerts or notifications in this case? Are RDS Server events different than cloudwatch alarms?

Thanks,

1개 답변
1
수락된 답변

Hello.

CloudWatch alarms are configured based on RDS CloudWatch metrics.
For example, for CPU usage, set an alarm based on a threshold you set using a metric called "CPUUtilization."
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-metrics.html
https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/AlarmThatSendsEmail.html

RDS server events are a feature that is detected by RDS events.
For example, events such as RDS being restarted or stopped can be detected.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html

So, if you want to receive email notifications when CPU usage exceeds 80%, use CloudWatch alarms.
RDS deletion events can be detected using RDS server events.

profile picture
전문가
답변함 7달 전
  • Great Answer! There is a lot of RDS events and Cloud watch metrics that can be used for monitoring and alarms. Is there an article or link that shows that is the best practice or the standard ones that a DBA should track?

  • I think it's a good idea to decide monitoring items not based on the database you're using, but based on what the application that uses the database does. For example, if your application writes a lot to the database, you may want to monitor "WriteLatency" to see if the write speed is slowing down. Therefore, the monitoring items will change depending on the application you are using, so we recommend consulting with the application creator.

  • I will check with applciation vendor but I really doubt they would tell me what to monitor on the DB side for application. You might have same application in Corp A with 50 users with very low writes and same applicatin in Corp B with 500 users doing a lot of writes. Application Usage might vary from company to another.

  • In that case, I think it's a good idea to decide which metrics to monitor based on the items you value.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠