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.
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.
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:
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.
Multi Regional Price(USD)
From $0.30 per GB per month
From $0.50 per GB per month
From $0.90 per node per hr
From $0.90 per node per hr
Cross-region and internet egress rates apply
Features of Google Cloud Spanner
Synchronous replication and maintenance are automatic and built-in. It provides an ease of deployment at every scale and every stage.
Purpose-built for external, strong, global transactional consistency.
The data is highly available for use at anytime from anywhere.
It is horizontally scalable across regions, rows, and continents from one to hundreds or thousands of nodes.
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
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.