Google pricing for SQL

[Anthony Griffith]

Hi there, 

I am trying to understand how the google pricing works for SQL. I am quite surprised by the charges I got and working out if I have done something wrong. 

I just set up an instance, did some migrations, seeding etc and noticed the pricing I got and data in the chart. I attached some images.

Also, the chart shows 1.245G of usage, is this for keeping a connection? 

So far its 7e for just that? I am one person who is using it at the moment. This is only for 2 days or so. 

Is this right? What if I get 100 or 1000 users using it regularly? is that going to be 7000e per day? 

Best regards

 

[David (Google Cloud Support)]

Hello,

You can find information on how you are getting charged when using GCP’s Cloud SQL [1]. It firstly depends on the instance type, whether it is SQL Server, MySQL Second Generation, PostgreSQL, or MySQL First Generation. Secondly, depending on the instance type that you have, different categories of charges will apply as indicated in the documentation.

From the first screenshot you provided, I am not sure what you mean by connection, but it indicates the amount of storage you have used from all your instances in Cloud SQL;it is normal that you are getting billed, as storage is one of the few charges that are being applied. Know that GCP products are charged by resource usage, so it should be expected that the more resources are being spent, the higher the bill is gonna be.

If you are worried about using too many resources as the number of users grow, you can set limits through Cloud SQL’s quotas [2] to make sure that you are not spending resources you judge should not be spent.

[1] https://cloud.google.com/sql/pricing

[2] https://cloud.google.com/sql/docs/quotas

[Anthony Griffith]

Hi David 

Thanks for the reply. I had a look at the pricing, I have a screen grab of what the pricing should be as they state, and what I have set up. However the charge of 7e makes no sense as at that rate I am going to be charged 140e not 50e. I only spun up an instance and did a migration, with no data. There is hardly any Egress (I am the only one using it as testing). I also should be on micro not standard so that should reduce the price somewhat.

Also please look at the graph, (SQL storage used) how could be at 1.222G (or over) when all I have done is create an instance and put 3 tables in there and no data. Does this graph represent keeping the instance always on? Does this mean traffic? Its always climbing, despite inactivity. What storage could I possible have used? (That storage dip is when I created a new instance, but once again it rises without any activity)

Best regards

[noverlyjoseph]

Hi Anthony, 

I can see you’re using the `db-n1-standard-1` Instance from your screenshot. And you’ve used it for 96 hours. That instance is priced at $0.1158 USD per hour[1](for MySQL), therefore for 96 hours it’ll be ~ $ 11.12 USD which will explain your € 7.08 charges. For a month (24 * 30 = 720h), as you can see from the documentation[1], the `Sustained Use Price` is lower per hour, therefore you will only be charged 0.0811 per hour, which would keep the price within the estimated price from the calculator.

Cloud SQL does offer smaller machine types: `db-f1-micro` and `db-g1-small` if the price is a concern for you at the moment.

The `movement` you see in the graph for Storage is related to the Instance doing the automatic backups.

[1] https://cloud.google.com/sql/pricing#2nd-gen-instance-pricing