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

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.

• 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