Create and Configure an Aurora MySQL Database Cluster

45 minutes
  • 3 Learning Objectives

About this Hands-on Lab

In this hands-on lab, we will create an Aurora MySQL database cluster. First, we will verify that the security groups and network ACLs (NACLs)s are all configured correctly, then create a new security group, and finally create an Aurora MySQL database in a private subnet.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Verify the Security Groups and NACLs

Verify the private subnets are associated with a route table that does not contain a direct route to an internet gateway.
Verify NACLs allow TCP traffic on ports 0-65535.

Create an Aurora MySQL Database Security Group

Create a new database security group allowing MySQL/Aurora access on port 3306 from the default security group.
Then update the default security group rules to allow SSH port 22 traffic from anywhere.

Create an Aurora MySQL Database Cluster
  1. Create a RDS Aurora database, ensuring the database is launched in a private subnet.
  2. Ensure the subnet group (create new) and security group associated with the RDS Aurora database permits traffic on TCP 3306:
  3. Create an Aurora Database
  4. Select the default MySQL and default MySQL version
  5. Leave the default Database Location as Regional
  6. Choose Dev/Test for templates
  7. Add auroracluster as our DB Identifier
  8. Add password for the admin credentials
  9. For the DB instance size choose burstable and db.t2.small
  10. Enable multi-AZ deployment
  11. Select or create new subnet group
  12. Choose to not have your database publicly accessible
  13. Choose a security group
  14. Leave the defaults for AZ and database port
  15. Add auroraclusterinstance1 as the DB instance identifier
  16. Add initial database name: auroradb
  17. Leave the defaults for parameter groups
  18. Leave defaults for IAM, Failover, Backup, Encryption, BackTrack
  19. Do not enable enhanced monitoring because it will take a bit longer for your database to create
  20. Leave default for maintenance as well
  21. Click Create Database

Additional Resources

Hi, and welcome to this hands-on lab: Configure and deploy an Aurora MySQL database.

Our company is considering using an Aurora MySQL database for our production workload. We have been tasked with creating and configuring an Aurora MySQL database for the development team. They will then test to see if Aurora would be the perfect fit for our production workload.

Log in to the live AWS environment using the credentials provided, and make sure you are in the us-east-1 region.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?