Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
  • Labs icon Lab
  • A Cloud Guru
Google Cloud Platform icon
Labs

Create and Configure an Aurora MySQL Database Cluster

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.

Try for free Contact sales
Google Cloud Platform icon
Labs

Path Info

Level
Clock icon Beginner
Duration
Clock icon 45m
Published
Clock icon Feb 28, 2020

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Table of Contents

  1. Challenge

    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.

  2. Challenge

    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.

  3. Challenge

    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
A Cloud Guru - Labs - Create and Configure an Aurora MySQL Database Cluster
Author
A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Start learning by doing today

View Plans