AWS DMS (Data Migration Service) Step by Step Tutorial (Migrate data from Aurora to S3 & DynamoDB)

In this hands-on step by step tutorial, we will see as to how we can use AWS DMS (Data Migration Service) to migrate data from Aurora mySQL to S3 as well as to DynamoDB. Also, demonstrated is the Chandra Data Capture (CDC) features of DMS to stream source data changes to the DMS target(s).

Things that you will learn in this tutorial :
1. How to create a DMS Replication Instance
2. How to create & prepare DMS Endpoints
3. How to create DMS Replication Tasks
4. How to Launch Aurora mySQL and access it via a Bastion Server
5. Security Groups & IAM Roles required for DMS

Here are links to a couple of mySQL client softwares :
Sqlectron : https://www.electronjs.org/apps/sqlec...
mySQL Workbench : https://www.mysql.com/products/workbe...

Here are links to considerations with S3 & DynamoDB as DMS Targets :
https://docs.aws.amazon.com/dms/lates...
https://docs.aws.amazon.com/dms/lates...

Here is how, you can set the binlog retention for mySQL :
call mysql.rds_set_configuration('binlog retention hours', 24);
SHOW VARIABLES LIKE 'log_bin';