Perform cross-account major version upgrades from Amazon RDS for MySQL 5.7 to Amazon Aurora 3.04.x with minimum downtime
Database Blog
This article provides a step-by-step guide on how to perform a cross-account major version upgrade from Amazon RDS for MySQL 5.7 to Amazon Aurora 3.04.x (compatible with MySQL 8.0.x) with minimal downtime.
Specifically, the article covers:
- Solution overview and benefits of upgrading to Aurora
- Prerequisites and pre-migration tasks
- Sharing a snapshot to the target account
- Restoring the RDS for MySQL instance from the snapshot
- Creating an Aurora read replica from the RDS instance
- Promoting the Aurora read replica to a standalone DB cluster
- In-place upgrade of the Aurora cluster from 2.07.8 to 3.04.x
- Configuring an AWS DMS CDC (Change Data Capture) replication task
- Monitoring replication lag and cutover to the target Aurora cluster
- Clean up steps after migration
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Mar 18
2024
2024
Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 1
Jan 26
2024
2024
Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility)
Feb 25
2025
2025
Perform minor/major version upgrades for Amazon Aurora MySQL Global Database with minimum downtime
Jun 17
2026
2026
Amazon Aurora and RDS for MySQL expand Extended Support for MySQL 5.7 through June 2029
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.