Preparation

Overview

The databases in this lab can take some time to create, by creating them all at the start of the lab some time can be saved. For a bit of variety we’ll create various different database types.

Create an RDS MySQL x86-64 instance for Lab 1

Go to the RDS Console and create a MySQL Database on the free tier:

  1. Click Create Database
  2. Select Easy create
  3. Select MySQL as the engine type
  4. Select Free Tier (instance type db.t3.micro)
  5. Enter a database ID (e.g. mysql-lab1)
  6. Select Auto generate a password
  7. Leave everything else at defaults and click create database. Your configuration should look like the image below.

NOTE: It will take a few minutes to create the database and for it to become available, while its processing you can start to create the next database.

Lab 1 Database Creation

Create an RDS PostgreSQL instance on x86-64 for Lab 2

Go to the RDS Console and create a PostgreSQL database on the free tier:

  1. Click Create Database
  2. Select Easy create
  3. Select PostgreSQL as the engine type
  4. Select Free Tier (Instance type db.t3.micro)
  5. Enter a database ID (e.g. postgresql-lab2)
  6. If the master username is set to Master, it must be changed to something else (e.g. myuser)
  7. Select Auto generate a password
  8. Leave everything else at defaults and click create database. Your configuration should look like the image below.

Lab 2 Database Creation

Create an Amazon Aurora instance for Lab 3

  1. Click Create Database
  2. Select Standard create
  3. Select Amazon Aurora as the engine type
  4. Choose Amazon Aurora MySQL-Compatible Edition
  5. For the engine version, this can remain as the default selected version. In the image below this is Aurora (MySQL 5.7) 2.10.2
  6. Choose the Dev/Test template. Your configuration should look like the image below

Lab 3 Database Creation 1

  1. Enter a database identifier (e.g. aurora-lab3)
  2. Select Auto generate a password
  3. In the instance configuration, select the radio button for Burstable classes (includes T classes)
  4. Select db.t3.small as the instance type

Lab 3 Database Creation 2

  1. Leave all other settings as default
  2. Click Create Database

It will take a few minutes to create the database and for it to become available, continue to create the DB for lab 4 in the meantime.

Create a MariaDB instance for Lab 4

From the Amazon RDS console:

  1. Click Create Database
  2. Select Easy Create
  3. Choose MariaDB as the engine type
  4. Select the radio button for Free tier
  5. Enter a db instance identifier (e.g. mariadb-lab4)
  6. Select db.t3.micro as the instance type
  7. Choose Auto Generate a password
  8. Leave everything else at defaults
  9. Click Create Database

Lab 4 Database Creation

All 4 databases should now be created or at least in the process of creating. Now you can move on to the labs themselves.