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
feita há 6 meses639 visualizações
2 Respostas
0
Resposta aceita

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
ESPECIALISTA
respondido há 6 meses
profile pictureAWS
ESPECIALISTA
avaliado há 6 meses
  • 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
MODERADOR
philaws
respondido há 6 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas