Understanding Google Cloud SQL Pricing

Hi and welcome to Database DevOps Academy #3!

Each week, we share Database DevOps insights and best practices for modern engineering organizations. If you enjoy this newsletter, we ask you to subscribe and share. ??

In this Issue, we are diving deep into how Google Cloud SQL Pricing works. Enjoy!

Google Cloud SQL is a popular database service from Google Cloud. It offers completely managed relational databases for MySQL, PostgreSQL, and Microsoft SQL Server with rich extension collections, configuration flags, and developer ecosystems. Apart from features, pricing is another core factor to consider when comparing it with other similar services like AWS RDS and Microsoft Azure SQL Database. Also, there are several discussions on Reddit related to the pricing of Google Cloud SQL, as shown in the figure below. These all point to the importance of understanding the structure of Google Cloud SQL pricing.

Google Cloud SQL Pricing

Pricing for Google Cloud SQL is based on a pay-as-you-go model. The price varies among different instance types and regions:

• CPU and memory pricing
• Storage and networking pricing
• Instance pricing (only applicable to shared-core)
• License pricing (only applicable to SQL Server)

CPU and Memory Pricing

Pricing for CPUs and memory varies based on the following three primary factors:

• The volume of CPUs you choose
• The total memory you select
• The region where your instance is located

If you enable other services, the total cost may include those charges:

• Failover replicas pricing
• Read replicas pricing
• High Availability pricing

In addition, Cloud SQL provides committed use discounts (CUDs) that grant deeply discounted prices for continuous use of database instances in a particular region for a one-year or three-year term. CUDs only apply to CPU and memory pricing. For more information, go to review Committed use discounts .

Storage and Networking Pricing

Storage and networking pricing is influenced by the following elements:

• The destination of the egress traffic
• The region where your instance is located
• Whether or not High Availability(HA) is configured

Instance Pricing

Instance pricing is only relevant for shared-core instances. It is charged for every second that the instance is running with the activation policy being set to “always”. For more details, see Billing on partial seconds .

License pricing (for SQL Server)

SQL Server License Pricing is based on the selected edition. SQL Server instances are charged a 10 minute minimum for licenses. After 10 minutes, SQL Server licenses are charged in 1 minute increments.

Tools for Estimating Google Cloud SQL Pricing Cost

Given the pricing complexity, there are tools to help you estimate pricing easily.

Official Pricing Calculator

Pricing Calculator is the offical tool from Google Cloud. It enables you to estimate Google Cloud SQL cost with different configurations. After selecting the database engine, enter required information such as the number of instances, instance type, and location, and click ADD TO ESTIMATE to generate the result.

DB Cost

DB Cost is an open source pricing comparison tool for Google Cloud SQL and AWS RDS. It can provide estimates of a set of instances according to your configurations, such as database engines, billed models (on demand and reserved), multiple locations, and the lease length.

What's more, DB Cost allows you to compare two selected instances in a more intuitive way, as shown in the following figure.

Tips for Optimizing Google Cloud SQL Pricing Cost

As mentioned above, one of the biggest concerns raised by reddit discussions is how to optimize Google Cloud SQL cost. Here are some common tips:

• Watch out the disk space: Google Cloud SQL has a unique feature called automatic storage increases . You should monitor the disk space to spot any abnormal disk increase.
• Watch out the network egress cost: The egress cost could be outrageous. Usually you should try to co-locate your app server with the database in the same region to avoid any cost. If that's not possible, you may consider aggregating request or batching data transfer.
• Take advantage of discounts for reserved instances: Cloud SQL offers committed use discounts that give you a considerable discount for one-year / three-year commitment.
• Delete idle instances: It is well known that idle or abandoned resources are one of the biggest sources of waste in cloud spending. To reduce your cloud cost, it is absolutely necessary to delete idle instances. Watch our for those ephemeral testing database instances.
• Resize overallocated instances: Over-provisioning resources is common for DBAs who are used to provisioning larger instances on-premises. However, it can lead to unnecessary spending when migrating to the cloud platform. The smart way to optimize your cloud cost is to identify your resource requirements and scale instances accordingly.

Summary

Google Cloud SQL is a great choice for organizations that need a full-managed relational database service. In order to get the best value for your money, it is essential to understand the pricing structure of Google Cloud SQL.

Besides optimizing cloud database cost, teams also want to make better use of the purchased databases. To achieve that, you can check out our open source project Bytebase. Bytebase supports 10+ OLTP, OLAP, NoSQL databases including all three Google Cloud SQL databases, MySQL, PostgreSQL, and SQL Server. It's an all-in-one platform for developers, DBAs, and platform engineers to manage the database development lifecyle efficiently and reliably. You can sign up at Bytebase Cloud or self hosting with a single command to try it out.