Lab
A Cloud Guru

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

Path Info

Level

Beginner

Duration

45m

Published

Feb 28, 2020

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.
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.
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

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.