×

Log In

Manage Your Large Organizational Database with Google Cloud Spanner

Google Cloud Spanner focuses on the cloud database's ability to provide both availability and consistency. It has three Infrastructure Components Nodes, Storage and Network.

Manage Your Large Organizational Database with Google Cloud Spanner
25th May, 2023

Google Cloud Spanner is a distributed Relational Database management service that basically runs on Google Cloud. It is designed to support globally with online processing databases. SQL semantics, highly available horizontal scaling and transactional consistency for the mission-critical transaction. Google Cloud Spanner focuses on the cloud database's ability to provide both availability and consistency.

Google Cloud Spanner comes up with promising features unheard-of in the space of relational databases, such as horizontal scalability virtually unlimited and service-level agreement (SLA) 99.999% with no planned Down Time along with Enterprise-Grade Security.  

SEE ALSO:



In quest of providing System Availability and Data consistency, Google cloud Spanner Combines NoSQL and SQL traits.


Google Cloud Spanner Pricing 


Google Cloud Spanner is based on three Infrastructure  components:

  1. Networking

  2. Storage 

  3. Nodes


Google Cloud Spanner pricing for nodes is set on an hourly basis, which is based on the maximum number of nodes used within any given hour for a  project. Pricing for Google Cloud Spanner storage is set on a per-month basis, which is based on the average amount of data in secondary indexes and Cloud Spanner tables during that month. Cloud Spanner pricing for network bandwidth is set on a per-month basis, which is based on the amount used during that month.


Pricing list


Feature 

Regional Price(USD)

Multi Regional Price(USD)

Storage

From $0.30 per GB per month

From $0.50 per GB per month

Nodes

From $0.90 per node per hr

From $0.90 per node per hr

Network Egress 

Cross-region and internet egress rates  apply


Network Ingress

Free



Features of Google Cloud Spanner


  1. Synchronous replication and maintenance are automatic and built-in. It provides an ease of deployment at every scale and every stage.


  1. JDBC driver is used for connectivity with popular third-party tools. Client libraries are in Java, Node.js, PHP, Python, C#, Go, and Ruby. 


  1. Purpose-built for external, strong, global transactional consistency.


  1. The data is highly available for use at anytime from anywhere. 


  1.  It is horizontally scalable across regions, rows, and continents from one to hundreds or thousands of nodes.


  1. It provides everything expected from relational databases such as Relational Database Schemas, Acid Transaction and SQL Queries(ANSI 2011).


Why Cloud Spanner Over Cloud SQL


  • Horizontally scalable

  • When data size exceeds 10 TB.

  • Heavy usage with (QPS) query per seconds exceeding 5000.

  • User can use in Multiple Regions. 


Facts to Consider when deciding to move to Spanner:


  • Spanner is not ANSI SQL compatible

  • It doesn’t provide full RDBMS functionalities

  • It has its own set of APIs not compatible with existing DB APIs

which implies, once you port your code to Spanner, you cannot go back to MySQL or similar databases, without rewriting a major part of it.





Trendy