How to change a RDS availability zone to a different one within the same region on AWS?

Issue

I currently have a EC2 instance working with an MySQL RDS database. They are both in the same region, but in different availability zones. Currently my application is experiencing a bit of lag, and it is my intuition that it is due to this.

How can I change the AZ of my RDS database to speed up my application?

Locally I am running the same application and it is significantly faster.

Solution

If your application is read heavy, you can add more reader endpoints in other AZs.

If your RDS is single instance and in the different AZ to your EC2 instance, you will need to take a snapshot and create the instance again in order to change the availability zone.

Answered By – Arun Kamalanathan

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published