Modifying an Aurora Serverless v1 DB cluster - Amazon Aurora
Modifying the scaling configurationConverting from Aurora Serverless v1 to provisioned
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).

Modifying an Aurora Serverless v1 DB cluster

After you configure an Aurora Serverless v1 DB cluster, you can modify certain properties with the Amazon Web Services Management Console, the Amazon CLI, or the RDS API. Most of the properties you can modify are the same as for other kinds of Aurora clusters.

The most relevant changes for Aurora Serverless v1 are the following:

Modifying the scaling configuration of an Aurora Serverless v1 DB cluster

You can set the minimum and maximum capacity for the DB cluster. Each capacity unit is equivalent to a specific compute and memory configuration. Aurora Serverless automatically creates scaling rules for thresholds for CPU utilization, connections, and available memory. You can also set whether Aurora Serverless pauses the database when there's no activity and then resumes when activity begins again.

You can set the following specific values for the scaling configuration:

  • Minimum Aurora capacity unit – Aurora Serverless can reduce capacity down to this capacity unit.

  • Maximum Aurora capacity unit – Aurora Serverless can increase capacity up to this capacity unit.

  • Autoscaling timeout and action – This section specifies how long Aurora Serverless waits to find a scaling point before timing out. It also specifies the action to take when a capacity modification times out because it can't find a scaling point. Aurora can force the capacity change to set the capacity to the specified value as soon as possible. Or, it can roll back the capacity change to cancel it. For more information, see Timeout action for capacity changes.

  • Pause after inactivity – Use the optional Scale the capacity to 0 ACUs when cluster is idle setting to scale the database to zero processing capacity while it's inactive. When database traffic resumes, Aurora automatically resumes processing capacity and scales to handle the traffic.

You can modify the scaling configuration of an Aurora DB cluster with the Amazon Web Services Management Console.

To modify an Aurora Serverless v1 DB cluster

  1. Open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the navigation pane, choose Databases.

  3. Choose the Aurora Serverless v1 DB cluster that you want to modify.

  4. For Actions, choose Modify cluster.

  5. In the Capacity settings section, modify the scaling configuration.

  6. Choose Continue.

  7. On the Modify DB cluster page, review your modifications, then choose when to apply them.

  8. Choose Modify cluster.

To modify the scaling configuration of an Aurora Serverless v1 DB cluster using the Amazon CLI, run the modify-db-cluster Amazon CLI command. Specify the --scaling-configuration option to configure the minimum capacity, maximum capacity, and automatic pause when there are no connections. Valid capacity values include the following:

  • Aurora MySQL: 1, 2, 4, 8, 16, 32, 64, 128, and 256.

  • Aurora PostgreSQL: 2, 4, 8, 16, 32, 64, 192, and 384.

In this example, you modify the scaling configuration of an Aurora Serverless v1 DB cluster named sample-cluster.

For Linux, macOS, or Unix:

aws rds modify-db-cluster \
    --db-cluster-identifier sample-cluster \
    --scaling-configuration MinCapacity=8,MaxCapacity=64,SecondsUntilAutoPause=500,TimeoutAction='ForceApplyCapacityChange',AutoPause=true

For Windows:

aws rds modify-db-cluster ^
    --db-cluster-identifier sample-cluster ^
    --scaling-configuration MinCapacity=8,MaxCapacity=64,SecondsUntilAutoPause=500,TimeoutAction='ForceApplyCapacityChange',AutoPause=true

You can modify the scaling configuration of an Aurora DB cluster with the ModifyDBCluster API operation. Specify the ScalingConfiguration parameter to configure the minimum capacity, maximum capacity, and automatic pause when there are no connections. Valid capacity values include the following:

  • Aurora MySQL: 1, 2, 4, 8, 16, 32, 64, 128, and 256.

  • Aurora PostgreSQL: 2, 4, 8, 16, 32, 64, 192, and 384.

Converting an Aurora Serverless v1 DB cluster to provisioned

You can convert an Aurora Serverless v1 DB cluster to a provisioned DB cluster. To perform the conversion, you change the DB instance class to Provisioned. You can use this conversion as part of upgrading your DB cluster from Aurora Serverless v1 to Aurora Serverless v2. For more information, see Upgrading from an Aurora Serverless v1 cluster to Aurora Serverless v2.

The conversion process creates a reader DB instance in the DB cluster, promotes the reader instance to a writer instance, and then deletes the original Aurora Serverless v1 instance. When you convert the DB cluster, you can't perform any other modifications at the same time, such as changing the DB engine version or DB cluster parameter group. The conversion operation is applied immediately, and can't be undone.

During the conversion, a backup DB cluster snapshot is taken of the DB cluster in case an error occurs. The identifier for the DB cluster snapshot has the form pre-modify-engine-mode-DB_cluster_identifier-timestamp.

Aurora uses the current default DB minor engine version for the provisioned DB cluster.

If you don't provide a DB instance class for your converted DB cluster, Aurora recommends one based on the maximum capacity of the original Aurora Serverless v1 DB cluster. The recommended capacity to instance class mappings are shown in the following table.

Serverless maximum capacity (ACUs) Provisioned DB instance class
1 db.t3.small
2 db.t3.medium
4 db.t3.large
8 db.r5.large
16 db.r5.xlarge
32 db.r5.2xlarge
64 db.r5.4xlarge
128 db.r5.8xlarge
192 db.r5.12xlarge
256 db.r5.16xlarge
384 db.r5.24xlarge
Note

Depending on the DB instance class you choose, and your database usage, you might see different costs for a provisioned DB cluster compared to Aurora Serverless v1.

If you convert your Aurora Serverless v1 DB cluster to a burstable (db.t*) DB instance class, you might incur additional costs for using the DB cluster. For more information, see DB instance class types.

To convert an Aurora Serverless v1 DB cluster to a provisioned cluster, run the modify-db-cluster Amazon CLI command.

The following parameters are required:

  • --db-cluster-identifier – The Aurora Serverless v1 DB cluster that you're converting to provisioned.

  • --engine-mode – Use the value provisioned.

  • --allow-engine-mode-change

  • --db-cluster-instance-class – Choose the DB instance class for the provisioned DB cluster based on the capacity of the Aurora Serverless v1 DB cluster.

In this example, you convert an Aurora Serverless v1 DB cluster named sample-cluster and use the db.r5.xlarge DB instance class.

For Linux, macOS, or Unix:

aws rds modify-db-cluster \
    --db-cluster-identifier sample-cluster \
    --engine-mode provisioned \
    --allow-engine-mode-change \
    --db-cluster-instance-class db.r5.xlarge

For Windows:

aws rds modify-db-cluster ^
    --db-cluster-identifier sample-cluster ^
    --engine-mode provisioned ^
    --allow-engine-mode-change ^
    --db-cluster-instance-class db.r5.xlarge

To convert an Aurora Serverless v1 DB cluster to a provisioned cluster, use the ModifyDBCluster API operation.

The following parameters are required:

  • DBClusterIdentifier – The Aurora Serverless v1 DB cluster that you're converting to provisioned.

  • EngineMode – Use the value provisioned.

  • AllowEngineModeChange

  • DBClusterInstanceClass – Choose the DB instance class for the provisioned DB cluster based on the capacity of the Aurora Serverless v1 DB cluster.