Migrate an Internet-Scale Online Transactional System to DynamoDB

CLOUD LABS

Migrate an Internet-Scale Online Transactional System to DynamoDB

In this Cloud Lab, you’ll migrate an internet-scale transactional database in MySQL to Amazon DynamoDB. Moreover, you’ll understand the migration of a relational database to a non-relational database.

12 Tasks

beginner

2hr 30m

Certificate of Completion

Desktop OnlyDevice is not compatible.

No Setup Required

Amazon Web Services

Learning Objectives

Working knowledge of Secrets Manager to store credentials of the database

The ability to provide an EC2 instance access to AWS Session Manager through an IAM role

The ability to migrate databases using DMS replication instances and endpoints

Hands-on experience creating a MySQL database and migrating it to a NoSQL database

Hands-on experience creating DMS tasks to configure mapping for migrations

Technologies

VPC

DMS

Secrets Manager

DynamoDB

EC2

Desktop Only

No Setup Required

Amazon Web Services

Labs Rules Apply

Stay within resource usage requirements.

Do not engage in cryptocurrency mining.

Do not engage in or encourage activity that is illegal.

Cloud Lab Overview

The Amazon Database Migration Service (DMS) simplifies the migration of databases. It supports migrations between the same as well as different database engines.

In this Cloud Lab, you’ll migrate an online transactional MySQL database to NoSQL DynamoDB tables. You’ll start by creating a MySQL database on an EC2 instance. Next, you’ll create a secret to store database credentials. Then, you’ll create a DMS replication instance and source and target endpoints to connect to the source and target databases. Finally, you’ll create a DMS task to carry out the migration. Also, you’ll query the DynamoDB tables to verify the migration.

By the end of this Cloud Lab, you’ll be able to migrate your internet-scale transactional databases to simple DynamoDB tables. Moreover, you’ll understand table mappings that are used to convert a relational database to a non-relational database,

The architecture diagram below shows the infrastructure you’ll build in this Cloud Lab:

Cloud Lab Tasks

1.Introduction

Getting Started

2.Source Database

Create an IAM Role

Launch an EC2 Instance

Create a MySQL Database

Create a Secret

3.Database Migration Service

Create IAM Roles for Replication Instance

Create a Replication Instance

Create Endpoints

Create a DMS Task

4.Target Database

Test DynamoDB

5.Conclusion

Clean Up

Wrap Up

Labs Rules Apply

Stay within resource usage requirements.

Do not engage in cryptocurrency mining.

Do not engage in or encourage activity that is illegal.

Before you start...

Try these optional labs before starting this lab.

Cloud Lab

Working with NoSQL Databases: A Beginner's Guide to AWS DynamoDB

beginner

1hr

Cloud Lab

Working with Instances: An Amazon EC2 Walkthrough

beginner

1hr

Relevant Courses

Use the following content to review prerequisites or explore specific concepts in detail.

Hear what others have to say

Join 1.4 million developers working at companies like

"Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms."

Felipe Matheus

Software Engineer

"I highly recommend Educative. The courses are well organized and easy to understand."

Adina Ong

Senior Engineering Manager

"I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode."

Clifford Fajardo

Senior Software Engineer

"I love the content on Educative and I feel as if I am definitely improving in my craft."

Thomas Chang

Software Engineer

Learn in-demand tech skills in half the time

PRODUCTS

Mock Interview

New

Courses

Skill Paths

Projects

Assessments

Newsletter