AWS Data Migration Service (DMS) // MySQL to S3

Get my Modern Data Essentials training (for free) & start building more reliable data architectures
https://www.ModernDataCommunity.com

-----

Learn how to use Data Migration Service on AWS! In this tutorial, we will go through an example of migrating data from a MySQL database to an S3 bucket using DMS.

AWS Database Migration Service (AWS DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), or between combinations of cloud and on-premises setups.

With AWS DMS, you can perform one-time migrations, and you can replicate ongoing changes to keep sources and targets in sync. If you want to change database engines, you can use the AWS Schema Conversion Tool (AWS SCT) to translate your database schema to the new platform. You then use AWS DMS to migrate the data. Because AWS DMS is a part of the AWS Cloud, you get the cost efficiency, speed to market, security, and flexibility that AWS services offer.


Timestamps:
0:00 - Intro
0:33 Navigate to DMS
0:44 Create Instance
1:22 Create Endpoints
3:33 Create a Task
4:22 Enable row-level logs
5:36 Finish Task Config
7:26 Review Error (Apply Log Settings)
9:05 Restart Service
9:36 Confirm Initial Files Loaded
10:09 Test with new records

Title & Tags:
Implement Data Migration Service With MySQL and S3 | Amazon Web Services (AWS) Tutorial
#kahandatasolutions #amazonwebservices #dataengineering