Change RDS Storage from magnetic to SSD

0

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

2 Answers
1
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

AWS
Nuno_Q
answered 2 years ago
  • Thanks a lot @Nuno_Q

    Any idea how long would it take, since its been 13 hrs

0

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?

Vic
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions