AWS Data Migration Service | Aurora MYSQL [Hands on Lab]

Unable to load video.

Watch Video

Summary

This AWS lab demonstrates migrating a MySQL database to an AWS Aurora MySQL database using the AWS Data Migration Service (DMS). The process involves creating a DMS replication instance, source and target endpoints for the databases, and testing the endpoint connections. A data migration task is then created to define the migration rules, followed by monitoring the task's progress via CloudWatch. The lab concludes by verifying the successful migration of data from the source MySQL database to the target Aurora MySQL database. Finally, the successful migration is confirmed by querying the target database.

Chat With YouTube Video

Full Transcript

hi welcome to this lab on AWS data migration service I am Eliza tanveer from skill curb and in this lab we will learn how to migrate a mySQL database to AWS Aurora mySQL database this is going to be the solution where I'll have a source database which is going to be a mySQL database and I am going to have a Target database which is going to be Aurora mySQL database and I am going to migrate the database from the source to the Target using AWS data migration service application instance the steps that will be followed are first we will create a DMS instance which actually is going to be a replication then we will create source and Target endpoints which will contain the information about source and Target databases then we will test the endpoints by checking its connection then we will create a data migration task that that will Define rules to migrate the on-premise mySQL database to AWS Aurora SQL database and then finally we will monitor the migration task so the first step is to create a database and for that you have to go to RDS and select create database then from the database creation method you have to select standard create and since we are creating Source database then from engine options you have to select MySQL addition will be automatically updated version will be automatically updated then from the templates you have to select free tier as it will not cost you anything then from settings I am going to give a suitable identifier to the DP instance and I am going to leave the master username as admin and provide appropriate password I am not going to change anything else except public accessibility I am going to change it to yes so that it can be easily accessed from our local machines from here I am going to select default to VPC and password authentication for the database and then I'll simply click create database for this lab I have already created two databases you can view the databases by typing RDS in the search bar from here click on databases from the navigation panel and you will see all the databases so the database which is named database is an aurora mySQL database and so it is going to be our Target DB while database 1 is a mySQL database which is going to be our source database now we will move to our first step which is to create a DMS instance which is also called a replication instance so for that type DMS in the search bar from the navigation panel select replication instances here you have to click create replication instance here we have to provide a name to the replication instance I am going to call it TMS replication Arn is optional so we will leave it and we are going to give a suitable description to the replication instance here we will Define the instance configuration for instance class I will select DMS T3 micro engine version will be 3.4.7 and for availability Zone I will select single easy keep allocated storage to 50 GB network type should be ipv4 no need to change VPC and I will uncheck the public accessible checkbox and click on create replication instance here our first step is done this will take about five to seven minutes to be created so in the meantime we will move towards step two which is to create end points from the navigation panel select end points here click on create endpoint and then from the end point type you have to select Source endpoint because our database isn't on premise so that's why we are not going to select the rdsdb instance checks box if we are moving the data from cloud then it has to be checked now we have to give an endpoint identifier I am going to call it Source endpoint MySQL I am going to leave Arn and I am going to select the source engine which is going to be MySQL you can also select AWS secret manager for that you have to provide the secret ID and I am enrolled but I am going to select provide access information manually here we have to provide a server name which is going to be the endpoint path of my mySQL database so I will move to my database and copy the end point and paste it as the server name Port is double three zero six and here you have to enter the username and password which was allocated to your date and click create endpoint so our source endpoint is created now we are going to create the target endpoint for that click create endpoint and from the endpoint type you have to select the target endpoint now check the select RDS in DB instance and select the database instance for the Aurora mySQL database at the endpoint configurations will be autofilled and we only have to provide the access information manually we have to provide the database password username is automatically filled no need to change the SSL layer and click create endpoint this marks the completion of our second step let's take replication instance once it is created then we will move to our third step third step which is to test the end points from end point select Source endpoint MySQL and from action select test connection select DMS repl