Is it disk-intensive RDS MySQL community 8.0.23 to 8.0.28 minor version upgrade?

0

Hi, I have db.r5.xlarge(RDS MySQL 8.0.23) RDS instance, I would like to upgrade to 8.0.28 using inplace upgrade. I have tested the upgrade from 8.0.23 to 8.0.28 in development instance(db.t3.medium), and it takes about 10 minutes. I wonder is it disk-intensive on this upgrade, 'cause our development instance has rather small data size other than production environment. Thanks,

asked a year ago212 views
1 Answer
0
Accepted Answer

It really depends on the data and schema in your database. Typically a minor version upgrade should not have high io requirements but there is no way to say for sure. You could consider the following: restore a snapshot of your production database and test the upgrade there to find out. Or you could look into the new feature Blue Green Deployments. This will create a replica of your environment and run the upgrade on that (green) environment. Then you can perform the switchover to the new environment after the upgrade is all complete and the new target environment is all ready to go.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html

hth, Phil

AWS
MODERATOR
philaws
answered a year ago
profile pictureAWS
EXPERT
reviewed a year ago
  • Thank you for your answer, I'll create a test DB instance from Production data snapshot and test the upgrade.

  • We've tested the upgrade with a created copy of production database, and found it takes about 10 minutes as same of development environment. Thank you.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions