Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Cloud SQL Pricing

I am an avid user of Amazon AWS but I am not sure about the RDS as compared to Google's Cloud SQL. In this site - it is mentioned that Per Use Billing Plan exists.

How is that calculated? It is mentioned 'charged for periods of continuous use, rounded up to the nearest hour'.

How does it go? If there are no visitors to my site there are no charges, right? What if I say I have 100 continuous users for 30 days. Will I still be billed $0.025 per hour (excluding the network usage charges)?

How do I upload my present SQL database to Google Cloud service? Is it the same way as Amazon using Oracle Workbench?

Thank you

like image 588
user3173207 Avatar asked Mar 10 '14 14:03

user3173207


People also ask

Is GCP Cloud SQL free?

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won't be charged until you upgrade.

Is Google Cloud SQL good?

It is one of the excellent database to use. Google cloud SQL delivers high performance and scalability . Cloud service is best way to manage varieties of databases like (MYSQL, PostgreSQL, SQL server). It is very to use and easy to setup.

Does Google Cloud use SQL?

Cloud SQL is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud Platform. You can use Cloud SQL with MySQL, PostgreSQL, or SQL Server.

Is PostgreSQL free on Google Cloud?

Unfortunately, though, Postgres isn't included in the “Always Free” products that Google offers and so we will be limited to the 3-month “Free Trial” option for the purposes of this article.


2 Answers

Using the per use billing, if your database isn't access for 15 minutes then it is taken offline and you are only charged for data storage ($0.24 per GB per month). Its brought back online the next time it's accessed, which typically takes around a second for a D1 instance. The number of users doesn't affect the charge: you are charged for the database instance, not the user.

More details here https://developers.google.com/cloud-sql/faq#how_usage_calculated

More information on importing data here: https://developers.google.com/cloud-sql/docs/import-export

like image 81
Joe Faith Avatar answered Oct 20 '22 18:10

Joe Faith


For Google Cloud SQL, I think we need to differentiate the MySQL 1st generation and the 2nd generation. In this FAQ link (answered by Joe Faith), https://developers.google.com/cloud-sql/faq#how_usage_calculated, it is about the 1st generation with activation policy of ON_DEMAND, meaning that you are charged per minute of usage.

However, with MySQL 2nd generation (as answered by Se Song), it will charge you entirely every minute (24 h per day) regardless whether you have active connections or not. The reason is that it uses the instance with activation policy = ALWAYS. You can read more the pricing details in here: https://cloud.google.com/sql/pricing/#2nd-gen-pricing

like image 26
Hung Nguyen Avatar answered Oct 20 '22 18:10

Hung Nguyen