Open main menu

CDOT Wiki β

OPS705 Lab 7

LAB PREPARATION

Purpose / Objectives of Lab 7

In this lab, you will learn how to create a MySQL database in AWS RDS and link it to a web application. We'll be using AWS Academy - Cloud Foundations Module 8 for this lab. For more information about these technologies, refer to the Lab 7 lectures and slides.

While you are working through this lab, it is highly recommended that you write down general notes and commands to help you remember how to do this lab. You may use your notes during tests, so fill it out accordingly!

If you encounter technical issues, please contact your professor via e-mail or in your section's Microsoft Teams group.

Minimum Requirements

Before beginning, you must have:

  1. Successfully completed Lab 6
  2. Watched the Lab 7 video lecture
  3. Read through the Lab 7 slides, and have them handy as a reference for concepts
  4. Your AWS Academy login credentials

INVESTIGATION: Amazon Relational Database Service

In this investigation, you'll set up an AWS MySQL instance and link it to a running web application. This service takes care of all the infrastructure setup. That said, you do have to specify some network and security settings.

Part 1: Logging in to AWS Academy - Cloud Foundations

To create your web app, perform the following steps:

  1. Log in to AWS Academy here: https://awsacademy.instructure.com/login/canvas
  2. Under Courses, choose AWS Academy Cloud Foundations

Part 2: Module 8, Lab 5 - Build a Database Server

  1. Navigate to Modules in the left-hand menu bar.
  2. Scroll down to Module 8 - Databases
  3. Click on Lab 5 - Build a Database Server
  4. Complete. This module has 4 tasks in its' Academy instructions. You will take a screenshot at the end of each task to showcase your progress:
    1. Task 1: Your DB Security Group details page.
    2. Task 2: Your new subnet group details page.
    3. Task 3: Your lab-db database details page.
    4. Task 4: Your address book page with four entries (two default; add another two yourself)

Part 3: A Note About Resource Usage

Module labs only need to be ended to shut down all resources. Remember, your created work is not preserved after you end the lab!

Part 4: Exploration

While we're focusing on MySQL in this lab, it's important to understand the offerings AWS has through its' RDS service. Watch through the rest of the Module 8 material in our Cloud Foundations classroom. It covers other database types, including several SQL and NoSQL options.

A second AWS Academy classroom is available to you, AWS Academy Learner Lab - Foundation Services. Here, you can explore the RDS service (along with many others), create instances that will remain for the duration of the class, and try things out. I highly encourage you to take a look and play around! Read through the sidebar readme doc for service restrictions.

Lab Submission

Submit to Blackboard's Lab Submission section full-desktop screenshots (PNG/JPG) of the following:

  1. Task 1: Your DB Security Group details page.
  2. Task 2: Your new subnet group details page.
  3. Task 3: Your lab-db database details page.
  4. Task 4: Your address book page with four entries (two default; add another two yourself)

Labs aren't marked until screenshots have been submitted.