Google Cloud Skills Boost

Migrating MySQL data to Cloud SQL using Database Migration Service

6 hours Advanced universal_currency_alt 16 Credits
This advanced-level quest offers hands-on practice with migrating MySQL data to Cloud SQL using Database Migration Service. You will start with an introductory lab that briefly reviews how to get started with Cloud SQL for MySQL, including how to connect to Cloud SQL instances using the Cloud Console, then continue with two labs focused on migrating MySQL databases to Cloud SQL using different job types and connectivity options available in Database Migration Service. The quest ends with migrating MySQL user data when running Database Migration Service jobs.
Badge for Migrating MySQL data to Cloud SQL using Database Migration Service

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

  • Lab

    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.

    30 minutes
    Introductory
    1 Credit
    language
    • English
    • español (Latinoamérica)
    • français
    • 日本語
    • português (Brasil)
  • Lab

    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.

    1 hour 30 minutes
    Advanced
    1 Credit
  • Lab

    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.

    1 hour 30 minutes
    Advanced
    7 Credits
  • Lab

    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.

    1 hour 30 minutes
    Advanced
    7 Credits
    • info
    Quest Info
    Available languages
    English
    What do I do when I finish this quest?
    After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.
    What badges can I earn?
    Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.