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
