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.