Amazon Aurora
User Guide for Aurora (API Version 2014-10-31)

Working with Amazon Aurora MySQL

Amazon Aurora MySQL is a fully managed, MySQL-compatible, relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. Aurora MySQL is a drop-in replacement for MySQL and makes it simple and cost-effective to set up, operate, and scale your new and existing MySQL deployments, thus freeing you to focus on your business and applications. Amazon RDS provides administration for Aurora by handling routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair. Amazon RDS also provides push-button migration tools to convert your existing Amazon RDS for MySQL applications to Aurora MySQL.

Upgrading and Patching Amazon Aurora MySQL

To perform a major version upgrade, you can restore a snapshot of a DB cluster and specify a higher major engine version.

When a new minor version or patch version of the Aurora MySQL database engine is released, no automatic upgrade is scheduled. New database engine releases show as an available maintenance upgrade for your DB cluster. You can manually upgrade the database version for your DB cluster by applying the available maintenance action. We encourage you to apply the update on a non-production instance prior to a production upgrade, so that you can see how changes in the new version will affect your instances and applications.

To apply pending maintenance actions

  • By using the Amazon RDS Console – Log on to the Amazon RDS console and choose Clusters. Choose the DB cluster that shows an available maintenance upgrade. Choose Actions. Choose Upgrade now to immediately update the database version for your DB cluster, or Upgrade at next window to update the database version for your DB cluster during the next cluster maintenance window.

  • By using the AWS CLI – Call the apply-pending-maintenance-action AWS CLI command and specify the Amazon Resource Name (ARN) for your DB cluster for the --resource-id option and system-update for the --apply-action option. Set the --opt-in-type option to immediate to immediately update the database version for your DB cluster, or next-maintenance to update the database version for your DB cluster during the next cluster maintenance window.

  • By using the Amazon RDS API – Call the ApplyPendingMaintenanceAction API action and specify the ARN for your DB cluster for the ResourceId parameter and system-update for the ApplyAction parameter. Set the OptInType parameter to immediate to immediately update the database version for your DB cluster, or next-maintenance to update the database version for your instance during the next cluster maintenance window.

For more information on how Amazon RDS manages database and operating system updates, see Maintaining an Amazon Aurora DB Cluster.

Note

If your current Aurora MySQL version is 1.14.x, but it is lower than 1.14.4, you can only upgrade to 1.14.4 (which supports db.r4 instance classes). Also, to upgrade from 1.14.x to a higher major Aurora MySQL version, such as 1.17, the 1.14.x version must be 1.14.4.