TiDB Review (2026): Pricing, Features & Honest Verdict

Reviewed by MakerStack · Published · 4 min read

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
PlanPricePlan FeaturesBest For
Serverless FreeFree5 GiB row + 5 GiB columnar storage, 50M RUs/monthStartups and side projects
Serverless Pay-as-you-goUsage-based$0.00015/RU, scalable storageGrowing applications
DedicatedFrom ~$400/moManaged multi-node clusters, SLA, dedicated resourcesProduction 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.

Disclosure: MakerStack is funded by featured placement fees, sponsor slots and a small number of affiliate links. Nobody paid for this review. Where any of those does apply to a review, we say so on the page. The scoring criteria are the same in every case. See our editorial policy.

This review describes TiDB as we tested it on March 20, 2026. Pricing, plans and features may have changed since. We don't update reviews on request; see our update policy.