Does changing the storage type of RDS from Provisioned IOPS (io1) to General-purpose SSD (gp3) requires a reboot or downtime?

1

Hi Team,

We are planning to change the storage type of the RDS MySQL instance from Provisioned IOPS (io1) to General-purpose SSD (gp3), so could you please let me know if any reboot or downtime is required? What are the best options available to perform this operation?

The size of the server as of now is 200 GB.

Sravan
質問済み 6ヶ月前639ビュー
2回答
0
承認された回答

Hello.

When using Multi-AZ instances, you can change storage types without downtime.
However, if you are operating in a single AZ, downtime will occur.
https://repost.aws/knowledge-center/rds-mysql-downtime-impact

There's also no downtime when you change the storage type of a Multi-AZ DB instance between General Purpose (SSD) and Provisioned IOPS (SSD). However, there is downtime in the following scenarios:

  • From General Purpose (SSD) to Magnetic, or from Magnetic to General Purpose (SSD).
  • From Provisioned IOPS (SSD) to Magnetic, or from Magnetic to Provisioned IOPS (SSD).
  • From General Purpose (SSD) to Provisioned IOPS (SSD), but only if the DB instance is Single-AZ and you're using a custom parameter group.
  • From Provisioned IOPS (SSD) to General Purpose (SSD), but only if the DB instance is Single-AZ and you're using a custom parameter group.

Follow the steps in the document below to make the changes.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html

profile picture
エキスパート
回答済み 6ヶ月前
profile pictureAWS
エキスパート
レビュー済み 6ヶ月前
  • My RDS is a Multi-AZ instance with a custom DB instance parameter group.

  • I have also verified the downtime when changing the storage type in the past, but in the case of RDS operating in multi-AZ, the change could be made without downtime, so I don't think there will be any problems. The following document states that there may be an impact on performance when changing the storage type, but when I tested it, there was no particularly large impact. This area is likely to change depending on the application using the database, so we recommend verifying it. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#CHAP_Storage.Other.Factors

    The following system-related activities consume I/O capacity and might reduce DB instance performance while in progress:

    • Multi-AZ standby creation
    • Read replica creation
    • Changing storage types
0

There is no downtime when changing the storage type of the RDS MySQL instance from io1 to gp3.

AWS
モデレーター
philaws
回答済み 6ヶ月前

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

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

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

関連するコンテンツ