Understanding Cloud Spanner (UCS) - Lab Topology

 

Lab Topology

Creating Spanner Instances and Databases (Console)
  • Compare Spanner configuration options.
  • Create Spanner databases using the Console.
  • Create Spanner databases using the PostgreSQL dialect.
Creating Spanner Instances and Databases (CLI and Terraform)
  • Create instances and databases using the gcloud CLI.
  • Automate Spanner infrastructure using Terraform.
Choosing Primary Keys
  • Generate Spanner primary keys as UUIDs.
  • Convert counters and timestamps into values appropriate for Spanner primary keys.
Managing Relationships with Foreign Keys and Interleaved Tables
  • Create a relational database with proper primary keys and relationships optimized for Spanner
  • Leverage indexes to improve read performance in Spanner
Programming Spanner Applications with Python
  • Use Python to create and delete Spanner instances and databases.
  • Program Spanner databases that use the PostgreSQL dialect.
Running Queries and Transactions
  • Run parameterized queries using indexes against a Spanner database using the Python Client library.
  • Execute transactions against a Spanner database.
Deploying Spanner Applications with Cloud Functions and Cloud Run
  • Deploy Cloud Functions that read and write to Spanner databases.
  • Set up and use the Spanner emulator for development.
  • Build a REST API that allows you to read and write Spanner data.
  • Deploy a REST API to Google Cloud Run.
Migrating Data to and from Spanner with Dataflow
  • Write ETL pipelines using Apache Beam.
  • Run Apache Beam pipelines using Google Cloud Dataflow.
Leverage the Autoscaler Tool for Cloud Spanner to Achieve Workload Elasticity
  • Configure the Autoscaler and environment
  • Deploy the Autoscaler
  • Observe the autoscaling
Challenge Lab: Administering a Spanner Database
  • Create a Spanner database and import existing data.
  • Backup and restore the database.
  • Export Spanner data and import it into BigQuery.
  • Deploy a data access API that allows access to your Spanner database.
  • Use the Operations monitoring tools for dashboards, uptime checks, and alerts.