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

[@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

[@ScrolltheNature]

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

[@juleslkd2480]

Perfect explanation and all in just 17min. I spent hours on Google docs trying to figure how to achieve this.Thank you man 👍

[@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!

[@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.

[@MrBharathkumarraju]

Good explanation :)

[@patatedeoufleretour]

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

[@veerabhimanyusingh779]

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

[@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 🙂

[@prashantpokhriyal6308]

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

[@ihome33]

thank you!!

[@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.

[@mudassiridrees9935]

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

[@gonzoldyck787]

How about from Cloud Functions?

[@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.

[@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👍.

[@GregorMaclaine]

Thanks

[@pruthvihingu3733]

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

[@skylake9779]

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

[@RahulSoni11]

wearing AWS t-shirt and Teaching about GCP..

[@CloudAdvocate]

😜