Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
Upgrading Amazon Aurora MySQL global database from 3.07.1 to 3.08
I have an Aurora MySQL global database. All clusters are currently running 3.07.1.
The upgrade to 3.08 is described as a minor upgrade.
When I attempt to follow the process for minor version upgrades on Aurora global databases, I get an error that says:
In-place minor version upgrade of Aurora MySQL global database cluster 'staging-…9' to Aurora MySQL engine version 8.0.mysql_aurora.3.08.0 isn't supported. The selected target version 8.0.mysql_aurora.3.08.0 supports a higher version of community MySQL that introduces changes incompatible with previous minor versions of Aurora MySQL. See the Aurora documentation for how to perform a minor version upgrade on global database clusters.
The documentation for global database upgrades does not make a distinction between in-place and other minor version upgrades, so I'm not sure what process to follow other than these for upgrading Aurora MySQL.
None of the notes that I can find in these documentation pages say that upgrades for the versions in question are prevented.
Should I treat this minor upgrade as a major upgrade? Or is there some other process for minor upgrades on global databases that is appropriate for this particular upgrade?
- Language
- English
- Newest
- Most votes
- Most comments
Based on the error message you received, it appears that the upgrade from Aurora MySQL 3.07.1 to 3.08 for your global database cluster requires a different approach than a standard minor version upgrade, despite being described as a minor upgrade.
The error suggests that version 3.08 introduces changes that are incompatible with previous minor versions, which is why the in-place minor version upgrade is not supported for your global database cluster.
In this case, you should follow a process similar to that used for older versions of Aurora MySQL global databases. Here's the recommended approach:
- Remove all secondary regions from your global cluster.
- Upgrade the engine version of the primary region to 3.08.
- Add the secondary regions back to the global cluster.
This process ensures that the upgrade is performed safely, taking into account the incompatibilities mentioned in the error message.
To perform these steps:
- Follow the procedure for removing secondary regions from your global cluster.
- Once you have only the primary region, use the process for modifying the engine version of a DB cluster to upgrade to version 3.08.
- After the upgrade is complete, add the secondary regions back to your global cluster.
While this process is more involved than a typical minor version upgrade, it's necessary to ensure the stability and compatibility of your global database cluster given the specific changes introduced in version 3.08.
Remember to perform these operations during a maintenance window or period of low activity, and ensure you have recent backups before proceeding with the upgrade.
Sources
Upgrading Aurora MySQL by modifying the engine version - Amazon Aurora
Amazon Aurora MySQL 3.08 (compatible with MySQL 8.0.39) is generally available - AWS
Relevant content
- AWS OFFICIALUpdated 5 months ago
