RDS DB- upgrade instance

Question

We have in our system a RDS cluster with one writer and one reader instance(Aurora MySQL) 
Lately we have a live issue where the writer was overloaded (CPUUtilization) and we decided to upgrade our instances from r5.xl to r5.2xl 
We decide to upgrade the reader first and then failover to the upgraded reader
I have two Q regards the upgrade process:
1. Is there a place where we can see the logs containing this upgrade event (including the upgrade time etc.)?
2. The upgrade process took us a long time, while we are in a live issue and DB is down. Is there a way to make the upgrade process faster?

Answer

Hello,

Hope you are well. Please find my response below!

1. Is there a place where we can see the logs containing this upgrade event (including the upgrade time etc.)?

You can calculate the timing from the RDS instance events from when it is started and when it is completed.

2. The upgrade process took us a long time, while we are in a live issue and DB is down. Is there a way to make the upgrade process faster?

There is no straight forward answer for this since the upgrade time can vary due to various reasons and whether we can make it faster or not would be based on why it is taking time. My advise would be to perform dry run upgrade in the clone and compare the timing if it is common, otherwise create a support case with AWS support where the support engineer will be able to check from the backend and advise.

RDS DB- upgrade instance

Relevant content