Creating an Aurora Serverless v1 DB cluster - Amazon Aurora

Creating an Aurora Serverless v1 DB cluster

When you create an Aurora Serverless v1 DB cluster, you can set the minimum and maximum capacity for the cluster. A capacity unit is equivalent to a specific compute and memory configuration. Aurora Serverless creates scaling rules for thresholds for CPU utilization, connections, and available memory and seamlessly scales to a range of capacity units as needed for your applications. For more information see Aurora Serverless v1 architecture.

You can set the following specific values for your Aurora Serverless v1 DB cluster:

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

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

You can also choose the following optional scaling configuration options:

  • Roll back the capacity change – To cancel capacity changes if Aurora Serverless v1 can't find a scaling point, choose this setting.

    Force the capacity change – To force Aurora Serverless v1 to scale even if it can't find a scaling point before it times out, choose this setting.

    For more information, see Timeout action for capacity changes.

  • Pause compute capacity after consecutive minutes of inactivity – You can choose this setting if you want Aurora Serverless v1 to scale to zero when there's no activity on your DB cluster for an amount of time you specify. With this setting enabled, your Aurora Serverless v1 DB cluster automatically resumes processing and scales to the necessary capacity to handle the workload when database traffic resumes. To learn more, see Pause and resume for Aurora Serverless v1.

Before you can create an Aurora Serverless v1 DB cluster, you need an AWS account. You also need to have completed the setup tasks for working with Amazon Aurora. For more information, see Setting up your environment for Amazon Aurora. You also need to complete other preliminary steps for creating any Aurora DB cluster. To learn more, see Creating an Amazon Aurora DB cluster.

Aurora Serverless v1 is available in certain AWS Regions and for specific Aurora MySQL and Aurora PostgreSQL versions only. For more information, see Aurora Serverless v1.

Note

The cluster volume for an Aurora Serverless v1 cluster is always encrypted. When you create your Aurora Serverless v1 DB cluster, you can't turn off encryption, but you can choose to use your own encryption key.

You can create an Aurora Serverless v1 DB cluster with the AWS Management Console, the AWS CLI, or the RDS API by following the steps below.

To create a new Aurora Serverless v1 DB cluster, you sign in to the AWS Management Console and choose an AWS Region that supports Aurora Serverless v1. Choose Amazon RDS from the AWS Services list, and then choose Create database.

On the Create database page:

  • Choose Standard Create for the database creation method.

  • Choose Amazon Aurora for the Engine type in the Engine options section.

You then choose Amazon Aurora with MySQL compatibility or Amazon Aurora with PostgreSQL compatibility and continue creating the Aurora Serverless v1 DB cluster by using the steps from the following examples. If you choose a version of the DB engine that doesn't support Aurora Serverless v1, the Serverless option doesn't display.

Example for Aurora MySQL

Choose Amazon Aurora with MySQL Compatibility for the Edition. Choose the Aurora MySQL engine you want for your cluster from the Version selector. The following image shows an example.


                        Create Aurora Serverless v1 DB cluster with console

Choose Serverless for the Capacity type.

You can configure the scaling configuration of the Aurora Serverless v1 DB cluster by adjusting values in the Capacity settings section of the page. To learn more about capacity settings, see Autoscaling for Aurora Serverless v1. The following image shows the Capacity settings you can adjust for an Aurora MySQL Serverless DB cluster.


                        Setting capacity for an Aurora MySQL Serverless DB cluster with console

You can also enable the Data API for your Aurora MySQL Serverless DB cluster. Select the Data API checkbox in the Connectivity section of the Create database page. To learn more about the Data API, see Using the Data API for Aurora Serverless.

Example for Aurora PostgreSQL

Choose Amazon Aurora with Postgres; Compatibility for the Edition and select the Version of Aurora PostgreSQL available for Aurora Serverless v1. For more information, see Aurora Serverless v1.


                            Create Aurora PostgreSQL Serverless DB cluster with console

You can configure the scaling configuration of the Aurora Serverless v1 DB cluster by adjusting values in the Capacity settings section of the page. The following image shows the Capacity settings you can adjust for an Aurora PostgreSQL Serverless DB cluster. To learn more about capacity settings, see Autoscaling for Aurora Serverless v1.


                            Setting capacity for an Aurora PostgreSQL Serverless DB cluster with console

