Cloud SQL and Spanner

Question 1

Cloud SQL Max Storage

Answer 1

64 TB

Question 2

Cloud SQL IOPS

Answer 2

60,000 IOPS

Question 3

Cloud SQL RAM

Answer 3

624 GB RAM

Question 4

Cloud SQL Options (SQL types available)

Answer 4

MySQL, PostgreSQL, MS SQL Server 2017 or 2019

Question 5

How to Configure for High Availability

Answer 5

Synchronous replication

Question 6

Cloud SQL Misc Features (Who admins what features)

Answer 6

Patches and updates automatically applied
You admin MySQL users
Automated or on demand backups

Question 7

Cloud SQL Decision Chart (use numbers)

Answer 7

1st: Need relational? Yes
2nd: Max 64 TB, Max 4000 concurrent connections, location management -> If no to any, Cloud Spanner
3rd: Specific OS reqs, Custom DB config reqs, special backup reqs -> If no to any, use a VM with DB installed

Question 8

Cloud SQL Vs Cloud Spanner Data

Answer 8

64 Terabytes vs ?? Petabytes

Question 9

Cloud Spanner Misc Features

Answer 9

Horizontal scaling
Strong consistency, high availability

Question 10

Cloud Spanner Decision Chart (high level, no numbers)

Answer 10

Use Cloud Spanner if any of the below:
-Outgrown single instance RDBMS
-Sharding for DB throughput
-Need transactional consistency
-Global data+strong consistency
-DB consolidation