Тёмный

Connect to Cloud SQL from App Engine in Google Cloud 

Cloud Advocate
Подписаться 155 тыс.
Просмотров 36 тыс.
50% 1

#appengine #gcp
Tutorial to connect Cloud SQL from App Engine in Google Cloud.
GitHub URL: github.com/cloudadvocate/goog...
- Commands Used:
gcloud sql connect gk-demo-utube --user=mastergk
create table demo_tbl(
demo_id INT NOT NULL AUTO_INCREMENT,
demo_txt VARCHAR(500) NOT NULL,
PRIMARY KEY ( demo_id )
);
insert into demo_tbl(demo_id,demo_txt) values(1,"hello guys, thanks for watching my video :)")
select demo_txt from demo_tbl;
----------
PLEASE SUBSCRIBE ➡️bit.ly/36x6qQy ❤️
BUY ME A COFFEE ☕bit.ly/3lumyqx
----------
PLAYLISTS:
- Associate Cloud Engineer Study Guide: bit.ly/37y1dYl
- Google Cloud Playlist: bit.ly/37uMZal
----------
- Questions? Thoughts? Disagreements? Tell us here in the comments.
----------
LETS CONNECT:
👍 Facebook: / multicloudguy
📸 Instagram - / multicloudguy
🐦 Twitter - / multicloudguy

Наука

Опубликовано:

 

