I've run into a bit of a snag with AWS RDS. I'm being prompted to upgrade my SQL version to 8.4 with a single click, but it seems like there's no way to revert back afterward unless the upgrade fails, which isn't very helpful. I'm really at a loss here—what can I do if the upgrade doesn't work out? Testing this would mean replicating my entire environment, and that seems like way too much work.
3 Answers
Consider using a blue-green deployment strategy. This way, you can run two versions of your database simultaneously and switch over if something goes wrong.
One solid option is to restore a backup to a new instance and perform the upgrade there. That way, your original instance remains untouched, and you can test the new version thoroughly before rolling it out to production. It’s a great way to minimize risks during major upgrades.
You really should have a separate testing environment to try out significant changes like this. If you can’t set that up, you'll be taking a big risk by upgrading. Just remember, if you do have to switch back after an upgrade failure, you might lose any new data written to the upgraded database.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures