Connect App Engine to Cloud SQL via Private IP - Google Cloud Serverless VPC Access

In this video you will learn what is Google Cloud Serverless VPC access (connector) and connecting app engine to cloud sql using a private IP.
Lot of references made from my previous video • Connect to Cloud SQL f...
Links used in the video:
cloud.google.com/vpc/docs/con...
github.com/cloudadvocate/goog...
----------
- Questions? Thoughts? Disagreements? Tell us here in the comments.
----------
- PLEASE SUBSCRIBE! / @cloudadvocate
Oh and follow me!
Facebook: / multicloudguy
Twitter: / multicloudguy

[@CloudAdvocate]

I have a mide a mistake and corrected it, I will see how many of you can spot it :). If you want to take a challange, please implement this with cloud function.👍

[@shashank2509]

2544131

[@Cloud-Radio]

will the serverless connector work with cloud composer for running sql script.

[@saeedhamad780]

@15:20 u did not delete the last letter "l" of the project name

[@sadhucat4476]

Such a better explanation than the video produced by Google. Subscribed!

[@canislatrans6606]

Very good and helpful Cloud Advocate !! The only thing is that the red letters on black background was not very clear. Congrats!

[@MrBharathkumarraju]

Good explanation :)

[@ihome33]

thank you!!

[@ramulusuddewar9655]

Hi GK, thanks for sharing this video. Connecting to Cloud SQL from appengine via private IP is the best approach. Let's assume Cloud SQL is already configured with only private IP. Can you please suggest what could be the best approach to connect from cloud shell in this case. And it will be great if you share any sample java project with same scenario. Thanks in advance.

[@GregorMaclaine]

Thanks

[@veerabhimanyusingh779]

hello sir, is there any way to initiate dataproc workflow-template (spark job workflow) using cloud function or workflows (beta)(cloud workflow)

[@mudassiridrees9935]

how can i do it with elastic search in could function ? any help

[@gonzoldyck787]

How about from Cloud Functions?

[@DevSense-qc5dz]

I had a question, I did the exact same thing but "Connector is in a bad state, manual deletion recommended See logs" is always shown, I have used the default, I don't have any overlapping services

[@patatedeoufleretour]

BTW I think the error was that you added a 1 at the end of the project name right ?

[@ektas4639]

Hi there, very helpful video. But I'm stuck at a point. After enabling API, when I create connector with exactly same details as explained by you - connector is getting created with an error - 'Connector is in bad state, manual deletion recommended. Region I'm using is asia-south1. Tried multiple times since yesterday, no luck! What can be the possible issue?

[@CloudAdvocate]

Hi Ekta, Looks like you are infact using the supported regions cloud.google.com/vpc/docs/configure-serverless-vpc-access#supported_regions. Could you please create a support ticket with Google cloud.

[@prashantpokhriyal6308]

Hello GK, can you help with Connecting App Engine Flex Env. to Cloud SQL via Private IP

[@pruthvihingu3733]

I think if-else... condition is swapped in main-pip.py.

[@saiteju8169]

Hi GK, I have a doubt, please clear this if possible:
I have a cloud run attached with serverless vpc connector and i am using db_host as a connection name instead of cloudsql private IP because my cloudsql instance is enforced with SSL certificates so to bypass this i am using /cloudsql/${connection_name} as a db_host variable to my application, so but my cloudsql instance is having both private and public ip addresses because some reasons, so does cloud run uses private ip to connect to cloudsql or public ip???
Thanks in advance

[@CloudAdvocate]

Great question 🙋 most likely it will use private ip.. personally haven’t tested this.

[@saiteju8169]

@@CloudAdvocate Thanks, do we have any reference docs related to this from Gcp? I tied but couldn’t find any such information from their official page 🙂

[@pruthvihingu3733]

while creating vpc connector, I am getting error: "Operation failed: Insufficient CPU quota in region." What I do?

[@CloudAdvocate]

Please try after sometime or create a support ticket.

[@pruthvihingu3733]

@@CloudAdvocate I am getting this error since 3-4 days. So, I will create a support ticket now. Thanks for the reply👍.

[@patatedeoufleretour]

Don't you lose the advantages of having a private IP address (security) if you set a public IP also ?

[@CloudAdvocate]

Yes! I must have done it to connect from cloud shell but you are right.

[@RahulSoni11]

wearing AWS t-shirt and Teaching about GCP..

[@CloudAdvocate]

😜

[@skylake9779]

this method is outdated and you have to set ENV_VARIABLES before building cloud run.