AWS DMS SERVICE

What is AWS Data Migration Service?

AWS Database Migration Service (AWS DMS) is a managed migration and replication service that helps move your database and analytics workloads to AWS quickly, securely, and with minimal downtime and zero data loss.

AWS DMS supports both homogeneous and heterogeneous database migrations, allowing you to move data from various sources to AWS services such as Amazon RDS (Relational Database Service), Amazon Aurora, Amazon Redshift, and more.

AWS DMS helps you migrate databases from on-premises data centers or other cloud platforms to AWS. It supports migration between different database engines, including Oracle, Microsoft SQL Server, MySQL, PostgreSQL, MongoDB, and more.

AWS DMS can be integrated with other AWS services, such as AWS Schema Conversion Tool, AWS CloudFormation, AWS Database Migration Accelerator, AWS Database Migration Service, and AWS Database Query Federation.

Migration Flow Overview

Firstly we have to specify Source , Destination and Migration agent .

Source : EC2 instance which is configured with MySQL database engine .

Destination : RDS where the data will be extracted and which can then feed into a number of destination databases or warehouses on AWS or on On-Premise .

Migration Agent : Here the migration agent is MySQL replication instance which is launched in a private subnet which will extract the data from source and will save it to the destination .

Steps to perform migration using DMS :

Step 1 : Login to AWS console and Launch an EC2 instance and connect .

Step 2 : Install MySQL in EC2 instance and create a dummy database . Further allow remote access to MySQL.

    1 sudo apt install mysql-server
    2 systemctl restart mysql.service 
    3 mysql
    4 apt install net-tools
    5 netstat -tnlp
    6 cd /etc/mysql/mysql.conf.d/
    7 ls
    8 vim mysqld.cnf 
   9 systemctl restart mysql.service 
   10  netstat -tnlp
   11  mysql 
   12  netstat -tnlp
   13  vim mysqld.cnf 
   14  systemctl restart mysql.service 
   15  mysql -u root -p

Provide Privileges for the database connection

Step 3 : Create target database in RDS .

Database created in RDS.

Step 4 : Create a source endpoint , target endpoint and test the connection

Click on the Endpoints option on the left panel of the console and then click on Create endpoint .

Source Endpoint

Target Endpoint

Click on run test to check all the endpoints are connected or not .

Step 5 : Create database migration task

Thankyou for reading ..