2 Answers
- Newest
- Most votes
- Most comments
1
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
0
There is no downtime when changing the storage type of the RDS MySQL instance from io1 to gp3.
Relevant content
- asked a year ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
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