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 年前檢視次數 232 次
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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南