Tutorial: Create a VPC for use with a DB cluster (dual-stack mode) - Amazon Aurora
Create a VPC with private and public subnetsCreate a VPC security group for a public Amazon EC2 instance Create a VPC security group for a private DB clusterCreate a DB subnet groupCreate an Amazon EC2 instance in dual-stack modeCreate a DB cluster in dual-stack modeConnect to your Amazon EC2 instance and DB clusterDeleting the VPC

Tutorial: Create a VPC for use with a DB cluster (dual-stack mode)

A common scenario includes a DB cluster in a virtual private cloud (VPC) based on the Amazon VPC service. This VPC shares data with a public Amazon EC2 instance that is running in the same VPC.

In this tutorial, you create the VPC for this scenario that works with a database running in dual-stack mode. Dual-stack mode to enable connection over the IPv6 addressing protocol. For more information about IP addressing, see Amazon Aurora IP addressing.

Dual-stack network clusters are supported in most regions. For more information see Availability of dual-stack network DB clusters. To see the limitations of dual-stack mode, see Limitations for dual-stack network DB clusters.

The following diagram shows this scenario.

VPC scenario for dual-stack mode

For information about other scenarios, see Scenarios for accessing a DB cluster in a VPC.

Your DB cluster needs to be available only to your Amazon EC2 instance, and not to the public internet. Thus, you create a VPC with both public and private subnets. The Amazon EC2 instance is hosted in the public subnet, so that it can reach the public internet. The DB cluster is hosted in a private subnet. The Amazon EC2 instance can connect to the DB cluster because it's hosted within the same VPC. However, the DB cluster is not available to the public internet, providing greater security.

This tutorial configures an additional public and private subnet in a separate Availability Zone. These subnets aren't used by the tutorial. An RDS DB subnet group requires a subnet in at least two Availability Zones. The additional subnet makes it easy to configure more than one Aurora DB instance.

To create a DB cluster that uses dual-stack mode, specify Dual-stack mode for the Network type setting. You can also modify a DB cluster with the same setting. For more information about creating a DB cluster, see Creating an Amazon Aurora DB cluster. For more information about modifying a DB cluster, see Modifying an Amazon Aurora DB cluster.

This tutorial describes configuring a VPC for Amazon Aurora DB clusters. For more information about Amazon VPC, see Amazon VPC User Guide.

Create a VPC with private and public subnets

Use the following procedure to create a VPC with both public and private subnets.

To create a VPC and subnets

  1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

  2. In the upper-right corner of the AWS Management Console, choose the Region to create your VPC in. This example uses the US East (Ohio) Region.

  3. In the upper-left corner, choose VPC dashboard. To begin creating a VPC, choose Create VPC.

  4. For Resources to create under VPC settings, choose VPC and more.

  5. For the remaining VPC settings, set these values:

    • Name tag auto-generation – tutorial-dual-stack

    • IPv4 CIDR block – 10.0.0.0/16

    • IPv6 CIDR block – Amazon-provided IPv6 CIDR block

    • Tenancy – Default

    • Number of Availability Zones (AZs) – 2

    • Customize AZs – Keep the default values.

    • Number of public subnet – 2

    • Number of private subnets – 2

    • Customize subnets CIDR blocks – Keep the default values.

    • NAT gateways ($) – None

    • Egress only internet gateway – No

    • VPC endpoints – None

    • DNS options – Keep the default values.

    Note

    Amazon RDS requires at least two subnets in two different Availability Zones to support Multi-AZ DB instance deployments. This tutorial creates a Single-AZ deployment, but the requirement makes it easy to convert to a Multi-AZ DB instance deployment in the future.

  6. Choose Create VPC.

Create a VPC security group for a public Amazon EC2 instance

Next, you create a security group for public access. To connect to public EC2 instances in your VPC, add inbound rules to your VPC security group that allow traffic to connect from the internet.

