Project 3 - Using DMS to Migrate MySQL to Amazon Aurora

Learn how to migrate a MySQL database to Amazon Aurora using AWS Database Migration Service (DMS). This hands-on lab guides you through setting up source and target endpoints, configuring replication, and executing a seamless database migration.

Created by

Akinola Ojuola

Hours

0 Enrolled

    • (0 Reviews)

English

Last updated

Tue, 02-Dec-2025

Course description

In this practical lab, you will perform a real-world database migration from MySQL to Amazon Aurora using AWS Database Migration Service (DMS). You'll start by provisioning both source (MySQL RDS) and target (Aurora) databases in AWS. Then, you'll configure DMS replication instances, define source and target endpoints, and create a migration task with validation enabled. By the end of this lab, you'll have hands-on experience with DMS workflows, understand how to monitor migration progress, and gain confidence in executing cloud database migrations with minimal downtime.

Additionally, all learners receive dedicated online support through our Slack workspace where you can ask questions, get troubleshooting help, and interact with our team throughout the entire project.

Click here to access Slack workspace link

What will i learn?

  • Provision MySQL and Aurora databases in AWS
  • Configure AWS DMS replication instances and endpoints
  • Create and run a DMS migration task with data validation
  • Monitor migration progress and verify data integrity
  • Understand best practices for database migration to AWS

Requirements

  • An active AWS account with access to RDS and DMS
  • Basic understanding of relational databases (MySQL/Aurora)
  • Familiarity with AWS Management Console
  • Permission to create RDS instances and DMS resources

Frequently asked question

DMS is used to migrate databases between homogeneous or heterogeneous database engines with minimal downtime. It supports ongoing replication and one-time migrations.

No, DMS can automatically create tables in the target database if you select the appropriate target preparation mode (e.g., DROP_AND_CREATE).

Yes, by selecting “Migrate and replicate” task type, DMS will perform a full load and continue to replicate ongoing changes from the source to the target.

Akinola Ojuola

Cloud Solution Architect, DevOps Consultant & Trainer

Akinola Ojuola is a seasoned Cloud Solution Architect, DevOps Consultant and technical trainer with over 20 years of industry expertise. Throughout his career, he has worked with some of the world’s most prominent technology-driven organisations, including IBM, Fujitsu, Walmart, and MasterCard, delivering transformative solutions across various sectors. Akinola has trained and mentored more than 1,000 students across 18 countries on five continents. His commitment to real-world, practical learning has enabled hundreds of learners to launch successful careers in global tech companies. He is passionate about practical, real-world learning. His teaching approach blends deep technical knowledge with hands-on, enterprise-level experience. He holds multiple industry certifications and leads advanced projects in Cloud Architecture, DevOps, DevSecOps, and Artificial Intelligence for both private enterprises and public institutions.Whether you’re just starting or looking to advance your tech career, you’ll gain valuable, job-ready skills under his guidance.
View profile

$10

Lectures

1

Skill level

Intermediate

Expiry period

1 Months

Certificate

Yes
Remove from cart Add to cart Buy now

Related courses

Intermediate

Project 1 - Deploy Amazon RDS Multi-AZ and Read Replica in AWS

0

(0 Reviews)

Compare

Learn how to build a highly available WordPress application on AWS using Amazon RDS with Multi-AZ automatic failover and read replicas.

$10

Hours

Beginner

Project 2- Enable S3 bucket versioning

0

(0 Reviews)

Compare

Learn how to enable and use Amazon S3 bucket versioning to protect your data from accidental deletion or overwrite. In this hands-on lab, you'll create public and private S3 buckets, upload files, enable versioning, and manage multiple object versions.

$10

Hours

Beginner

Project 4 - EFS

0

(0 Reviews)

Compare

Learn how to create and mount an Amazon Elastic File System (EFS) to multiple Amazon EC2 instances. This lab covers security group configuration, EFS setup, instance deployment, and mounting verification.

$10

Hours

Intermediate

Project 5 - Secure Nginx webserver with Let'sEncrypt on an Ubuntu Instance with Certbot

0

(0 Reviews)

Compare

Learn how to secure an Nginx web server running on an Ubuntu EC2 instance using Let's Encrypt SSL/TLS certificates. This lab covers domain setup, Certbot installation, and automated certificate renewal.

$10

Hours

Advanced

Project 6 - Setup Highly Available Cluster using HA Proxy and Keepalived

0

(0 Reviews)

Compare

Learn how to build a highly available web cluster using HAProxy and Keepalived on AWS. This lab covers load balancer configuration, virtual IP management, automatic failover, and high availability verification.

$10

Hours

Beginner

Project 7 - Install MySQL DB server on EC2 instance and remotely connect to it.

0

(0 Reviews)

Compare

Learn how to install and configure a MySQL database server on an Amazon EC2 instance and connect to it remotely. This lab covers security group configuration, MySQL installation, user creation, and remote database access.

$10

Hours

Advanced

Project 8 - Deploy a Java Enterprise Application on Tomcat Server using Jenkins Pipeline

0

(0 Reviews)

Compare

Learn how to automate the deployment of a Java web application to a Tomcat server using a Jenkins CI/CD pipeline. This lab covers infrastructure provisioning with Terraform, Jenkins configuration, pipeline scripting, and automated deployment.

$10

Hours

Intermediate

Project 9 - Recover DB data after corruption or accidental deletion has occurred.

0

(0 Reviews)

Compare

Learn how to recover a corrupted or accidentally deleted WordPress database using AWS RDS snapshots and point-in-time restore. This lab covers backup strategies, restoration procedures, and instance renaming for seamless recovery.

$10

Hours

Beginner

Project 10 - How to create a CRUD Serverless API with AWS Lambda, API Gateway and a DynamoDB from Scratch

0

(0 Reviews)

Compare

Learn how to build a fully serverless CRUD API using AWS Lambda, API Gateway, and DynamoDB. This hands-on lab covers creating a RESTful API, integrating services, and testing endpoints with real HTTP requests.

$10

Hours

Beginner

Project 11 - Application Load Balancer (ALB) - Session Stickiness

0

(0 Reviews)

Compare

Learn how to configure and test session stickiness on an AWS Application Load Balancer (ALB). This lab demonstrates cookie-based session affinity, failover behavior, and load distribution with hands-on testing.

$10

Hours

Intermediate

Project 12 - MySQL Master-Slave Replication on different AWS instances

0

(0 Reviews)

Compare

Learn how to set up MySQL Master-Slave replication across separate AWS EC2 instances. This lab covers replication configuration, data synchronization, and failover readiness using Terraform and MySQL.

$10

Hours

Intermediate

Project 13 - Setting Up a Monitoring Stack Using Grafana, Prometheus, and Node Exporter on Ubuntu

0

(0 Reviews)

Compare

Learn how to build a complete monitoring stack on Ubuntu using Grafana, Prometheus, and Node Exporter. Deploy a multi-server monitoring system, visualize real-time metrics, and gain hands-on experience with industry-standard observability tools.

$10

Hours

Industry-aligned, hands-on tech training in Cloud, DevOps, DevSecOps, Python AI and more —empowering learners worldwide with job-ready skills and global certifications.

Top categories

Useful links

Help

Subscribe to our newsletter