I know that this will save me thosands of $ when I understand and then implement it! Thank you. I will now work on the tools necessary to make this happen!
hi, you have a local machine on google service (apache) and also you are connecting google local machine with google MySQL right? (like two different machines) . If I'm not wrong we can also connect google MySQL with a different server from any hosting company with a website IP or we can just connect on our localhost ?. btw thank you for the informative video.
In this video I'm connecting a compute engine VM with the cloud sql instance. But you could connect to the cloud sql instance via a local machine or remote machine on a third party hosting provider.
It's paid but GCP generally adheres to a relatively "perfectly metered pricing model" meaning you pay for what you use. That being said, the cost of standing up the SQL instance in this tutorial was ~$1.5/day USD. The specs on this instance were - Cloud SQL for MySQL: Zonal - 1 vCPU + 3.75GB RAM in Americas i.imgur.com/rzeDWCF.png You could adjust the zone and vm resources to perhaps reduce this cost based on your needs. As you scale your database you can expect some sort of commensurate rise in costs. This may seem pricey but again the trade of is that it's a fully managed solution so you eliminate dev ops costs.
MySQL or NoSQL which do you prefer? Let me know below. 👇🏿
both
Mysql
I know that this will save me thosands of $ when I understand and then implement it! Thank you. I will now work on the tools necessary to make this happen!
It's a great way to go for scaling your mysql DB.
3:46 from where i can get this php page (from the lamp stack page)??
hi, you have a local machine on google service (apache) and also you are connecting google local machine with google MySQL right? (like two different machines) . If I'm not wrong we can also connect google MySQL with a different server from any hosting company with a website IP or we can just connect on our localhost ?.
btw thank you for the informative video.
In this video I'm connecting a compute engine VM with the cloud sql instance. But you could connect to the cloud sql instance via a local machine or remote machine on a third party hosting provider.
Thank you
You're welcome
does this kind GCP's service free or paid?
It's paid but GCP generally adheres to a relatively "perfectly metered pricing model" meaning you pay for what you use. That being said, the cost of standing up the SQL instance in this tutorial was ~$1.5/day USD. The specs on this instance were -
Cloud SQL for MySQL: Zonal - 1 vCPU + 3.75GB RAM in Americas
i.imgur.com/rzeDWCF.png
You could adjust the zone and vm resources to perhaps reduce this cost based on your needs. As you scale your database you can expect some sort of commensurate rise in costs. This may seem pricey but again the trade of is that it's a fully managed solution so you eliminate dev ops costs.