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

Amazon Aurora MySQL Database Engine Updates

Amazon Aurora releases updates regularly. Updates are applied to 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 compatible with the MySQL and PostgreSQL database engines, 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.

Database Engine Queries

MySQL

Copy
select AURORA_VERSION();

MySQL

Copy
select @@aurora_version;

PostgreSQL

Copy
SELECT AURORA_VERSION();

Amazon Aurora Database Upgrades (Patching)

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

When a new patch version of the Aurora MySQL 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 Amazon RDS Console – Log on to the Amazon 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.

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. While Aurora lab mode features are not recommended for use in production DB clusters, you can use Aurora lab mode to enable these features for DB clusters in your development and test environments. For more information about Aurora features available when Aurora lab mode is enabled, see Aurora Lab Mode Features.

To enable Aurora lab mode, 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 Amazon Aurora MySQL Parameters.

Related Topics