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回答
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.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