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. Launching Lab Environment

  2. Create Aurora Database Instance.

  3. Create an RDS Database Instance

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

  5. Connecting from a Windows Machine

  6. Execute Database Operations for Windows users

  7. Connecting from a local Linux/iOS Machine

  8. Execute Database Operations for Mac/Linux users

  9. Validation of the lab

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