TiDB Review (2026): Pricing, Features & Honest Verdict
TLDR
TiDB is a distributed HTAP database that handles both transactions and real-time analytics in one system, with MySQL compatibility. Best for: teams needing analytics and transactions without separate infrastructure. Price: free (5 GiB serverless). Rating: 7.6/10
What is TiDB?
TiDB (pronounced “tie-dee-bee”) is an open-source distributed database built by PingCAP. Its defining feature is HTAP: Hybrid Transactional and Analytical Processing. Instead of running separate databases for OLTP (your app) and OLAP (your analytics), TiDB handles both in a single system. It speaks MySQL wire protocol, so existing MySQL applications can connect with minimal changes.
The architecture splits responsibilities between TiKV (row storage for transactions) and TiFlash (columnar storage for analytics). Data is automatically replicated between the two engines, giving you real-time analytical queries on live transactional data. No ETL pipelines, no stale data warehouses.
Key Features
HTAP Architecture
TiDB’s HTAP design is the headline feature. TiKV handles row-based transactional workloads while TiFlash provides columnar storage for analytical queries. The optimizer automatically routes queries to the right engine. You can run a complex aggregation on millions of rows without impacting your application’s read/write performance. This eliminates the traditional need for separate OLTP and OLAP systems.
MySQL Compatibility
TiDB implements the MySQL wire protocol and supports most MySQL syntax. Applications, ORMs, and drivers built for MySQL work with TiDB. Migration from MySQL is relatively smooth, though some MySQL-specific features (like stored procedures) have limited support. For most web application workloads, the compatibility is sufficient.
TiDB Serverless
PingCAP’s serverless offering provides a fully managed TiDB cluster that scales to zero. The free tier includes 5 GiB of row storage, 5 GiB of columnar storage, and 50 million Request Units per month. You pay only for what you use beyond the free tier. For startups and side projects, this is genuinely generous.
Horizontal Scaling
TiDB scales horizontally by adding nodes. There is no need to reshard manually or deal with complex migration procedures. The system automatically rebalances data across nodes. You can scale compute and storage independently, which keeps costs more predictable as workloads grow.
Real-Time Analytics
TiFlash’s columnar engine provides sub-second analytical query performance on fresh data. Because TiFlash replicates from TiKV in near-real-time, your dashboards and reports always reflect the current state of your data. No batch ETL jobs running overnight. No stale data warehouse that is always a day behind.
Pricing
TiDB Serverless has a free tier with 5 GiB row storage, 5 GiB column storage, and 50M Request Units/month. Beyond that, pricing is usage-based: $0.00015 per Request Unit, $0.0144/GiB-hr for row storage, $0.00111/GiB-hr for columnar storage. TiDB Dedicated (managed clusters) starts around $400/month for a basic 3-node setup. Self-hosted TiDB is free and open source (Apache 2.0).
Pros
- HTAP architecture eliminates the need for separate OLTP and OLAP databases and ETL pipelines
- MySQL compatibility makes migration straightforward for existing MySQL applications
- Generous serverless free tier (5 GiB) is enough for real projects, not just toy demos
- Horizontal scaling works transparently without manual resharding
- Open source core with active development and growing community
Cons
- MySQL compatibility is not 100%, stored procedures and some advanced features have gaps
- HTAP adds architectural complexity that simple applications do not need
- Dedicated cluster pricing gets expensive quickly for multi-node production setups
- Smaller ecosystem and community compared to PostgreSQL-compatible distributed databases
| Plan | Price | Plan Features | Best For |
|---|---|---|---|
| Serverless Free | Free | 5 GiB row + 5 GiB columnar storage, 50M RUs/month | Startups and side projects |
| Serverless Pay-as-you-go | Usage-based | $0.00015/RU, scalable storage | Growing applications |
| Dedicated | From ~$400/mo | Managed multi-node clusters, SLA, dedicated resources | Production workloads |
Who is TiDB Best For?
TiDB shines for teams that currently maintain separate MySQL databases and analytics infrastructure. If you are running ETL jobs to feed a data warehouse, or your analysts complain about stale data, TiDB’s HTAP architecture solves a real problem. Startups can start on the serverless free tier and scale up. The MySQL compatibility makes it particularly attractive for teams migrating from MySQL or MariaDB.
Alternatives
PlanetScale
PlanetScale also offers MySQL-compatible distributed databases, built on Vitess. It focuses purely on OLTP with excellent developer experience (branching, deploy requests). It does not have TiDB’s analytical capabilities but is simpler to operate. PlanetScale recently moved to a usage-based model and removed its free tier, which shifted some users toward TiDB Serverless.
CockroachDB
CockroachDB is PostgreSQL-compatible rather than MySQL-compatible. It excels at distributed transactions and global distribution but does not offer TiDB’s HTAP analytical capabilities. If your stack is Postgres-based and you need distribution without analytics, CockroachDB is the stronger choice.
Vitess
Vitess is the open-source MySQL sharding middleware that PlanetScale commercialized. It adds horizontal scaling to MySQL but requires more operational effort than TiDB. You keep standard MySQL underneath, which means full compatibility but without native analytical capabilities. Good for teams that want to scale MySQL without leaving the MySQL ecosystem entirely.
Verdict
TiDB tackles a genuine pain point: the gap between transactional databases and analytical systems. The HTAP architecture works, the MySQL compatibility is practical, and the serverless free tier makes it accessible. It is not the right choice if you just need a simple MySQL replacement or if your stack is PostgreSQL-based. But for teams drowning in ETL pipelines and stale analytics, TiDB offers a cleaner path forward.
FAQ
Is TiDB a drop-in replacement for MySQL?
For most application workloads, yes. TiDB supports MySQL wire protocol, most SQL syntax, and common MySQL drivers. Stored procedures, triggers, and some MySQL-specific features have limited support. Test your specific queries before migrating.
How does TiDB Serverless pricing compare to PlanetScale?
TiDB Serverless has a free tier (5 GiB storage, 50M Request Units/month) that PlanetScale no longer offers. Beyond the free tier, both use usage-based pricing. For small to medium workloads, TiDB Serverless is typically cheaper. At scale, dedicated clusters from either provider need careful cost comparison.
Do I need TiFlash for HTAP, or can I use just TiKV?
TiKV alone gives you a distributed transactional database without HTAP capabilities. TiFlash is optional and adds the columnar analytical engine. You can start with TiKV only and add TiFlash later when you need real-time analytics. On TiDB Serverless, both are included automatically.
TiDB Pros & Cons
What We Like
- HTAP architecture eliminates the need for separate OLTP and OLAP databases and ETL pipelines
- MySQL compatibility makes migration straightforward for existing MySQL applications
- Generous serverless free tier (5 GiB) is enough for real projects, not just toy demos
- Horizontal scaling works transparently without manual resharding
- Open source core with active development and growing community
What Could Be Better
- MySQL compatibility is not 100%, stored procedures and some advanced features have gaps
- HTAP adds architectural complexity that simple applications do not need
- Dedicated cluster pricing gets expensive quickly for multi-node production setups
- Smaller ecosystem and community compared to PostgreSQL-compatible distributed databases
TiDB FAQ
Is TiDB a drop-in replacement for MySQL?
For most application workloads, yes. TiDB supports MySQL wire protocol and most SQL syntax. Stored procedures, triggers, and some MySQL-specific features have limited support.
How does TiDB Serverless pricing compare to PlanetScale?
TiDB Serverless has a free tier (5 GiB, 50M RUs/month) that PlanetScale no longer offers. For small to medium workloads, TiDB Serverless is typically cheaper.
Do I need TiFlash for HTAP?
TiFlash is optional and adds the columnar analytical engine. You can start with TiKV only and add TiFlash later. On TiDB Serverless, both are included automatically.
What is TiDB?
Distributed HTAP database combining MySQL-compatible transactions and real-time analytics in one system, with a generous serverless free tier.
Is TiDB worth it?
TiDB tackles a genuine pain point: the gap between transactional databases and analytical systems. The HTAP architecture works, MySQL compatibility is practical, and the serverless free tier makes it accessible. Best for teams drowning in ETL pipelines who want transactions and analytics in one place. We rate it 7.6/10.
What are the best TiDB alternatives?
The top TiDB alternatives are PlanetScale, CockroachDB and Vitess. Each is compared in the alternatives section of this review.






