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.
To change AZ modify your RDS to multi-az then perform reboot with a failover and modify it back to single-az.
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.
You can create a read replica in the AZ you need, promote it to be the primary and delete the old primary.
