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.

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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