Home icon

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

Database Blog

This article provides a checklist and guidance for upgrading from Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility). The key points are:

Specifically, the article covers:

  • The importance of upgrading before the end of standard support for Aurora MySQL v2 on October 31, 2024, and the benefits of upgrading to v3.
  • Upgrade prechecks run by Aurora to detect incompatibilities, and common issues causing precheck failures:
    • Inconsistent data dictionary or intermediate tables in user schemas
    • Tables with orphaned FULLTEXT indexes
    • Objects using reserved keywords
    • Tables with invalid characters in column definitions
  • Recommended steps to resolve each of the above issues before attempting the upgrade.
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 2
Jan 26
2024
Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility)
Jun 5
2024
Amazon Aurora MySQL 3.07 (compatible with MySQL 8.0.36) is generally available
May 14
2025
Amazon Aurora MySQL 3.09 (compatible with MySQL 8.0.40) 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.