Jun 17, 2024 · Databases

MySQL 5.7‑to‑8.0 Upgrade Plan, Compatibility Checks, and Blue‑Green Deployment on AWS RDS

Facing MySQL 5.7’s February 2024 end‑of‑life, the team devised a zero‑impact blue‑green migration on AWS RDS to MySQL 8.0.35, using util.checkForServerUpgrade() compatibility checks, pt‑upgrade SQL validation, and a rapid 2‑minute switchover that completed within the planned low‑traffic window.

AWS RDSBlue‑Green deploymentCompatibility Check

0 likes · 12 min read

MySQL 5.7‑to‑8.0 Upgrade Plan, Compatibility Checks, and Blue‑Green Deployment on AWS RDS