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
