Home icon

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
Go to article

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
Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 1
Mar 18
2024
Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 2
Jan 26
2024
Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility)
Feb 29
2024
Implement advanced replication features with Amazon RDS for MySQL and Amazon Aurora MySQL using intermediate replication servers

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.