Deploy Laravel 9 on Google Cloud Run + Sql + MySql + Cloud Build

[@TheAntonioxr1]

Excelent Video!! I spend a day trying to deploy a docker container and only your video was clear and simple, Thank you so much!!

[@mcylinder]

Great job. I use a local DB for dev, then switch configs and run migrations when it's time to push to production. One tip I wanted to pass on is you can set a lot of ENV variables in your DOCKERFILE. I did that with my common values and then did the more critical ones (passwords, API keys) in the Google Cloud interface. (maybe 8 of them?). There's also a YAML file that gets created and that can also be revised.

[@mamenatech]

core question for LARAVEL. how run artisan command, & npm run prod? 🍔

[@DanielKyleb]

Thanks for this! I got this to work but how do I make the changes show up real-time in localhost?

[@thedanmwangi]

This is golden! 👏 What if your app has frontend libraries served with NPM? How can you install them in production?

[@VybzKartelClassics]

What if we bought a script on codecanyon how do we upload it to Google cloud platform? Could u make a video on that?

[@victorchinonsougwu1359]

Thank you for this, this worked like charm. I have a quick question tho how do I verify my SQL instance is connected and how do I run my artisan commands??

[@techman4396]

just test your sql with any desktop tool or create a controller and fetch some records.

[@victorchinonsougwu1359]

@@techman4396 That worked but my database didn't migrate to the cloud SQL and VARIABLES also didn't reflect, how would I go about that

[@cricrangers2511]

Even adding environmental variable is not working, despite every permission, seems like cloud sql for laravel is not working with cloud run

[@Michael_Andish]

And Mysql? how do you manage DB and connect to DB?!

[@skylake9779]

I put all env variables still getting this error "

[@code-island]

really useful, thanks

[@rustamergashev7278]

👍

[@rayaguilar9085]

Why set minimum instances to 1? Was that just so you could make it faster or will it not work with 0?

[@coolcha]

How to use local database for development locally using such a deployment workflow?

[@vincemcgaj628]

Thanks a lot! I tried CodeJets's method at first. Could not get it to work after multiple tries. Then I tried your method, it worked the first time around. Nice job.

[@vincemcgaj628]

Again, thanks for the help. Is there a way to run database migrations via "php artisan migrate --force" automatically when deploying to Cloud Build?

[@bylde4791]

@@vincemcgaj628 I am sure there is a way but remember google cloud run does not allow volumes so if you are trying to save a mysql database colume on google run then it wont work

[@vincentmcgargill8114]

@@bylde4791 I actually figured it out. To run migrations during deployment, you are supposed to add an additional step to your cloud build process (i.e. typically the cloudbuild.yaml file). Just have that step connect to the DB then run php artisan migrate --force. Works like a charm. Again, thank you for posting this video.

[@kansagous]

@@vincentmcgargill8114 Please share it :)

[@borknagarchile]

Did you get working the cloud mysql connection?

[@nadjinmalade8738]

thkx a loft for your video

[@techman4396]

hapy to help

[@valeriopucciarelli]

Hi, thank you for the video. I managed to deployed a laravel vue app on cloud run but the css / js files are not loaded. How can I solve this problem? it's the same If i copy the .env.example with a new command run in Docker file?

[@techman4396]

Can you share the URL of your GCP instance? Will need to check the root path for your js/css and then only I can help you.

[@valeriopucciarelli]

​@@techman4396 I solved the problem, when the app is online need to set the url with https and no http

[@ajawinery5504]

@@valeriopucciarelli how to setting with apps bro?

[@GtrsJohn]

Hi thanks for your video. It is not necessary to add a user in the dockerfile ?

[@JosueLMM]

and MYSQL?

[@abhishek0116]

@TechMan How much it cost you?

[@arifdevcoding]

Where is mysql?

[@frijai6720]

would you have a codeigniter 4 tutorial? please it's urgent

[@alanaprianto5059]

how to run laravel migration?

[@nnaemekanweke]

From the infrastructure setup for this video, the local environment is connected to the same database cloud run connects to. So you run your migration locally.

[@felipeveiga87]

is it more cheap than a vm ?

[@Peter-ue4iz]

I have the same question. How much would it cost to run a blog that has about 100,000 monthly visits?