Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last Updated: Mar 27, 2024

Overview of Cloud Spanner

Leveraging ChatGPT - GenAI as a Microsoft Data Expert
Speaker
Prerita Agarwal
Data Specialist @
23 Jul, 2024 @ 01:30 PM

Introduction

Hello readers, we hope you are doing great.

In this article, we will discuss the Google Cloud Spanner. Google Cloud Spanner is a Google Cloud-based distributed relational database service. It is intended to support global deployments of online transaction processing.

Google Cloud Spanner

Cloud Spanner is a mission-critical relational database service that offers a global, scalable online transaction processing (OLTP) database with high availability and good consistency. Cloud Spanner supports typical relational semantics, such as schemas, ACID transactions, and SQL interfaces. For high availability, Cloud Spanner delivers automatic, synchronous replication inside and between regions (99.999%)

Benefits of Cloud Spanner

  • Automatic replication
  • OLTP (Online Transactional Processing)
  • Relational data mode
  • Global scale
  • Low latency
  • ACID/Strong or External consistency
  • Fully managed and highly available
Get the tech career you deserve, faster!
Connect with our expert counsellors to understand how to hack your way to success
User rating 4.7/5
1:1 doubt support
95% placement record
Akash Pal
Senior Software Engineer
326% Hike After Job Bootcamp
Himanshu Gusain
Programmer Analyst
32 LPA After Job Bootcamp
After Job
Bootcamp

Google Cloud Spanner Architecture

Spanner is a worldwide database system with a minimum of three shards per area. Each shard will be in a different zone. A shard is known as a Split in Spanner. If you provision a single Node Spanner cluster, you will receive two more Nodes in a separate zone that are invisible to you. Furthermore, the compute and storage layers are separated. The Paxos algorithm is used to keep one leader at a time and the rest of the nodes as followers.

Google Cloud Spanner Architecture

Image Source: thedataguy

We'll have more Splits (shards) in the storage layer based on the partitions. Each shard will be replicated across all Zones. For example, if you have S1 on Zone A, it will be replicated to Zones B and C. The replication method is based on the leader-follower model. As a result, the Paxos will assist in maintaining the quorum and in selecting a new Leader during the failure. The Spanner APIs are aware of the Leaders if you write something on this Split. As a result, the write is sent directly to the zone with the Leader Split. Each Split has its own zone for leaders.

Instance

The location and allocation of resources are determined by the instance. Instance creation involves two critical options:

  • Instance configuration
    • Specifies the geographical positioning of the databases, i.e. their location and replication
    • The location can be regional or multi-regional
  • Node count
    • Identifies the maximum amount of serving and storage resources that can be modified for the instance

To deliver high performance and availability, Cloud Spanner spreads an instance across zones in one or more regions. Instances of Cloud Spanner include:

  • At least three read-write database replicas, each in a distinct zone
  • Each zone represents a distinct isolation fault domain
  • The Paxos distributed consensus protocol is utilised for writes/transaction commits
  • Writes are replicated synchronously to all zones across all regions.
  • Even if one zone fails, the database remains operational (99.999% availability SLA for multi-region and 99.99% availability SLA for regional)

Regional vs Multi-Regional Configuration

Following are the benefits of choosing regional and multi-regional configurations:

Regional Configuration

  • Provides 99.99% availability
  • Cloud Spanner keeps three read-write replicas in that region, each in a distinct Google Cloud zone.
  • Each read-write replica has a complete copy of the operational database that can serve both read-write and read-only requests.
  • Every Cloud Spanner mutation necessitates a write quorum consisting of a majority of voting replicas. Write quorums are generated by combining two of the three regional replicas.
  • Cloud Spanner employs replicas in several zones to ensure that the database remains available even if a single zone fails.

Multi-Regional Configuration

  • Provides 99.999% availability
  • Multi-region configurations allow the database's data to be replicated not just across several zones but throughout multiple regions.
  • Multi-region configurations allow the application to perform faster reads in more locations at the expense of a slight increase in write latency.
  • Additional replicas provide for low-latency data reading from multiple sites around or inside the configuration's regions.
  • Because the quorum (read-write) replicas are distributed across multiple regions, additional network latency occurs when these replicas interact with one another to vote on writes.

Google Cloud Spanner Pricing

The cost for Google Cloud Spanner is based on three infrastructure components:

  • Nodes
  • Storage 
  • Networking

The pricing for nodes (or processing) in Cloud Spanner is established on an hourly basis, based on the maximum number of nodes used in any given hour in a project. Cloud Spanner storage is priced each month based on the average quantity of data in Cloud Spanner tables and secondary indexes during that month. Google Cloud Spanner network bandwidth cost is set per month based on the quantity used during that month.

Check this out, Spring Boot Architecture

Frequently Asked Questions

How many databases and tables can a Cloud Spanner Instance have?

A Cloud Spanner Instance may contain one or more databases and tables.

How to avoid single-region dependency for the workloads?

Place important compute resources in at least two areas to avoid workloads becoming dependent on a single region.

How does Cloud Spanner get replication?

Cloud Spanner obtains byte-level replication from the underlying distributed filesystem automatically.

Compare the latency in regional and multi-region configurations.

Regional setups offer lower write latencies within an area, and multi-region configurations offer lower read latencies from different geographic regions.

Conclusion 

In this article, we have extensively discussed the Google Cloud SpannerWe hope that this blog has helped you enhance your knowledge, to learn more, check out the awesome content on the Coding Ninjas Website:
Android DevelopmentCoding Ninjas Studio ProblemsCoding Ninjas Studio Interview BundleCoding Ninjas Studio Interview ExperiencesCoding Ninjas CoursesCoding Ninjas Studio Contests, and Coding Ninjas Studio Test SeriesDo upvote our blog to help other ninjas grow. Happy Coding!

Thank you image

Topics covered
1.
Introduction
2.
Google Cloud Spanner
2.1.
Benefits of Cloud Spanner
3.
Google Cloud Spanner Architecture
4.
Instance
5.
Regional vs Multi-Regional Configuration
5.1.
Regional Configuration
5.2.
Multi-Regional Configuration
6.
Google Cloud Spanner Pricing
7.
Frequently Asked Questions
7.1.
How many databases and tables can a Cloud Spanner Instance have?
7.2.
How to avoid single-region dependency for the workloads?
7.3.
How does Cloud Spanner get replication?
7.4.
Compare the latency in regional and multi-region configurations.
8.
Conclusion