Workaround for Migrate MySQL database to Cloud SQL: Challenge Lab

[agi83]

Hey guys,

Today, I was trying to complete the Migrate MySQL database to Cloud SQL: Challenge Lab from Partner Cloudskillsboost and came across an issue in Task 2. Migrate database, in part 2: create and start a database Migration Service job.
The test job will fail as the source database minor version (8.0.36) is higher then the max supported version in Database Migration service (8.0.35). 

I informed Qwiklabs support guys but in the meantime if you want to complete this lab, follow this workaround that worked for me:

1. Complete Task 1 as specified in lab instructions
2. Create a new Destination Cloud SQL instance using name and password from Task 2, part 2 

3. Pay attention to Region, Database Minor version and change to Enterprise SQL edition

4. In Connections, Enable Private IP and setup a private services access connection

5. While you wait for the new cloud sql instance to be created, follow the steps from Task 2 (part 1) to create a connection profile 
6. Once the cloud sql is ready, create a Database Migration Service job from Task 2 (part 2) using existing cloud sql instead of new one:

Hope this is useful. 
A

[Fleabyte · Accepted solution]

nice article

🙂

[Fleabyte · Accepted solution]

nice article

🙂

[Alexsam69 · Accepted solution]

That's great work I am glad to see this solution 😀