Create an Amazon Aurora DB Cluster - Amazon Aurora

Create an Amazon Aurora DB Cluster

In this step, you create an Amazon Aurora MySQL DB cluster that maintains the data used by a web application.

Important

Before you begin this step, you must have a VPC with both public and private subnets, and corresponding security groups. If you don't have these, see Tutorial: Create an Amazon VPC for Use with a DB Instance. Complete the steps in Create a VPC with Private and Public Subnets, Create Additional Subnets, Create a VPC Security Group for a Public Web Server, and Create a VPC Security Group for a Private DB Instance.

To launch an Aurora MySQL DB cluster

  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 AWS Management Console, choose the AWS Region where you want to create the DB cluster. This example uses the US West (Oregon) Region.

  3. In the navigation pane, choose Databases.

  4. Choose Create database.

  5. On the Create database page, shown following, make sure that the Standard Create option is chosen, and then choose Amazon Aurora. Keep the default values for Version and Database Location.

    
                            Select engine
  6. In the Database features section, choose One writer and multiple readers.

  7. In the Templates section, choose Dev/Test.

  8. In the Settings section, set these values:

    • DB cluster identifiertutorial-db-cluster

    • Master usernametutorial_user

    • Auto generate a password – Disable the option

    • Master password – Choose a password.

    • Confirm password – Retype the password.

    
                        Settings sections
  9. In the DB instance size section, set these values:

    • Burstable classes (includes t classes)

    • db.t2.small

    
                            DB instance size section
  10. In the Availability & durability section, use the default values.

  11. In the Connectivity section, open Additional connectivity configuration and set these values:

    • Virtual Private Cloud (VPC) – Choose an existing VPC with both public and private subnets, such as the tutorial-vpc (vpc-identifier) created in Create a VPC with Private and Public Subnets

      Note

      The VPC must have subnets in different Availability Zones.

    • Subnet group – The DB subnet group for the VPC, such as the tutorial-db-subnet-group created in Create a DB Subnet Group

    • Publicly accessibleNo

    • VPC security groups – Choose an existing VPC security group that is configured for private access, such as the tutorial-db-securitygroup created in Create a VPC Security Group for a Private DB Instance.

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

    • Availability zoneNo Preference

    • Database port3306

    
                        Connectivity section
  12. Open the Additional configuration section, and enter sample for Initial database name. Keep the default settings for the other options.

  13. To create your Aurora MySQL DB cluster, choose Create database.

    Your new DB cluster appears in the Databases list with the status Creating.

  14. Wait for the Status of your new DB cluster to show as Available. Then choose the DB cluster name to show its details.

  15. In the Connectivity & security section, view the Endpoint and Port of the writer DB instance.

    
                        DB cluster details

    Note the endpoint and port for your writer DB instance. You use this information to connect your web server to your DB cluster.

    To make sure that your Aurora MySQL DB cluster is as secure as possible, verify that sources outside of the VPC can't connect to your Aurora MySQL DB cluster.

  16. Complete Create an EC2 Instance and Install a Web Server.