Migrate an Internet-Scale Online Transactional System to DynamoDB
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
AWS logoAWS
DMS
EC2
DynamoDB logoDynamoDB
Secrets Manager
VPC
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:

Architecture diagram
Architecture diagram

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.

Trusted by 1.4 million developers working at companies including

Don’t take our word for it. See what our developers have to say.

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
TestimonialsImg

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

Adina Ong
TestimonialsImg

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
TestimonialsImg

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
TestimonialsImg
Don’t take our word for it. See what our developers have to say.

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
TestimonialsImg

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

Adina Ong
TestimonialsImg

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
TestimonialsImg

Get access to Educative Cloud Labs

Course Footer Image
Course Footer Image