What’s the safest way to upgrade Amazon RDS MySQL 8.0 before extended support charges begin?

0
10
Asked By MellowCedar42 On

Amazon RDS MySQL 8.0 standard support ends on July 31. Starting August 1, instances that remain on MySQL 8.0 will automatically enter paid extended support unless you explicitly disable it. In us-east-1, the initial charge is $0.10 per vCPU-hour and increases in later years, which could add roughly $292 per month for a Multi-AZ db.r5.large.

The databases most likely to be missed are idle development and staging instances. They may continue running normally, but their costs will increase. There is an engine-lifecycle-support setting that can prevent automatic enrollment, although those instances will no longer receive patches after the cutoff, so that option is better suited to disposable environments.

Has anyone completed the MySQL 8.0 to 8.4 upgrade? Was an in-place upgrade or a blue/green deployment smoother, and did you encounter any application compatibility issues?

2 Answers

Answered By VelvetRook19 On

Blue/green worked very well for us too. The cutover was effectively zero-downtime, and we didn’t run into any significant problems during the upgrade.

Answered By OrbitingPanda7 On

We had around 20 databases owned by different teams, so we used blue/green deployments throughout. For each development environment, we created a small temporary instance and tested whether the application worked correctly on the newer MySQL version. That made the final cutover straightforward with almost no downtime and no major surprises.

Related Questions

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.