To create a VPC security group

  1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

  2. Choose VPC Dashboard, choose Security Groups, and then choose Create security group.

  3. On the Create security group page, set these values:

    • Security group name: tutorial-dual-stack-securitygroup

    • Description: Tutorial Dual-Stack Security Group

    • VPC: Choose the VPC that you created earlier, for example: vpc-identifier (tutorial-dual-stack-vpc)

  4. Add inbound rules to the security group.

    1. Determine the IP address to use to connect to EC2 instances in your VPC using Secure Shell (SSH).

      An example of an Internet Protocol version 4 (IPv4) address is 203.0.113.25/32. An example of an Internet Protocol version 6 (IPv6) address range is 2001:db8:1234:1a00::/64.

      In many cases, you might connect through an internet service provider (ISP) or from behind your firewall without a static IP address. If so, find the range of IP addresses used by client computers.

      Warning

      If you use 0.0.0.0/0 for IPv4 or ::0 for IPv6, you make it possible for all IP addresses to access your public instances using SSH. This approach is acceptable for a short time in a test environment, but it's unsafe for production environments. In production, authorize only a specific IP address or range of addresses to access your instances.

    2. In the Inbound rules section, choose Add rule.

    3. Set the following values for your new inbound rule to allow Secure Shell (SSH) access to your Amazon EC2 instance. If you do this, you can connect to your EC2 instance to install SQL clients and other applications. Specify an IP address so you can access your EC2 instance:

      • Type: SSH

      • Source: The IP address or range from step a. An example of an IPv4 IP address is 203.0.113.25/32. An example of an IPv6 IP address is 2001:DB8::/32.

  5. Choose Create security group to create the security group.

    Note the security group ID because you need it later in this tutorial.

Create a VPC security group for a private DB cluster

To keep your DB cluster private, create a second security group for private access. To connect to private DB clusters in your VPC, add inbound rules to your VPC security group. These allow traffic from your Amazon EC2 instance only.

To create a VPC security group

  1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

  2. Choose VPC Dashboard, choose Security Groups, and then choose Create security group.

  3. On the Create security group page, set these values:

    • Security group name: tutorial-dual-stack-db-securitygroup

    • Description: Tutorial Dual-Stack DB Instance Security Group

    • VPC: Choose the VPC that you created earlier, for example: vpc-identifier (tutorial-dual-stack-vpc)

  4. Add inbound rules to the security group:

    1. In the Inbound rules section, choose Add rule.

    2. Set the following values for your new inbound rule to allow MySQL traffic on port 3306 from your Amazon EC2 instance. If you do, you can connect from your EC2 instance to your DB cluster. Doing this means that you can send data from your EC2 instance to your database.

      • Type: MySQL/Aurora

      • Source: The identifier of the tutorial-dual-stack-securitygroup security group that you created previously in this tutorial, for example sg-9edd5cfb.

  5. To create the security group, choose Create security group.

Create a DB subnet group

A DB subnet group is a collection of subnets that you create in a VPC and that you then designate for your DB clusters. By using a DB subnet group, you can specify a particular VPC when creating DB clusters. To create a DB subnet group that is DUAL compatible, all subnets must be DUAL compatible. To be DUAL compatible, a subnet must have an IPv6 CIDR associated with it.

To create a DB subnet group

  1. Identify the private subnets for your database in the VPC.

    1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

    2. Choose VPC Dashboard, and then choose Subnets.

    3. Note the subnet IDs of the subnets named tutorial-dual-stack-subnet-private1-us-west-2a and tutorial-dual-stack-subnet-private2-us-west-2b.

      You will need the subnet IDs when you create your DB subnet group.

  2. Open the Amazon RDS console at https://console.aws.amazon.com/rds/.

    Make sure that you connect to the Amazon RDS console, not to the Amazon VPC console.

  3. In the navigation pane, choose Subnet groups.

  4. Choose Create DB subnet group.

  5. On the Create DB subnet group page, set these values in Subnet group details:

    • Name: tutorial-dual-stack-db-subnet-group

    • Description: Tutorial Dual-Stack DB Subnet Group

    • VPC: tutorial-dual-stack-vpc (vpc-identifier)

  6. In the Add subnets section, choose values for the Availability Zones and Subnets options.

    For this tutorial, choose us-east-2a and us-east-2b for the Availability Zones. For Subnets, choose the private subnets you identified in the previous step.

  7. Choose Create.

Your new DB subnet group appears in the DB subnet groups list on the RDS console. You can choose the DB subnet group to see its details. These include the supported addressing protocols and all of the subnets associated with the group and the network type supported by the DB subnet group.

Create an Amazon EC2 instance in dual-stack mode

To create an Amazon EC2 instance, follow the instructions in Launch an instance using the new launch instance wizard in the Amazon EC2 User Guide.

On the Configure Instance Details page, set these values and keep the other values as their defaults:

  • Network – Choose an existing VPC with both public and private subnets, such as tutorial-dual-stack-vpc (vpc-identifier) created in Create a VPC with private and public subnets.

  • Subnet – Choose an existing public subnet, such as subnet-identifier | tutorial-dual-stack-subnet-public1-us-east-2a | us-east-2a created in Create a VPC security group for a public Amazon EC2 instance.

  • Auto-assign Public IP – Choose Enable.

  • Auto-assign IPv6 IP – Choose Enable.

  • Firewall (security groups) – Choose Select an existing security group.

  • Common security groups – Choose an existing security group, such as the tutorial-securitygroup created in Create a VPC security group for a public Amazon EC2 instance. Make sure that the security group that you choose includes inbound rules for Secure Shell (SSH) and HTTP access.

