How to upgrade RDS to "RDS Optimized Writes" with the minimum downtime?


I have RDS MySQL 8 server, recently upgraded to db.r6d instance. Now I'd like to activate "RDS Optimized Writes". I saw that it's possible to do this using either Blue/Green deployment and read slave. But I'm not sure which path is optimal for minimizing downtime? For instance I have experience with RDS Multi-AZ config and I know that failover takes up to 1-2 minutes. But what about Blue/Green?

asked 24 days ago69 views
1 Answer

is that mean that you want to activate Aurora I/O-Optimized?
if the anser is yes, there is FAQ[1] about it.

How do I migrate my existing database cluster to use Aurora I/O-Optimized?

You can use the one-click experience available in the AWS Management Console to change the storage type of your existing database clusters to be Aurora I/O-Optimized. You can also invoke the AWS Command Line Interface (AWS CLI) or AWS SDK to make this change.

Can I switch back and forth between Aurora I/O-Optimized and Aurora Standard configuration?
You can switch your existing database clusters once every 30 days to Aurora I/O-Optimized. You can switch back to Aurora Standard at any time.


also the below question might be help.

Enabling RDS Optimized Writes on an existing database

answered 24 days ago
  • Thank you! I have MySQL RDS, not Aurora.

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