You can also enable the Data API for your Aurora PostgreSQL Serverless DB cluster. Select the Data API checkbox in the Connectivity section of the Create database page. See Using the Data API for Aurora Serverless for more information about the Data API.

For more information on creating an Aurora DB cluster using the AWS Management Console, see Creating an Amazon Aurora DB cluster.

Note

If you receive the following error message when trying to create your cluster, your account needs additional permissions.

Unable to create the resource. Verify that you have permission to create service linked role. Otherwise wait and try again later.

See Using service-linked roles for Amazon Aurora for more information.

You can't directly connect to the DB instance on your Aurora Serverless v1 DB cluster. To connect to your Aurora Serverless v1 DB cluster, you use the database endpoint. You can find the endpoint for your Aurora Serverless v1 DB cluster on the Connectivity & security tab for your cluster in the AWS Management Console. For more information, see Connecting to an Amazon Aurora DB cluster.

To create a new Aurora Serverless v1 DB cluster with the AWS CLI, run the create-db-cluster command and specify serverless for the --engine-mode option.

You can optionally specify the --scaling-configuration option to configure the minimum capacity, maximum capacity, and automatic pause when there are no connections.

The following command examples create a new Serverless DB cluster by setting the --engine-mode option to serverless. The examples also specify values for the --scaling-configuration option.

Example for Aurora MySQL

The following commands create new MySQL–compatible Serverless DB clusters. Valid capacity values for Aurora MySQL are 1, 2, 4, 8, 16, 32, 64, 128, and 256.

For Linux, macOS, or Unix:

aws rds create-db-cluster --db-cluster-identifier sample-cluster --engine aurora --engine-version 5.6.10a \ --engine-mode serverless --scaling-configuration MinCapacity=4,MaxCapacity=32,SecondsUntilAutoPause=1000,AutoPause=true \ --master-username username --master-user-password password aws rds create-db-cluster --db-cluster-identifier sample-cluster --engine aurora-mysql --engine-version 5.7.mysql_aurora.2.07.1 \ --engine-mode serverless --scaling-configuration MinCapacity=4,MaxCapacity=32,SecondsUntilAutoPause=1000,AutoPause=true \ --master-username username --master-user-password password

For Windows:

aws rds create-db-cluster --db-cluster-identifier sample-cluster --engine aurora --engine-version 5.6.10a ^ --engine-mode serverless --scaling-configuration MinCapacity=4,MaxCapacity=32,SecondsUntilAutoPause=1000,AutoPause=true ^ --master-username username --master-user-password password aws rds create-db-cluster --db-cluster-identifier sample-cluster --engine aurora-mysql --engine-version 5.7.mysql_aurora.2.07.1 ^ --engine-mode serverless --scaling-configuration MinCapacity=4,MaxCapacity=32,SecondsUntilAutoPause=1000,AutoPause=true ^ --master-username username --master-user-password password

Example for Aurora PostgreSQL

The following command creates a new PostgreSQL 10.12–compatible Serverless DB cluster. Valid capacity values for Aurora PostgreSQL are 2, 4, 8, 16, 32, 64, 192, and 384.

For Linux, macOS, or Unix:

aws rds create-db-cluster --db-cluster-identifier sample-cluster --engine aurora-postgresql --engine-version 10.12 \ --engine-mode serverless --scaling-configuration MinCapacity=8,MaxCapacity=64,SecondsUntilAutoPause=1000,AutoPause=true \ --master-username username --master-user-password password

For Windows:

aws rds create-db-cluster --db-cluster-identifier sample-cluster --engine aurora-postgresql --engine-version 10.12 ^ --engine-mode serverless --scaling-configuration MinCapacity=8,MaxCapacity=64,SecondsUntilAutoPause=1000,AutoPause=true ^ --master-username username --master-user-password password

To create a new Aurora Serverless v1 DB cluster with the RDS API, run the CreateDBCluster operation and specify serverless for the EngineMode parameter.

You can optionally 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.