12 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 107   
@CloudAdvocate
@CloudAdvocate 4 года назад
Thank you all for your support and warm comments!. Let me know if you are having any issue in the tutorial and don't forget to clean up the resources :)
@suhinshetty6125
@suhinshetty6125 4 года назад
Yes i would request you to show clean up of resources once tutorial is completed
@CloudAdvocate
@CloudAdvocate 4 года назад
Sure Suhin.
@rajaramsavant4384
@rajaramsavant4384 3 года назад
Very informative video. Thanks for uploading. Also, can u show how to connect to cloud sql server from java service(within gcp) ? Unable to find video on this.
@CloudAdvocate
@CloudAdvocate 3 года назад
Sure Rajaram, will try to work on that.
@sachinmengade9589
@sachinmengade9589 3 года назад
Great explanation as always GK..Could you please make a video on App Engine Flexible or share me the link if you already have one..Thanks :)
@adamtechdays
@adamtechdays 3 года назад
Your videos and advice are so valuable. My understanding of Google cloud has increased enormously by watching your videos and taking your advice. Great work sir!
@genacc2458
@genacc2458 3 года назад
You are a lifesaver!!! I dont normally comment but this video is so good, I have to! thanks!!
@chrisoaus5328
@chrisoaus5328 4 года назад
I spent all day trying to figure this out through the google docs. This step by step instructional was literally the most helpfull video ive watched for a while and got my app working. THANK YOU SO MUCH!
@CloudAdvocate
@CloudAdvocate 4 года назад
You're welcome!
@muralikrishna9499
@muralikrishna9499 4 года назад
Thank you for the video! I will try implementing it today!
@hankasiman9945
@hankasiman9945 3 года назад
Thanks very much four this video. I'm new with GCPI really need this video for my test deployment + mysql. This video really help me. Keep it up bro
@Chalbano
@Chalbano 3 года назад
I really needed this video a two years ago! lol Although today is gona late, before late than never! tks
@justkeepfilming9767
@justkeepfilming9767 4 года назад
Thank you so much for this video! Keep it up :)
@CloudAdvocate
@CloudAdvocate 4 года назад
no problem!
@EuroTravelDiaries
@EuroTravelDiaries 6 месяцев назад
this is the excellent video i have come across. thanks man.
@dimitreortt6972
@dimitreortt6972 4 года назад
Thank you very much for this helpful guide!
@CloudAdvocate
@CloudAdvocate 4 года назад
Glad it was helpful!
@kashishhgoel
@kashishhgoel Год назад
Thank you so much @Cloud Advocate for making this video. This made my job so much easier! If I could hit the like button more than once to show my appreciation, I would hit it a thousand times! Thank You!
@CloudAdvocate
@CloudAdvocate Год назад
You're welcome!
@RahulKumar-wc2on
@RahulKumar-wc2on 3 года назад
Amazing one..really helpfull
@skviknesh
@skviknesh Год назад
This was really helpful 🙏
@prashantjha3716
@prashantjha3716 4 года назад
Thanks buddy, It was really helpful.
@CloudAdvocate
@CloudAdvocate 4 года назад
You're welcome!
@sumon051
@sumon051 4 года назад
Great! Thanks for your video. Keep it up..:) . It helps a lot :)
@CloudAdvocate
@CloudAdvocate 4 года назад
You're welcome!
@subesingh7285
@subesingh7285 4 года назад
Excellent!!!!
@paracha3
@paracha3 3 года назад
Great videos
@alonewolf7682
@alonewolf7682 9 месяцев назад
great video
@lookergoog3034
@lookergoog3034 2 года назад
Solved MY PROBLEM WOOOHOOOO!
@stevenscholtz8013
@stevenscholtz8013 3 года назад
You are awesome, thank you
@CloudAdvocate
@CloudAdvocate 3 года назад
Happy to help!
@indrareddygayam3878
@indrareddygayam3878 4 года назад
Cool Content! Gk,can you please make a video on EKS , I am planning to work on it in one of my projects ☺
@CloudAdvocate
@CloudAdvocate 4 года назад
Sure Indra. Thank you 😊
@louis8935
@louis8935 3 года назад
Thanks alot can you make a tutorial on load balancers
@osamozilla7898
@osamozilla7898 Год назад
Two words : Thank You
@mahapappan9304
@mahapappan9304 3 года назад
Hi GK, that's a great guide and most appreciated. Continue posting more guides on GCP. Many are looking for such valuable info. The following points refers: 1/ I have an HTML file with 4 textboxes, 9 radio buttons and a submit button. 2/ I have GPC mySQL database setup with one table (tblCustomer). 3/ How can I connect to the mySQL database? Enabling data collection into the table when people hit the Submit button? Please advice. Thanking you in advance.
@CloudAdvocate
@CloudAdvocate 3 года назад
This is easy, create a basic PHP application and you can connect to database using that .
@cliosightsoftware9523
@cliosightsoftware9523 4 года назад
Hello, Thanks for making this video. Can you please make another one for Express js & Node js connecting to MySQL and querying DB from code?
@CloudAdvocate
@CloudAdvocate 4 года назад
Noted
@LatheshBl
@LatheshBl 3 года назад
Thanks for the tutorial, can you please explain how to access cloud sql from Dataproc
@manukm07
@manukm07 3 года назад
Thanks for the video. Can you please show how to connect to ClodSQL for Postgres from Cloud Function via CloudSQL proxy
@sachinmengade9589
@sachinmengade9589 3 года назад
Great explanation as always GK..Could you please make a video on App Engine Flexible or share me the link if you already have one..Thanks :)
@CloudAdvocate
@CloudAdvocate 3 года назад
Will do Sachin.
@sanketparab5090
@sanketparab5090 3 года назад
Thanks for your video...Can you please make video on proxy sql
@CloudAdvocate
@CloudAdvocate 3 года назад
Sure will do.
@thecloudterminal
@thecloudterminal Год назад
Thank you for creating this amazing video
@shubhk108
@shubhk108 4 года назад
Hello sir thanks for this video, and I'm requesting you to plz make video on eclipse plz sir, I appreciate your efforts thank you so much in advance
@CloudAdvocate
@CloudAdvocate 4 года назад
Sorry mate, that doesn't fall under my niche. May be in future.
@raweewanpraparaweewan4088
@raweewanpraparaweewan4088 4 года назад
Thank you for the video! May I ask you some question? I would like to know if I can run this app locally or not? Deploying app engine is take so long time...
@CloudAdvocate
@CloudAdvocate 4 года назад
Yes, you can install python app from your server and connect to cloudsql
@Cloud-Radio
@Cloud-Radio 2 года назад
public cloudsql is rare ..no one uses it because of security concerns...but cool !!
@richardroach45
@richardroach45 3 года назад
Thanks Great Video - can the GIT Postgres connection file, they appear to be deprecated from your repo.. Can you also create a connection video on the Serverless VPC connecting to Postres thro the connection name.
@meteordzgaming3251
@meteordzgaming3251 4 года назад
the one and only video i learned so mush in thank u so mush im just having troubles connecting to database ;im using php can u help me plz ????
@CloudAdvocate
@CloudAdvocate 4 года назад
Thank you, what is the issue you are facing with PHP?
@meteordzgaming3251
@meteordzgaming3251 4 года назад
I cant connect to the cloud sql idk why I guess it's about the app.yaml file ( I made at first a database handler file and it didnt work) so plz help me as soon as you can it's my graduation project
@alanwongsiulun6452
@alanwongsiulun6452 3 года назад
thanks alot sir. Would you make one for Django? thanks alot
@CloudAdvocate
@CloudAdvocate 3 года назад
There is a very good tutorial on that here: cloud.google.com/python/django/appengine
@Ankit-Cloud
@Ankit-Cloud 2 года назад
Can you please make a video on how to configure and deploy your application on compute engine ?
@antoinecompagnie6640
@antoinecompagnie6640 4 года назад
Thanks for this very insightful video! Keep up! Just a question: how to connect to Cloud SQL from COMPUTE engine? I have a python script that runs twice a month which would be happy to update the database (rather than updating a csv, then dump it into the database (something I haven't even done yet)).
@CloudAdvocate
@CloudAdvocate 4 года назад
From compute engine it would be even easier. After you install your app try connecting to sql database using driver. If firewall is proper...it should work. Let me know if you run into issues.
@louis8935
@louis8935 3 года назад
@@CloudAdvocate wat do u mean using driver
@summetprajapati9229
@summetprajapati9229 2 года назад
thanks! how to connect multiple databases ?
@darrennienaber6488
@darrennienaber6488 9 месяцев назад
Hi there, has there been any video content regarding nodejs and cloud sql? I found this in my search and was wondering if it ever came to fruition?
@vrajendramandloi5917
@vrajendramandloi5917 3 года назад
Hi buddy do you have anything for connecting from cloud run to cloud sql
@webeltech8755
@webeltech8755 3 года назад
Hey. I have an angular frontend with a spring boot rest API as a backend using MySQL database instance on Google cloud. I have deployed both the front and back end to Google cloud app engine but I can't figure out how the front end can talk to the backend while on Google cloud. Please guide
@GabrielTaraIvaldi-
@GabrielTaraIvaldi- 2 года назад
hello, I want to ask how do I deploy my custom machine learning and connect it to Compute Engine? and what if I use app engine instead of compute engine? please help for me as a beginner
@debjyotibanerjee7750
@debjyotibanerjee7750 2 года назад
Can we move our application deployed in app engine flex env to a different zone, cause I am getting a constant error while trying to deploy the changes that resources in my zone is not available enough, so can I move it to different zone?
@ManishKumar-pr7hs
@ManishKumar-pr7hs 4 года назад
i need your your help. If you have an idea of "nested virtualization" on gcp. Please make video on it (Windows Server Desktop and Linux) and install guest os in Virtual Machine.
@CloudAdvocate
@CloudAdvocate 4 года назад
Sorry Manish, never tried it. Let me see if I can try.
@folksupport1668
@folksupport1668 3 года назад
I have firebase data and i wanted to transfer entire that data to cloud postgresql is there any possibility, can you guide me
@debjyotibanerjee7750
@debjyotibanerjee7750 2 года назад
Is this flow completely production level?
@jeganchandrashaker4870
@jeganchandrashaker4870 2 месяца назад
Hi can you please explain about how to deploy our react js project with backend databases
@santiagoandresortiz5563
@santiagoandresortiz5563 2 года назад
great video....i have a question....i have a python script where i connect to an instance in my google cloud console. if i run it it works fine. But when i try to run the script using google app engine in the same project as the sql instance....it wont let me connect....please help
@billinginsuranceshreeaaiji9934
@billinginsuranceshreeaaiji9934 3 года назад
I developed the project using spring boot but not able to connect to cloud SQL. googled it to service account issue, but not sure how to fix it. Can you help?
@arvindrawat4520
@arvindrawat4520 4 месяца назад
Sir, I have a data in GCP. How to transfer data from GCP to power app and power automate.
@raghavendrac1053
@raghavendrac1053 2 года назад
how to host the spring boot application with mysql database with so many tables in google cloud .Please make vedio on this
@aryanurnh2309
@aryanurnh2309 Год назад
what if you have already deployed app status 502 bad gateway?
@prasad-space
@prasad-space 2 года назад
We should use --no-promote
@sunilchandran4u
@sunilchandran4u 3 года назад
--no-promote is the flag to use if no immediate traffic redirection required.
@muhammadshahzadanwar6166
@muhammadshahzadanwar6166 2 года назад
How did this worked mine is not importing pymysql. Did I miss something?
@juanmatusg
@juanmatusg 3 года назад
Is it possible to do it with SQL Server?
@CloudAdvocate
@CloudAdvocate 3 года назад
Yes sir
@himanshusingal527
@himanshusingal527 Год назад
Hello Sir, I have my node js app in which I have used knex js to write migrations and I am calling "npx knex migrate:latest" command in postinstall package.json scripts but the issue is as I added this command to run migrations and run command "gcloud app deploy" my build started failing with timeout error the database server is hosted in google cloud sql and app is deployed on app engine, please help me with the solution
@canislatrans6606
@canislatrans6606 Год назад
Congratulation! Great video. I get an error Can't connect to MySQL server. Temporary failure in name resolution . I cerated a new project, new database, table, new App Engine Service. Both mySQL server and GAE are in the same region us-central. Also, I gave permission to the App Engine service account of Google SQL Admin and Enabled SQL API. Any clue? do you have another video giving permissions to App Engine ? any help will be wonderfil. Thanks!
@shankarganesh2842
@shankarganesh2842 Год назад
No promote flag for not sending traffic even deploying the app
@nehapinky9914
@nehapinky9914 4 года назад
--no-promote is the flag
@CloudAdvocate
@CloudAdvocate 4 года назад
Yes
@iamtafara
@iamtafara 3 года назад
Howdo i donne using php
@CloudAdvocate
@CloudAdvocate 3 года назад
Pretty similar as far as configurations are concerned.
@user-qi4cu9le4l
@user-qi4cu9le4l 9 месяцев назад
ans is - --no-promote
@clinton11994
@clinton11994 3 года назад
socket connections are bad in production, TCP connection demo would have been better.
@CloudAdvocate
@CloudAdvocate 3 года назад
Appreciate your feedback..will try to work on it in the upcoming ones.
@shashikiran5015
@shashikiran5015 3 года назад
Hi GK, Thanks for the video, I have followed this process completely. but after executing the gcloud app deploy the URL , is not showing me any result. Can you help me with this what might be the error here. Can't reach the page. Please help..
@CloudAdvocate
@CloudAdvocate 3 года назад
What's the error you see in app logs? Either in console or command line
@shashikiran5015
@shashikiran5015 3 года назад
@@CloudAdvocate I got it after that it is due to port number and is working now . Thanks for your video which helped me ...
@shashikiran5015
@shashikiran5015 3 года назад
@@CloudAdvocate can you suggest any devops course with GCP in any e-learning website if have info...
@shashikiran5015
@shashikiran5015 3 года назад
@@CloudAdvocate GK again facing error as it is throwing "error didnot detect your browser. " go to this link like that some link came but still that link is not working. Not sure where I am going wrong. Pls help me...
@ManishKumar-pr7hs
@ManishKumar-pr7hs 4 года назад
please udpate me.it's urgent.
@CloudAdvocate
@CloudAdvocate 4 года назад
I am sorry, I don't know.
@hendrickrolandocalderonagu7312
@hendrickrolandocalderonagu7312 4 года назад
ERROR 1045 (28000): Access denied for user 'xx'@'xxxx.xxxx.xxx.xxx.' (using password: YES)
@CloudAdvocate
@CloudAdvocate 4 года назад
Did you check the settings of RDS if you have allowed ?
Далее
Google Cloud Functions - Serverless in GCP
17:52
Просмотров 22 тыс.
Picking the right serverless platform (Part 1)
14:02
Просмотров 14 тыс.
Connect GCP Cloud SQL with Python
30:25
Просмотров 18 тыс.
Database Configurations with Google Cloud SQL
16:47
Просмотров 62 тыс.
Google Cloud - App Engine Tutorial For Beginners
46:05
Run your React app on Google Cloud
16:28
Просмотров 16 тыс.
Собери ПК и Получи 10,000₽
1:00
Просмотров 2,4 млн