Sometimes, you may face connectivity issues with your Cloud SQL instance, and it’s important to know what to look for when troubleshooting. In this hands-on lab, we will discover a solution when troubleshooting a connection issue between a Compute Engine Instance and a Cloud SQL Instance.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create a Cloud SQL Instance
- From the main console navigation, head over to SQL.
- Click on CREATE INSTANCE.
- Then choose MySQL.
- Name the instance "test-connection-instance" and add the following settings:
- Root password: "12345"
- Database version: MySQL 5.7
- Machine type: Standard (1 vCPU, 3.75 GB)
- Click Create.
- Create a Compute Engine Instance
- From the main console navigation, head over to *Compute Engine**
- Click Create.
- Click on Allow HTTP. Then leave everything else as the default. The boot disk should be Debian.
- Click Create.
- Enable the Cloud SQL Admin API
- From the main console navigation, head over to APIs and Services.
- Click on Enable APIs and Services.
- Then type in "Cloud SQL Admin API".
- Click Enable.
- Add the Compute Engine Instance Public IP as a Authorized Network for Cloud SQL
- From the main console navigation, head over to Compute Engine.
- Then choose and copy the public IP for your instance.
- From the main console navigation, head over to SQL.
- Click on the test-connection-instance. Click on Edit, and then Connectivity.
- Click on Add network, paste the VM’s IP, and click Done.
- Click Save.
- SSH into Your VM to Connect to Cloud SQL
- From the main console navigation, head over to Compute Engine.
- Click on SSH.
- Once connected, get and install updates.
- Connect to the instance by using the command.
- Use the password you set up for your instance.
You are now connected.
