Creating and Administering Google Cloud Spanner Instances

This course covers practical aspects of working with Cloud Spanner, Google’s proprietary relational database management system (RDBMS) service. It is the only globally distributed, strongly consistent RDBMS with horizontal scaling.
Course info
Level
Beginner
Updated
Jan 16, 2019
Duration
1h 59m
Table of contents
Description
Course info
Level
Beginner
Updated
Jan 16, 2019
Duration
1h 59m
Description

Relational Databases have traditionally relied on vertical scaling, but Google’s Cloud Spanner is carefully architected to provide horizontal scaling and global replication with all the rigors of strong consistency. Because Spanner is such a unique product, getting the best out of it does require you to understand its subtleties. In this course, Creating and Administering Google Cloud Spanner Instances, you will gain the ability to identify when Spanner is the right tool for you, and then correctly design your data and configure your instance to get the best out of Spanner’s formidable capabilities. First, you will learn where Cloud Spanner fits in the suite of Google Cloud Platform (GCP) storage technologies and how it compares to BigQuery, Cloud SQL, and others. Next, you will discover Spanner’s data model and how it enables horizontal scaling. Finally, you will explore how to use Spanner in conjunction with other GCP services, notably Dataflow templates, for migrating data into Spanner. When you are finished with this course, you will have the skills and knowledge of Cloud Spanner needed to architect solutions to problems that require global replication, strong consistency, and horizontal scaling in a relational database management system (RDBMS).

About the author
About the author

An engineer and tinkerer, Vitthal has worked at Google, Credit Suisse, and Flipkart and studied at Stanford and INSEAD. He has worn many hats, each of which has involved writing code and building models. He is passionately devoted to his hobby of laughing at his own jokes.

More from the author
More courses by Vitthal Srinivasan
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, my name is Vitthal Srinivasan, and I'd like to welcome you to this course on Creating and Administering Google Cloud Spanner Instances. A little bit about myself first. I have Masters degrees in financial, math, and electrical engineering from Stanford University and have previously worked in companies, such as Google in Singapore and Credit Suisse in New York. I am now co-founder at Loonycorn, a studio for high-quality video content based in Bangalore, India. Relational databases have traditionally relied on vertical scaling, but Google's Cloud Spanner is carefully architected to provide horizontal scaling and global replication with all of the rigors of strong consistency. In this course, you will gain the ability to identify situations when Spanner is indeed the right tool for you to choose and then correctly design your data and configure your instance to get the best out of Spanner's formidable capabilities. First, you will learn exactly where Cloud Spanner fits in the suite of GCP storage technologies and how it compares to BigQuery, Cloud SQL, and others. Spanner, like Cloud SQL, is an RDBMS service on the GCP, which means that it guarantees the ACID properties of atomicity, consistency, isolation, and durability. However, Spanner differs from Cloud SQL in important ways. Cloud SQL supports MySQL and Postgres, but Spanner is Google-proprietary. Cloud SQL is regional, where Spanner can be configured to replicate globally. Next, you will discover Spanner's data model and how it enables horizontal scaling. Here the key is the concept of a split, which can be thought of as a group of rules from related tables that can be moved around independently by the platform. The idea of physically storing data from different tables together is called interleaving, and this is a key driver of the design and architecture of Cloud Spanner. Finally, you will explore how to use Spanner in conjunction with other GCP services, notably Dataflow templates for migrating data into Spanner. Spanner was developed for use within Google several years before it was made publically available. Consequently, the migration path into Spanner was not quite clear initially. However, with the addition of Google- supported Dataflow templates, that concern has been substantially addressed. When you're finished with this course, you will have the skills and knowledge of Cloud Spanner needed to architect solutions to problems that require global replication, strong consistency, and horizontal scaling in an RDBMS.