Introduction to Amazon Aurora

Lab Details

  1. This lab walks you through the creation and testing of an Amazon Aurora database. We will create an Aurora MySQL database and test the connection.

  2. Duration: 90 minutes

  3. AWS Region: US East (N. Virginia) us-east-1

Architecture Diagram

Task Details

1. Create Aurora Database Instance.

2. Connecting to Amazon Aurora MySQL RDS Database on a DB Instance.

3. Connecting from local Linux/IOS/Windows Machine

4. Execute Database Operations

5. Validation of the lab

6. Deleting AWS Resources

Prerequisites

MySQL Server Setup

  • Windows users need to download and install MySQL Workbench 

    • MySQL Workbench will be used for connecting to the database and executing SQL commands.

  • Linux Users need to install MySQL. Run the following command to install MySQL on your local machine:

    • brew install MySQL

    • Note: If you do not have a brew, install brew, and then execute the command above.