TrustRadius: an HG Insights company

Google Cloud Spanner

Score5.6 out of 10

13 Reviews and Ratings

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.8

  • Monitoring and metrics

    Built-in monitoring of multiple operational metrics

    Category average: 6.8

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