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 個月前檢視次數 638 次
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 個月前

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

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

回答問題指南