Chapter 9. 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 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