CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-rds
Nfff3
Nfff3

Reputation: 439

How to change master password on AWS RDS without downtime?

So, if I change the master password on my RDS instance, my application which connects to the instance will be down for a couple of minutes until I change the password in it as well. If I do the other way around and change the password in the app first, then the same thing happens. How can I change the master password without causing any downtime?

Also, I am not sure if changing the password takes effect immediately or not. If not, then it would be better to first change the password of the RDS instance and then when it's ready, change the password in the app....

Upvotes: 0

Views: 2889

Answers (1)

Barmar
Barmar

Reputation: 782130

Change the application to try to connect with the new password, and if it fails try the old password.

Then change the RDS password.

Once things are working, you can remove the failover code.

Upvotes: 1

Related Questions