Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Migrating On-premises MySQL Using a Continuous Database Migration Service Job

Google via Google Cloud Skills Boost

Overview

In this lab, you migrate an on-premises MySQL database (running on a virtual machine) to Cloud SQL for MySQL using a continuous Database Migration Service job and VPC peering for connectivity. After you create and run the migration job, you confirm that an initial copy of your database has been successfully migrated to your Cloud SQL for MySQL instance. Then, you explore how continuous migration jobs continue to apply data updates from your source database to your Cloud SQL instance until you choose to complete the job. To conclude the migration job, you promote the Cloud SQL instance to be a new standalone database for reading and writing data.

Syllabus

  • Overview
  • Objectives
  • Setup
  • Task 1. Get the connectivity information for the MySQL source instance
  • Task 2. Create a new connection profile for the MySQL source instance
  • Task 3. Create and start a continuous migration job
  • Task 4. Review the status of the continuous migration job
  • Task 5. Confirm the data in Cloud SQL for MySQL
  • Task 6. Test the continuous migration of data from the source to the destination instance
  • Task 7. Promote Cloud SQL to be a standalone instance for reading and writing data
  • End your lab

Reviews

Start your review of Migrating On-premises MySQL Using a Continuous Database Migration Service Job

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.