I'm planning to upgrade my MySQL RDS instance from version 5.7.44 to 8.4.7 using a Blue-Green deployment strategy. I know I'm skipping version 8.0, but I think it should still work since I've seen it successful with Postgres upgrades. However, I'm looking for some insights on what potential issues I should watch out for during this upgrade. Has anyone gone through a similar upgrade process on RDS MySQL? Any tips?
4 Answers
You might want to check out some specific AWS resources; they have a lot of relevant information on database upgrades. Here are a few links that could help: 1. AWS Databases Overview, 2. RDS Specifics, 3. DynamoDB, 4. Aurora, 5. Redshift, and 6. DocumentDB. These could provide you insights into common issues and helpful tips for your upgrade.
My team is currently doing a similar upgrade, and we managed to transition from 5 to 8 without any major hiccups. We took it step-by-step, first moving to 8.0 before jumping to 8.4. It wasn’t as tough as we feared.
How are you planning to sync the database during the switch? That could be crucial for a smooth transition.
Just curious, is there a specific reason you didn’t consider a direct upgrade from 5.7 to 8.4 since you're using the Blue-Green strategy?
Related Questions
How To Get Your Domain Unblocked From Facebook
How To Find A String In a Directory of Files Using Linux