#1 most frequent
United States of America
59.9%498 installations of 832
What is Google Cloud Spanner?
Google Cloud Spanner is a cloud database-as-a-service product offered as a service on Google Cloud Platform (GCP).
Categories & Use Cases
Top Performing Features
Automated backups
Automated backup enabling point-in-time data recovery
Category average: 8
Automatic software patching
Patches applied to database automatically
Category average: 8.3
Database scalability
Ease of scaling compute or memory resources and storage up or down
Category average: 9.2
Areas for Improvement
Automatic host deployment
Compute instance replacement in the event of hardware failure
Category average: 6.8
Database security provisions
Provision for database encryption, network isolation, and identity access management
Category average: 8.9
Monitoring and metrics
Built-in monitoring of multiple operational metrics
Category average: 6.9
Who Buys & Uses Google Cloud Spanner
#2 most frequent
India
7.1%59 installations of 832
#3 most frequent
United Kingdom of Great Britain and Northern Ireland
5.4%45 installations of 832
To Span the data, then Spanner is the way
Pros
- Scalability
- Sharding
- Interleaved Tables
- Cross Table Transactional Support
Cons
- Support for Views
- Support for more databases (schemas).
- More index types that can be supported (Functional)
- Backups (ie table/data backup) if data is deleted or truncate by accident.
Return on Investment
- Backups specifically if transactional data is deleted. Restoring made us lose time.
- Sharding on Horizontal level was quick and easy. Deployment and increasing nodes is easy
- Large dataset handling.
- ACID compliance
Alternatives Considered
Amazon Relational Database Service (RDS), Azure Databases, MongoDB, Google Cloud SQL and MySQL
Other Software Used
Azure Databases, MongoDB, Amazon Relational Database Service (RDS), MySQL, PostgreSQL, Azure Cosmos DB
Great choice for relational database that requires high availability
Pros
- Super high availability
- Scales automatically
- High standard SLA
Cons
- Lack MySQL support.
- Cannot edit the table on the fly.
- Kind of high learn curve to migrate.
Return on Investment
- It increased our database availability.
- It improved our database performance.
- We do not have to maintain a database cluster anymore.
Alternatives Considered
BigTable, Google BigQuery and Amazon Relational Database Service (RDS)
Other Software Used
BigTable, Google BigQuery, Amazon Relational Database Service (RDS), Confluent Platform