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,

gefragt vor einem Jahr232 Aufrufe
1 Antwort
0
Akzeptierte Antwort

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
beantwortet vor einem Jahr
profile pictureAWS
EXPERTE
überprüft vor einem Jahr
  • 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.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen