Change RDS Storage from magnetic to SSD

Question

I am using RDS db.r5.xlarge instance whose storage is 2000 GB . I want to change it to SSD [gp2]. But worried about downtime since its a production server.

Let me know the fastest way to do it without much downtime.

Thank you

Accepted Answer

Look at the use of Read Replicas: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html.
If your DB Engine allows you can use read replicas to copy your production DB.
Manually create read replica from the UI and assign the required storage type.
This would obviously take time and no downtime, but once your new replica is up to speed with the primary instance, kill the primary instance and RDS will automatically select the read replica to be the new primary

Answer

So process would be :
a. Configure a read-replica
b. Kill the primary?  Not sure what that entails...I thought RDS must be in a running state in order to be modified?

c.  After completion of "b" above, then modify the primary to change storage from magnetic to ssd, and apply immediately.
d.  Then I'm unsure what?  How do we get people back onto the primary?
e.  Are there directions on how to un-configure a read-replica setup?

Change RDS Storage from magnetic to SSD

Contenuto pertinente