Home icon

Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 2

Database Blog

This article provides guidance on preparing for a major version upgrade from Amazon Aurora MySQL version 2 (MySQL 5.7 compatibility) to version 3 (MySQL 8.0 compatibility). It discusses common issues that can cause prolonged or unsuccessful upgrades and how to mitigate them.

Specifically, the article covers:

  • Handling XA transactions in the prepared state before the upgrade
  • Mitigating the impact of a large number of tables on upgrade duration
  • Addressing a high number of undo records that need to be purged during shutdown
  • Checking for large ongoing write transactions and uncommitted changes before upgrading
  • Identifying and handling long-running or idle transactions that may block the upgrade
  • Concluding with a recommendation to upgrade to Amazon Aurora MySQL v3 before the end-of-life of v2
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
Jan 26
2024
Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility)
May 14
2025
Amazon Aurora MySQL 3.09 (compatible with MySQL 8.0.40) is now generally available
Nov 17
2025
Amazon Aurora MySQL 3.11 (compatible with MySQL 8.0.43) is now generally available

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.