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

Creating an Amazon Aurora RDS Database (MySQL Compatible)

In this hands-on lab, we will create an Aurora MySQL database. First, we will verify that the security groups, network ACL (NACL), and route tables are all configured to allow communication between an instance in a public subnet and an RDS database in a private subnet. After verifying the appropriate settings are in place, we will create the database. Once that is done, we will use an EC2 instance as a bastion host to allow us to connect to our private database from an external source.

Google Cloud Platform icon
Labs

Path Info

Level
Clock icon Beginner
Duration
Clock icon 1h 0m
Published
Clock icon Dec 15, 2020

Contact sales

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

Table of Contents

  1. Challenge

    Validate the Security Groups, Route Tables, and NACLs Are Configured Correctly

    Review the provided environment, and ensure your subnet NACLs allow traffic on ports 22 and 3306. Verify that the two private subnets are associated with a route table that only has local routes, and verify that a single public subnet is associated with a route table that has a route to the internet gateway. Confirm the presence of two security groups: one for SSH and the other for MySQL.

  2. Challenge

    Create a Database Subnet Group

    Navigate to the Amazon RDS dashboard, and create a subnet group for your Aurora cluster that only contains the private subnets. The subnet group should be named AuroraLabSubnetGroup.

  3. Challenge

    Create an Amazon Aurora Cluster

    Create an Amazon Aurora cluster (MySQL Edition) of type db.t3.small with a reader node in a different AZ using the DB subnet group created earlier and the MySQL security group provided with the lab. In the DB cluster identifier field, enter AuroraLabCluster.

  4. Challenge

    Verify That You Can Authenticate to the Aurora Cluster

    Connect to the bastion host instance and use the writer endpoint in a connection string to access MySQL. Once connected, execute the show global variables like 'aurora_server_id'; query. Observe the connection. After that, attempt to connect to the reader instance and run the same query. Observe the results.

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