menu
arrow_back

Introduction to Amazon Relational Database Service (RDS) (Windows)

4m setup · 50m access · 25m completion
Connection Details

Warning: Do not transmit data into the AWS Console that is not related to Qwiklabs or the lab you are taking.

1 Credit

info_outline
This lab costs 1 Credit to run. You can purchase credits or a subscription under My Account.

00:50:00

Introduction to Amazon Relational Database Service (RDS) (Windows)

SPL-69 - Version 3.3.2

© 2018 Amazon Web Services, Inc. and its affiliates. All rights reserved. This work may not be reproduced or redistributed, in whole or in part, without prior written permission from Amazon Web Services, Inc. Commercial copying, lending, or selling is prohibited.

Errors or corrections? Email us at aws-course-feedback@amazon.com.

Other questions? Contact us at https://aws.amazon.com/contact-us/aws-training/

Overview

This lab introduces you to Amazon Relational Database Service using the AWS Management Console.

Topics covered

By the end of this lab, you will be able to:

  • Create an Amazon Relational Database Service (RDS) instance.
  • Connect to the RDS Instance with client software.

What Is Amazon RDS?

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to setup, operate, and scale relational databases in the cloud. It allows you to create and use MySQL, PostGRE, Oracle, or SQL Server databases. This means the code, applications, and tools you already use today with your existing databases, can be used with Amazon RDS.

Mac Users: Download Remote Desktop Client Software

If you are running Windows on your local machine, you can use Remote Desktop Connection to access your Amazon EC2 instance.

If you are on a Mac, you will require Microsoft Remote Desktop (with the red icon):

Microsoft Remote Desktop

Mac users can download Microsoft Remote Desktop from the Mac App Store.

If you do not have access to the Mac App Store, you can use CoRD for Mac, but please note that the instructions for this lab assume you are using Microsoft Remote Desktop.

Start Lab

Notice the lab properties below the lab title:

  • setup - The estimated time to set up the lab environment
  • access - The time the lab will run before automatically shutting down
  • completion - The estimated time the lab should take to complete
  1. Launch your lab by clicking Start Lab

If you are prompted for a token, use the one distributed to you (or credits you've purchased).

A status bar shows the progress of the lab environment creation process (the AWS Management Console is accessible during lab resource creation, but your AWS resources may not be fully available until the process is complete).

  1. Open your lab by clicking Open Console

This will automatically log you into the AWS Management Console.

Please do not change the Region unless instructed.

Common login errors

Error : Federated login credentials

If you see this message:

  • Close the browser tab to return to your initial lab window
  • Wait a few seconds
  • Click Open Console again

You should now be able to access the AWS Management Console.

Error: You must first log out

If you see this message:

  • Click To logout, click here
  • Close the browser tab to return to your initial Qwiklabs window
  • Click Open Console again

Task 1: Create a Relational Database Service (RDS) Instance

In this task, you will create an Amazon RDS instance of the MySQL database.

  1. In the AWS Management Console, on the Services menu, click RDS.

  2. In the left navigation pane, click Instances.

  3. Click Create database

A selection of database engines will be presented. Amazon RDS supports many different databases and multiple versions of each database. You will be using MySQL.

  1. On Step 1:
  • Select MySQL
  • Click Next
  1. On Step 2:
  • Select Dev/Test - MySQL
  • Click Next
  1. In the Instance specifications section for DB instance class, select db.t2.micro - 1 vCPU, 1 GiB RAM

  2. In the Settings section, configure the following:

  • DB instance identifier:
  • Master username:
  • Master password:
  • Confirm password:

These settings define the size of DB Instance (which varies by CPU and RAM) together with the access credentials.

  1. Click Next

  2. In the Network & Security section, configure:

  • Virtual Private Cloud (VPC): Lab VPC
  • VPC security groups: Choose existing VPC security groups

    • Select RDSSecurityGroup
    • Remove default

These settings keep the DB Instance private (not accessible from the Internet).

  1. In the Database options section, for Database name enter:

  2. In the Backup section, for Backup retention period select 0 days (to disable automatic backups)

  3. In the Maintenance section, for Auto minor version upgrade, select Disable auto minor version upgrade.

  4. Scroll to the bottom of the screen, then click Create database

  5. Click View DB instances details

The RDS instance will take about 10 minutes to create.

Please continue to the next task. There is no need to wait for your database to launch.

Join Qwiklabs to read the rest of this lab...and more!

  • Get temporary access to the Amazon Web Services Console.
  • Over 200 labs from beginner to advanced levels.
  • Bite-sized so you can learn at your own pace.
Join to Start This Lab
home
Home
school
Catalog
menu
More
More