Objective:
Perform a major version upgrade of a production RDS database (from MySQL 5.7 to 8.0) with zero downtime using a blue-green deployment strategy in AWS.
Summary:
- Web application hosted on AWS PaaS using a single RDS instance running MySQL 5.7 (extended support).
- Designed a blue-green migration plan to simulate and validate the upgrade before switching live traffic.
- Created a green RDS instance with MySQL 8.0, restored from a snapshot of the blue (existing) production DB.
- Tested the application against the green environment and validated query compatibility, latency, and performance.
- Performed DNS switch to redirect traffic after successful validation.
Key Highlights:
- Used RDS snapshots to build a rollback path in case of failure
- Achieved zero downtime without a Multi-AZ setup
- Monitored performance pre/post-migration using Amazon CloudWatch
Skills Demonstrated: AWS RDS | MySQL | Blue-Green Deployment | CloudWatch | DNS Failover | Zero-Downtime Upgrade | PaaS Architecture
Lab Status: Completed