- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Cloud
- Data
Migrate MySQL to Amazon Aurora with AWS DMS
In this hands-on lab, you migrate a small MySQL database to Amazon Aurora using AWS Database Migration Service (DMS). Starting from a populated Amazon RDS for MySQL source and an empty Aurora MySQL-compatible target, you create a DMS replication instance, configure and test the source and target endpoints, run a full-load migration task, monitor it to completion, and validate that the migrated schema and data landed correctly in Aurora. The lab focuses on the core DMS full-load workflow that database and cloud engineers use to move a relational workload into a managed Aurora environment.
Lab Info
Table of Contents
-
Challenge
Prepare the source and target for migration
- Review the source RDS for MySQL instance and the empty Aurora target.
- Create a DMS replication instance in the provided VPC.
- Create and test a source endpoint for the globomantics-tickets-source database, and a target endpoint for the globomantics-tickets-target-writer database.
-
Challenge
Configure the DMS endpoints and migration task
- Add the MySQL globomantics-tickets-source database as the DMS' source endpoint.
- Add the Aurora MySQL database globomantics-tickets-target-writer as the DMS' target endpoint.
- Create a full-load migration task–the DMS' Task type is the default value, Migrate only–with table mappings scoped to the globomantics schema.
-
Challenge
Run the migration task and monitor progress
- Start the task and watch it move from starting to running to load complete.
- Confirm the full load reaches 100% with no table errors.
-
Challenge
Validate the migrated schema and data in Aurora
- Use AWS CloudShell with the RDS Data API to query the Aurora target.
- Confirm each migrated table exists with the expected row counts (customers
8, agents4, tickets12).
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.