Relational Data with Cloud SQL and Cloud Spanner

Relational databases are a staple in most software systems. Historically, mission-critical databases have been one of the most high-stakes, operationally expensive aspects of maintaining live production systems. As organizations increasingly look to leverage managed services in the public cloud space, managed relational databases are a natural fit. Google Cloud Platform offers two such managed database services: Cloud SQL and Cloud Spanner.

In this chapter, we will cover the following topics:

• An overview of the Cloud SQL feature set
• A comparison of Cloud SQL and self-managed databases on GCE
• Creating and managing Cloud SQL instances
• Cloud SQL Proxy
• Connecting to Cloud SQL from App Engine
• Migrating existing databases to Cloud SQL
• Cloud Spanner – what it is and when to use it
• Creating and managing a Cloud Spanner instance
...