| Features | Size | Latency | Comparable | |
| Cloud SQL | Managed MySQL, PostgreSQL and SQL Server | Up to 30TB | ||
| Cloud Spanner | Unlimited scale relational database | PB | Regional Low Latency R/W Multiregional Low Latency Read | Oracle DynamoDB |
| Cloud Bigtable | No-SQL, Key Value, Low Latency | PB | < 10ms | HBase Cassandra |
| Firestore (Datastore) | No-SQL, document based, key:value pairs | PB | >10ms | |
| Firebase | ||||
| Memory Store | In-memory, managed Redis and Memcached compatible | Reids:300GB Memcached:5TB | <10ms |
Cloud SQL Notes and Best Practices
- Encrypted and have automatic backup available.
- Data replication and automatic failover between zones
Cloud Spanner Notes and Best Practices
- Globally replicated ensures very high availability (99.999%)
- Strong consistency across all replicas as well as external consistency (commit order is preserved)
- Local availability for better response times
- Regional instances replicate across 3 zones.
- Multi-Regional instances replicate across multiple regions. This allows for read latency to be maintained but write latency is impacted due to the mechanisms to ensure consistency.
- Place read-write workloads with read-write replicas, read-only workloads with read-only replicas
Bigtable Notes and Best Practices
- Single key based index.
- Scale linearly with additional nodes
- Highly durable using Colossus magic
FireStore (Datastore) Notes and Best Practices
- Do not write to a document more than 1x per second
- Regional and multi-regional options are available, select based on costs, availability and latency
- Multi-regional availability is 99.999%
- Datastore mode allows for backwards compatibility to Datastore and is required for App Engine integration
- Supports offline data persistence
MemoryStore Notes and Best Practices
- Replication across zones for standard tier to provide HA
- Must use Private Service Access to connect.
- Memcached is in BETA.
Summary of use cases
| Use Cases | |
| Cloud SQL | SQL Support for OLTP ERP, CRM, E-Commerce, Web |
| Cloud Spanner | SQL Support for OLTP Global Financial Ledger Supply Chain/Inventory Management |
| BigTable | Streaming time series data (IoT) Fraud detection Personalization Ad tech Financial Analysis |
| Firestore | User Profiles User Sessions State Management |
| Memorystore | Low latency in memory data storage |