BloomTech’s Downfall: A Long Time Coming

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

Google

Migrate MySQL data to Cloud SQL using Database Migration Service

Google via Qwiklabs

Go to class Write review

Overview

Earn a skill badge by completing the Migrate MySQL data to Cloud SQL using Database Migration Services quest, where you will learn how to migrate MySQL data to Cloud SQL using Database Migration Services, including how to: connect to Cloud SQL instances using the Cloud Console and with different job types and connectivity options available in Database Migration Service, and migrate MySQL user data when running Database Migration Service jobs. A skill badge is an exclusive digital badge issued by Google Cloud in recognition of your proficiency with Google Cloud products and services and tests your ability to apply your knowledge in an interactive hands-on environment. Complete this skill badge quest, and the final assessment challenge lab, to receive a skill badge that you can share with your network.

Syllabus

  • Cloud SQL for MySQL: Qwik Start
    • Create a Google Cloud SQL MySQL instance and perform SQL operations using Google Cloud Platform Console and mysql client. Watch this short video, Manage PostgreSQL and MySQL Databases Easily with Cloud SQL.
  • warning Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service
    • In this lab, you migrate MySQL data from an Amazon RDS instance for MySQL to Cloud SQL for MySQL using a one-time Database Migration Service job and an IP allowlist for connectivity. After you create and run the migration job, you confirm that the data have been successfully migrated to your Cloud SQL for MySQL instance.
  • 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.
  • Migrating MySQL User Data When Running Database Migration Service Jobs
    • In this lab, you learn how to migrate MySQL user data when running Database Migration Service jobs. First, you identify the existing MySQL users and update DEFINER to INVOKER for database objects on the source instance. Next, you create and save a Database Migration Service job. Then, before running the migration job, you create the necessary users on the destination database instance. Finally, you start the saved migration job; after the job runs successfully, you check the migrated data in the Cloud SQL for MySQL instance.
  • Migrate MySQL Data to Cloud SQL using Database Migration Service: Challenge Lab
    • This challenge lab tests your ability to migrate a database using the Database Migration Service.

Tags

Reviews

Start your review of Migrate MySQL data to Cloud SQL using Database Migration Service

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.