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.
Migrating On-premises MySQL Using a Continuous Database Migration Service Job
Google via Google Cloud Skills Boost
Overview
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
Tags
Related Courses
-
Migrating On-premises MySQL Using a Continuous Database Migration Service Job
-
Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service
-
Migrate to Cloud SQL for PostgreSQL using Database Migration Service
-
Migrating MySQL User Data When Running Database Migration Service Jobs
-
Migrating to AlloyDB from PostgreSQL Using Database Migration Service
-
Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service
