Set up continuous replication from MySQL 5.7 to MySQL 8 and perform a zero-downtime switchover to MySQL 8 as the primary database.

To upgrade MySQL from 5.7 to 8 while maintaining system availability, we need to:

Configure MySQL 5.7 for replication

Set up MySQL 8 as a replica

Monitor replication

Perform switchover to MySQL 8 (Zero Downtime)

Stop writes to MySQL 5.7

Promote MySQL 8 as primary

Update application connections

Acceptance Criteria

• MySQL 8 replicates all changes from MySQL 5.7
• No data loss or service disruption during migration
• MySQL 8 successfully becomes the primary database

Dependencies

• Confirm compatibility of application queries with MySQL 8
• Ensure MySQL 8 is properly configured and performance-tested