Database / Google Spanner Database Interview questions
What are the main features of Google Spanner?
Spanner's feature set centers on giving developers relational guarantees at global scale.
- External consistency - every committed transaction gets a timestamp that reflects real commit order, even across regions.
- Horizontal scalability - adding compute capacity (nodes or processing units) increases throughput without downtime or manual sharding.
- Automatic sharding and rebalancing - Spanner splits and moves data ranges based on load and size.
- Multi-region replication - configurable regional or multi-region instance configs with 99.999% availability SLAs on multi-region setups.
- SQL support - joins, secondary indexes, and schema constraints via GoogleSQL or PostgreSQL dialect.
- Online schema changes - DDL statements run without taking the database offline.
Together these remove the classic trade-off where teams had to pick either SQL semantics or web-scale distribution.
More Related questions...