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
posta 6 mesi fa639 visualizzazioni
2 Risposte
0
Risposta accettata

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
ESPERTO
con risposta 6 mesi fa
profile pictureAWS
ESPERTO
verificato 6 mesi fa
  • 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
MODERATORE
philaws
con risposta 6 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande