- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Cloud
Migrating and Validating a Live Workload in Google Cloud
Globomantics runs its order service on a self-managed MySQL server in a Compute Engine VM and wants the database on Cloud SQL without losing an order or breaking the service. In this lab, you will inspect the live source to decide how to migrate it, configure a continuous migration with Database Migration Service, run it and decide when it is ready for cutover, cut the service over to Cloud SQL yourself, and prove with the same validation check that the destination holds every record and behaves like the source.
Lab Info
Table of Contents
-
Challenge
Inspect the source workload and determine the migration approach
- Read the six migration requirements and how the Orders service is deployed.
- Inspect the source server's live settings, databases, and write activity on the service's inventory page.
- Run the service's validation check to record a baseline.
- Decide the migration approach and the settings it needs.
At the end of this objective, you'll know how the source is configured and which migration settings the requirements call for.
-
Challenge
Configure the migration path to the managed destination
- Allow the Cloud SQL destination to reach the source over the private network.
- Create a connection profile for the source.
- Create a continuous migration job with a Cloud SQL destination that meets the requirements.
- Test the migration job.
At the end of this objective, you'll have a tested migration job ready to start.
-
Challenge
Run the migration and determine readiness for cutover
- Start the migration job and follow it through the full dump.
- Set the destination's root password so the Orders service can read the destination.
- Write a readiness marker on the source and find it on the destination.
- Judge readiness against the cutover criteria.
At the end of this objective, you'll know the destination is keeping up with the live source.
-
Challenge
Cut over the workload to the destination
- Stop writes and write the cutover marker.
- Confirm the destination has caught up, then promote it.
- Add the service's database user to the destination and point the service at it.
- Resume writes.
At the end of this objective, you'll have the Orders service running on Cloud SQL.
-
Challenge
Verify data completeness and behavior after migration
- Run the same validation check against the destination and compare it with the baseline.
- Confirm that new orders land on the destination.
- Confirm that the migration met each stated requirement.
At the end of this objective, you'll have evidence that the migration lost nothing and the service behaves as it did before.
About the author
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.