GCP | How to access Cloud SQL private IP using Cloud SQL Auth Proxy and Identity-Aware Proxy (IAP)?

🔴 #Cloud #SQL in #GCP is a great managed service that allows you to get rid of the tedious management tasks and work that is related to databases.

By using Cloud SQL in GCP you will automate the maintenance activities, patching, and even high availability of your database instance without you actually configuring those.

This is a great value to get from this service and with the right configuration and #security practices around it, you can just set it up and forget about it!

Usually it is one of the easiest services to work with in GCP, however when it comes to connectivity and security many of us would start looking at workarounds or ways to get things done fast regardless of how secure and how good or bad they are…

And when things go bad with Cloud SQL, they really really go bad…

There are many options and ways you can fix this by only allowing certain public IP addresses to access the Cloud SQL instance (if you have it using public IP). But then what if you are using a home connection, or if you don’t have access to a static IP address?

Well in this case you will need to keep updating the authorized networks rule to ensure only the correct IP addresses are added and remove any old/obsolete IPs.

And again this is when things start to become annoying and cumbersome and the look for a workaround starts, regardless of how easy and secure it is.

Of course there is always a better solution..

This better solution is by using Cloud SQL Auth Proxy and combine it with #IAP (Identity-Aware Proxy).

You see these 2 things are 2 awesome services that will save your day, brain, and most of all, your data from any disasters and problems… provided you configure them right of course… and that’s what I’m going to show you now.

What is also awesome about Cloud SQL Auth Proxy is that it does work with all the Cloud SQL database types. #MySQL, #PostgreSQL, and #MSSQL!

In this video I will quickly brief you about Cloud SQL Auth Proxy. What is it, how does it work, and how to install it. And then I will show you how you can connect to a Cloud SQL instance using that and IAP to ensure everything stays private without assigning any public IP on any resource…
--------------------------------------
--------------------------------------
🔴🔴 Please don’t forget to like the video and subscribe as well! 🔴🔴
--------------------------------------
--------------------------------------
🔴✅ Video timeline and chapters:
- 00:00 - Introduction
- 01:00 - What are the benefits and use cases of Google Cloud SQL?
- 01:47 - Google Cloud SQL connectivity and configuration challenges
- 04:20 - Google Cloud SQL connectivity options and solutions
- 05:17 - How to enable connections to Google Cloud SQL using the private IP?
- 06:04 - What is Cloud SQL Auth Proxy?
- 06:43 - Why should you use Cloud SQL Auth Proxy to connect to Google Cloud SQL?
- 07:15 - Permissions requirements for Cloud SQL Auth proxy to connect to Google Cloud SQL
- 07:39 - How to download and install Cloud SQL Auth proxy
- 09:13 - What are the prerequisites to configure Cloud SQL Auth proxy to connect to Google Cloud SQL over its private IP address?
- 12:22 - How to configure Cloud SQL Auth proxy to connect to Google Cloud SQL over a private IP address from Google Compute Engine in GCP?
- 15:34 - How to use IAP (Identity-Aware Proxy) to connect to Cloud SQL Auth proxy without a public IP from outside GCP to access Google Cloud SQL
- 20:00 - Closing
--------------------------------------
--------------------------------------
✅ Links mentioned in the video:
- About the Cloud SQL Auth proxy | Cloud SQL for MySQL | Google Cloud: https://cloud.google.com/sql/docs/mys...
- Connect using the Cloud SQL Auth proxy | Cloud SQL for MySQL | Google Cloud: https://cloud.google.com/sql/docs/mys...
- GitHub - priyankavergadia/google-cloud-4-words: The Google Cloud Developer's Cheat Sheet: https://github.com/priyankavergadia/g...
--------------------------------------
--------------------------------------
📣✅ Other useful links:
- Follow me on Twitter:   / salehram87  
- Connect with me on LinkedIn:   / salehram  
- Check my website and blog: https://www.salehram.com
- Check out my Google Workspace Admin Course on Udemy and get it with a discounted price: https://www.salehram.com/gws-admin-tr...
--------------------------------------
--------------------------------------
📣✅ Interesting channels to follow and subscribe:
- Google Workspace -    / googleworkspace  
- Google Cloud Tech -    / googlecloudplatform  
- Google Cloud -    / @googlecloud  
- Learn GCP with Mahesh -    / learngcpwithmahesh  
- Saperis - Hands-on tutorials for Google Workspace apps -    / saperis