description TiDB Overview
TiDB is a distributed SQL database designed to provide the horizontal scalability of NoSQL with the ACID guarantees and SQL interface of traditional databases. It is fully compatible with MySQL, allowing for easier migration while providing automatic sharding and rebalancing. This makes it an ideal solution for large-scale applications that outgrow single-node relational databases but require strict consistency.
Its cloud-native architecture ensures high availability and seamless scaling as data volume increases.
balance TiDB Pros & Cons
- MySQL compatible SQL interface
- Horizontal scalability
- ACID transaction compliance
- High operational overhead
- Complex deployment process
help TiDB FAQ
Can an existing MySQL application connect to TiDB?
TiDB speaks the MySQL protocol and supports much of MySQL's SQL syntax, so many applications can use existing drivers and tools. Compatibility is not absolute, so stored procedures, unusual data types, and engine-specific behavior should be checked before migration.
What roles do TiDB, TiKV, and PD play in one cluster?
TiDB servers parse SQL and execute distributed queries, while TiKV stores data as replicated key-value regions. Placement Driver, usually called PD, manages cluster metadata, scheduling, and timestamp allocation.
How does TiDB stay available when a server fails?
TiKV replicates data using the Raft consensus algorithm, normally across multiple nodes. If a replica fails, another replica can continue serving after leadership is established, provided the cluster retains a quorum.
When would someone choose TiDB instead of Vitess or CockroachDB?
TiDB is a natural candidate when MySQL compatibility and automatic distributed storage are priorities. Vitess shards MySQL itself, while CockroachDB has PostgreSQL-oriented client compatibility and its own distributed SQL architecture.
explore Explore More
Similar to TiDB
See all arrow_forwardReviews & Comments
Write a Review
Be the first to review
Share your thoughts with the community and help others make better decisions.