Create a DB cluster in dual-stack mode

In this step, you create a DB cluster that runs in dual-stack mode.

To create a DB instance

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the upper-right corner of the console, choose the AWS Region where you want to create the DB cluster. This example uses the US East (Ohio) Region.

  3. In the navigation pane, choose Databases.

  4. Choose Create database.

  5. On the Create database page, make sure that the Standard create option is chosen, and then choose the Aurora MySQL DB engine type.

  6. In the Connectivity section, set these values:

    • Network type – Choose Dual-stack mode.

      Network type section in the console with Dual-stack mode selected

    • Virtual private cloud (VPC) – Choose an existing VPC with both public and private subnets, such as tutorial-dual-stack-vpc (vpc-identifier) created in Create a VPC with private and public subnets.

      The VPC must have subnets in different Availability Zones.

    • DB subnet group – Choose a DB subnet group for the VPC, such as tutorial-dual-stack-db-subnet-group created in Create a DB subnet group.

    • Public access – Choose No.

    • VPC security group (firewall) – Select Choose existing.

    • Existing VPC security groups – Choose an existing VPC security group that is configured for private access, such as tutorial-dual-stack-db-securitygroup created in Create a VPC security group for a private DB cluster.

      Remove other security groups, such as the default security group, by choosing the X associated with each.

    • Availability Zone – Choose us-west-2a.

      To avoid cross-AZ traffic, make sure the DB instance and the EC2 instance are in the same Availability Zone.

  7. For the remaining sections, specify your DB cluster settings. For information about each setting, see Settings for Aurora DB clusters.

Connect to your Amazon EC2 instance and DB cluster

After you create your Amazon EC2 instance and DB cluster in dual-stack mode, you can connect to each one using the IPv6 protocol. To connect to an Amazon EC2 instance using the IPv6 protocol, follow the instructions in Connect to your Linux instance in the Amazon EC2 User Guide.

To connect to your Aurora MySQL DB cluster from the Amazon EC2 instance, follow the instructions in Connect to an Aurora MySQL DB cluster.

Deleting the VPC

After you create the VPC and other resources for this tutorial, you can delete them if they are no longer needed.

If you added resources in the VPC that you created for this tutorial, you might need to delete these before you can delete the VPC. Examples of resources are Amazon EC2 instances or DB clusters. For more information, see Delete your VPC in the Amazon VPC User Guide.

To delete a VPC and related resources

  1. Delete the DB subnet group:

    1. Open the Amazon RDS console at https://console.aws.amazon.com/rds/.

    2. In the navigation pane, choose Subnet groups.

    3. Select the DB subnet group to delete, such as tutorial-db-subnet-group.

    4. Choose Delete, and then choose Delete in the confirmation window.

  2. Note the VPC ID:

    1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

    2. Choose VPC Dashboard, and then choose VPCs.

    3. In the list, identify the VPC you created, such as tutorial-dual-stack-vpc.

    4. Note the VPC ID value of the VPC that you created. You need this VPC ID in subsequent steps.

  3. Delete the security groups:

    1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

    2. Choose VPC Dashboard, and then choose Security Groups.

    3. Select the security group for the Amazon RDS DB instance, such as tutorial-dual-stack-db-securitygroup.

    4. For Actions, choose Delete security groups, and then choose Delete on the confirmation page.

    5. On the Security Groups page, select the security group for the Amazon EC2 instance, such as tutorial-dual-stack-securitygroup.

    6. For Actions, choose Delete security groups, and then choose Delete on the confirmation page.

  4. Delete the NAT gateway:

    1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

    2. Choose VPC Dashboard, and then choose NAT Gateways.

    3. Select the NAT gateway of the VPC that you created. Use the VPC ID to identify the correct NAT gateway.

    4. For Actions, choose Delete NAT gateway.

    5. On the confirmation page, enter delete, and then choose Delete.

  5. Delete the VPC:

    1. Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

    2. Choose VPC Dashboard, and then choose VPCs.

    3. Select the VPC that you want to delete, such as tutorial-dual-stack-vpc.

    4. For Actions, choose Delete VPC.

      The confirmation page shows other resources that are associated with the VPC that will also be deleted, including the subnets associated with it.

    5. On the confirmation page, enter delete, and then choose Delete.

  6. Release the Elastic IP addresses:

    1. Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.

    2. Choose EC2 Dashboard, and then choose Elastic IPs.

    3. Select the Elastic IP address that you want to release.

    4. For Actions, choose Release Elastic IP addresses.

    5. On the confirmation page, choose Release.