Restoring a DB instance or a Multi-AZ DB cluster with Amazon RDS Extended Support - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Restoring a DB instance or a Multi-AZ DB cluster with Amazon RDS Extended Support

When you restore a DB instance or a Multi-AZ DB cluster, select Enable RDS Extended Support in the console, or use the Extended Support option in the Amazon CLI or the parameter in the RDS API. When you enroll a DB instance or Multi-AZ DB cluster in RDS Extended Support, it is permanently enrolled in RDS Extended Support for the life of the DB instance or Multi-AZ DB cluster.

The default for the RDS Extended Support setting depends on whether you use the console, the Amazon CLI, or the RDS API to restore your database. If you use the console, you don't select Enable RDS Extended Support, and the major engine version you are restoring is past the RDS end of standard support, then Amazon RDS automatically upgrades your DB instance to a newer engine version. If you use the Amazon CLI or the RDS API and you don't specify the RDS Extended Support setting, then Amazon RDS defaults to enabling RDS Extended Support. When you automate by using Amazon CloudFormation or other services, this default behavior maintains the availability of your database past the RDS end of standard support date. You can disable RDS Extended Support by using the Amazon CLI or the RDS API.

RDS Extended Support behavior

The following table summarizes what happens when a major engine version of a DB instance or a Multi-AZ DB cluster that you are restoring has reached the RDS end of standard support.

RDS Extended Support status* Behavior

Enabled

Amazon RDS charges you for RDS Extended Support.

Disabled**

After the restore finishes, Amazon RDS automatically upgrades your DB instance or Multi-AZ DB cluster to a newer engine version (in a future maintenance window).

* In the RDS console, the RDS Extended Support status appears as Yes or No. In the Amazon CLI or RDS API, the RDS Extended Support status appears as open-source-rds-extended-support or open-source-rds-extended-support-disabled.

** This option is only available when restoring a DB instance or a Multi-AZ DB cluster running PostgreSQL 12 and higher or MySQL 8 and higher.

Considerations for RDS Extended Support

Before restoring a DB instance or a Multi-AZ DB cluster, consider the following items:

  • After the RDS end of standard support date has passed, if you want to restore a DB instance or a Multi-AZ DB cluster from Amazon S3, you can only do so by using the Amazon CLI or the RDS API. Use the --engine-lifecycle-support option in the restore-db-cluster-from-s3 Amazon CLI command or the EngineLifecycleSupport parameter in the RestoreDBClusterFromS3 RDS API operation.

  • If you want to prevent RDS from restoring your databases to RDS Extended Support versions, specify open-source-rds-extended-support-disabled in the Amazon CLI or the RDS API. By doing so, you will avoid any associated RDS Extended Support charges.

    If you specify this setting, Amazon RDS will automatically upgrade your restored database to a newer, supported major version. If the upgrade fails pre-upgrade checks, Amazon RDS will safely roll back to the RDS Extended Support engine version. This database will remain in RDS Extended Support mode, and Amazon RDS will charge you for RDS Extended Support until you manually upgrade your database.

    For example, if you restore a MySQL 5.7 snapshot without using RDS Extended Support, Amazon RDS will attempt to automatically upgrade your database to MySQL 8.0. If this upgrade fails due to an issue that you need to resolve, Amazon RDS will roll back the database to MySQL 5.7. Amazon RDS will keep the database on RDS Extended Support until you can fix the issue. For example, an upgrade might fail due to insufficient storage space. After you fix the issue, you must initiate the upgrade. After the first attempt to upgrade your database, Amazon RDS won't attempt to upgrade it again.

  • RDS Extended Support is set at the cluster level. Members of a cluster will always have the same setting for RDS Extended Support in the RDS console, --engine-lifecycle-support in the Amazon CLI, and EngineLifecycleSupport in the RDS API.

For more information, see MySQL versions and Release calendars for Amazon RDS for PostgreSQL.

Restore a DB instance or a Multi-AZ DB cluster with RDS Extended Support

You can restore a DB instance or a Multi-AZ DB cluster with an RDS Extended Support version using the Amazon Web Services Management Console, the Amazon CLI, or the RDS API.

When you restore a DB instance or a Multi-AZ DB cluster, select Enable RDS Extended Support in the Engine options section. If you don't select this setting and the major engine version that you are restoring is past the RDS end of standard support, then Amazon RDS automatically upgrades your DB instance or Multi-AZ DB cluster to a version under RDS standard support.

The following image shows the Enable RDS Extended Support setting:

The Enable RDS Extended Support setting in the Engine options section.

When you run the restore-db-instance-from-db-snapshot or restore-db-cluster-from-snapshot Amazon CLI command, select RDS Extended Support by specifying open-source-rds-extended-support for the --engine-lifecycle-support option.

If you want to avoid charges associated with RDS Extended Support, set the --engine-lifecycle-support option to open-source-rds-extended-support-disabled. By default, this option is set to open-source-rds-extended-support.

You can also specify this value using the following Amazon CLI commands:

When you use the RestoreDBInstanceFromDBSnapshot or RestoreDBClusterFromSnapshot Amazon RDS API operation, select RDS Extended Support by setting the EngineLifecycleSupport parameter to open-source-rds-extended-support.

If you want to avoid charges associated with RDS Extended Support, set the EngineLifecycleSupport parameter to open-source-rds-extended-support-disabled. By default, this parameter is set to open-source-rds-extended-support.

You can also specify this value using the following RDS API operations:

For more information about restoring a DB instance or a Multi-AZ DB cluster, follow the instructions for your DB engine in Restoring to a DB instance.