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 : [ Ссылка ]
mySQL Workbench : [ Ссылка ]
Here are links to considerations with S3 & DynamoDB as DMS Targets :
[ Ссылка ]
[ Ссылка ]
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';
Ещё видео!