Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Amazon Aurora Database Engine Updates

Amazon Aurora releases updates regularly. Updates are applied to Amazon Aurora DB clusters during system maintenance windows. The timing when updates are applied depends on the region and maintenance window setting for the DB cluster, as well as the type of update. Updates require a database restart, so you will experience 20 to 30 seconds of downtime, after which you can resume using your DB cluster or clusters. You can view or change your maintenance window settings from the AWS Management Console.

Amazon Aurora Versions

Although Amazon Aurora is a MySQL-compatible database engine, Aurora includes features that are specific to Amazon Aurora and only available to Aurora DB clusters. Aurora versions use the format <major version>.<minor version>.<patch version>. You can get the version of your Aurora instance by querying for the AURORA_VERSION system variable. To get the Amazon Aurora version, use one of the following queries.

Copy
select AURORA_VERSION();
Copy
select @@aurora_version;

Amazon Aurora Database Upgrades (Patching)

When a new minor version of the Amazon Aurora database engine is released, Amazon RDS schedules an automatic upgrade of the Amazon Aurora database engine for all Aurora DB clusters. We announce automatic upgrades in the Amazon RDS Community Forum.

When a new patch version of the Amazon Aurora database engine is released, no automatic upgrade is required. You can choose to upgrade and apply the patch, otherwise the patch will be applied during the next automatic upgrade for a minor version release.

Before automatic upgrade, 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 the automatic 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 RDS console – Log on to the RDS console and choose Clusters. Choose the DB cluster that shows an available maintenance upgrade. Choose Cluster 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 DB Instance and DB Cluster Maintenance and Upgrades.

Aurora Lab Mode

Aurora lab mode is used to enable Aurora features that are available in the current Aurora database version, but are not enabled by default. You can use Aurora lab mode to enable these features in order to test them with instances in your DB cluster prior to using them in a production environment.

To enable Aurora lab mode for a feature, set the aurora_lab_mode parameter to 1 in the parameter group for your primary instance or Aurora Replica. The aurora_lab_mode parameter is an instance-level parameter that is in the default.aurora5.6 parameter group by default. For information on modifying a DB parameter group, see Modifying Parameters in a DB Parameter Group. For information on parameter groups and Amazon Aurora, see DB Cluster and DB Instance Parameters.

Related Topics