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,

已提问 1 年前238 查看次数
1 回答
0
已接受的回答

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
审核人员
philaws
已回答 1 年前
profile pictureAWS
专家
已审核 1 年前
  • 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.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则