TiDB
SQL at Scale
TiDB is an open-source, MySQL-compatible, distributed SQL database by PingCAP. Trusted by LinkedIn, Pinterest, and Square, it offers seamless scalability to petabytes, built-in resilience, and supports transactional, analytical, operational, and AI workloads without manual sharding.
Funktionen
✓ MySQL compatibility
✓ Horizontal scalability
✓ Distributed ACID transactions
✓ No manual sharding
✓ HTAP support
✓ Strong consistency
✓ Point-in-time recovery
✓ Request Unit based provisioning
✓ Autoscaling
Vorteile
- + MySQL compatible (easy migration)
- + Scales without sharding
- + Open-source option
- + Strong consistency guarantees
- + HTAP eliminates separate analytics DB
Nachteile
- − More complex than single-node MySQL
- − Resource requirements higher
- − Some MySQL features not supported
- − Learning curve for distributed concepts