Upgrading an Amazon Aurora global database - Amazon Aurora

Upgrading an Amazon Aurora global database

Upgrading an Aurora global database follows the same procedures as upgrading Aurora DB clusters. However, following are some important differences to take note of before you start the process.

We recommend that you upgrade the primary and secondary DB clusters to the same version. You can only perform a managed cross-Region database failover on an Aurora global database if the primary and secondary DB clusters have the same major, minor, and patch level engine versions. However, the patch levels can be different, depending on the minor engine version. For more information, see Patch level compatibility for managed cross-Region switchovers and failovers.

Major version upgrades

When you perform a major version upgrade of an Amazon Aurora global database, you upgrade the global database cluster instead the individual clusters that it contains.

To learn how to upgrade an Aurora PostgreSQL global database to a higher major version, see Major upgrades for global databases.

Note

With an Aurora global database based on Aurora PostgreSQL, you can't perform a major version upgrade of the Aurora DB engine if the recovery point objective (RPO) feature is turned on. For information about the RPO feature, see Managing RPOs for Aurora PostgreSQL–based global databases.

To learn how to upgrade an Aurora MySQL global database to a higher major version, see In-place major upgrades for global databases.

Note

With an Aurora global database based on Aurora MySQL, you can't perform an in-place upgrade from Aurora MySQL version 2 to version 3 if the lower_case_table_names parameter is turned on.

To perform a major version upgrade to Aurora MySQL version 3 when using lower_case_table_names, use the following process:

  1. Remove all secondary Regions from the global cluster. Follow the steps in Removing a cluster from an Amazon Aurora global database.

  2. Upgrade the engine version of the primary Region to Aurora MySQL version 3. Follow the steps in How to perform an in-place upgrade.

  3. Add secondary Regions to the global cluster. Follow the steps in Adding an AWS Region to an Amazon Aurora global database.

You can also use the snapshot restore method instead. For more information, see Restoring from a DB cluster snapshot.

Minor version upgrades

For a minor upgrade on an Aurora global database, you upgrade all of the secondary clusters before you upgrade the primary cluster.

To learn how to upgrade an Aurora PostgreSQL global database to a higher minor version, see How to perform minor version upgrades and apply patches. To learn how to upgrade an Aurora MySQL global database to a higher minor version, see Upgrading Aurora MySQL by modifying the engine version.

Before you perform the upgrade, review the following considerations:

  • Upgrading the minor version of a secondary cluster doesn't affect availability or usage of the primary cluster in any way.

  • A secondary cluster must have at least one DB instance to perform a minor upgrade.

  • If you upgrade an Aurora MySQL global database to version 2.11.*, you must upgrade your primary and secondary DB clusters to the exact same version, including the patch level.

  • To support managed cross-Region switchovers or failovers, you might need to upgrade your primary and secondary DB clusters to the exact same version, including the patch level. This requirement applies to Aurora MySQL and some Aurora PostgreSQL versions. For a list of versions that allow switchovers and failovers between clusters running different patch levels, see Patch level compatibility for managed cross-Region switchovers and failovers.

Patch level compatibility for managed cross-Region switchovers and failovers

If your Aurora Global Database is running one one of the following minor engine versions, you can perform managed cross-Region switchovers or failovers even if the patch levels of your primary and secondary DB clusters don't match. For minor engine versions lower than the ones on this list, your primary and secondary DB clusters must be running the same major, minor, and patch levels to perform managed cross-Region switchovers or failovers. Make sure to review the version information and the notes in the following table when planning upgrades for your primary cluster, secondary clusters, or both.

Note

For manual cross-Region failovers, you can perform the failover process as long as the target secondary DB cluster is running the same major and minor engine version as the primary DB cluster. In this case, the patch levels don't need to match.

If your engine versions require identical patch levels, you can perform the failover manually by following the steps in Performing manual failovers for Aurora global databases.

Database engine Minor engine versions Notes

Aurora MySQL

No minor versions

None of the Aurora MySQL minor versions allow managed cross-Region switchovers or failovers with differing patch levels between the primary and secondary DB clusters.

Aurora PostgreSQL

  • Version 15 or higher major versions

  • Version 14.5 or higher minor versions

  • Version 13.8 or higher minor versions

  • Version 12.12 or higher minor versions

  • Version 11.17 or higher minor versions

With the engine versions listed in the previous column, you can perform managed cross-Region switchovers or failovers from a primary DB cluster with one patch level to a secondary DB cluster with a different patch level.

With minor versions lower than these, you can perform managed cross-Region switchovers or failovers only if the patch levels of the primary and secondary DB clusters match.