Database & Data Management · head to head
Elasticsearch vs TiDB
Elasticsearch
Database & Data Management
The heart of the Elastic Stack for search and analytics
- From
- Free
- Rated
- -
TiDB
Database & Data Management
Open source distributed HTAP database for elastic scale and real-time analytics
- From
- Free
- Rated
- -
The short version
- Each has a real cost: Elasticsearch eventual consistency model with 1-second default refresh interval, not suitable for real-time transactional requirements; TiDB not 100% MySQL-compatible, requiring verification before migration
- They diverge on capability: Elasticsearch covers Full-text Search, TiDB covers MySQL Compatible.
Where they differ
Only the attributes on which Elasticsearch and TiDB actually diverge.
| Attribute | Elasticsearch | TiDB |
|---|---|---|
| Pricing model | Unknown | freemium |
| Platforms | Linux, Windows, macOS, Docker, Kubernetes | Cloud, AWS, Azure, Google Cloud Platform, Self-managed |
| Founded | 2010 | 2015 |
Identical on both: starting price (Free), free tier (Yes), user rating (Not yet rated), category (Database & Data Management).
What each one covers
Drawn from each product's published feature list. An absence here means we hold no record of it - not that the product lacks it.
Only in Elasticsearch
- Full-text Search
- Distributed Architecture
- RESTful API
- Schema-free JSON
- Aggregations
- Machine Learning
- Kibana
- Logstash
Only in TiDB
- MySQL Compatible
- HTAP Workloads
- Horizontal Scaling
- Strong Consistency
- High Availability
- Elastic Scaling
- MySQL
- Spark
Both cover
- Real-time Analytics
- Linux support
- Docker support
- Web support
What people use each for
The jobs each tool is most often brought in to do.
Elasticsearch
- Real-time applicationsnot TiDB
- Content managementnot TiDB
- User profilesnot TiDB
- Mobile backendsnot TiDB
- Cachingnot TiDB
TiDB
- Transaction processingnot Elasticsearch
- Data storagenot Elasticsearch
- Application backendnot Elasticsearch
- Reportingnot Elasticsearch
- Data analyticsnot Elasticsearch
Where each one falls short
Documented limitations, not opinions. Every one is a constraint you would hit in normal use.
Elasticsearch
- Eventual consistency model with 1-second default refresh interval, not suitable for real-time transactional requirements
- No support for ACID transactions or rollbacks; updates delete and re-insert documents
- JVM-dependent architecture requires careful memory management and monitoring to prevent garbage collection issues at scale
TiDB
- Not 100% MySQL-compatible, requiring verification before migration
Pricing, plan by plan
Elasticsearch
Free- Self-ManagedFree
- Open source
- Self-hosted
- Elasticsearch Cloud$16.4/month
- Managed service
- 14-day free trial
TiDB
Free- ServerlessFree
- 5GB storage
- 50M request units
- Free forever tier
- Dedicated$250/month
- Dedicated resources
- SLA guarantees
- Enterprise support
Which should you pick?
Choose Elasticsearch if
- You need full-text search.
- You want to start without paying.
- You work on Linux, Windows, macOS, Docker, Kubernetes.
- You also want distributed architecture.
Choose TiDB if
- You need mysql compatible.
- You want to start without paying.
- You work on Cloud, AWS, Azure, Google Cloud Platform, Self-managed.
- You also want htap workloads.
Questions people ask
- Is Elasticsearch or TiDB better?
- Neither clearly leads. Elasticsearch starts at Free and TiDB at Free, and user ratings are close enough to be indistinguishable. Choose on capability and platform support.
- Which is cheaper, Elasticsearch or TiDB?
- Elasticsearch starts at Free and TiDB at Free.
- Does Elasticsearch or TiDB run on more platforms?
- Elasticsearch runs on Linux, Windows, macOS, Docker, Kubernetes. TiDB runs on Cloud, AWS, Azure, Google Cloud Platform, Self-managed.
- Can I use Elasticsearch for free?
- Both have a free tier, so you can try either at no cost before committing.
- What is Elasticsearch best used for?
- Elasticsearch is most often used for real-time applications, content management, user profiles, mobile backends. Of those, real-time applications and content management are not what TiDB is typically brought in for.
- What can Elasticsearch do that TiDB cannot?
- Elasticsearch covers Full-text Search, Distributed Architecture, RESTful API, Schema-free JSON. TiDB covers MySQL Compatible, HTAP Workloads, Horizontal Scaling, Strong Consistency. Both handle Real-time Analytics, Linux support, Docker support, Web support.
Answered from the vendors’ own pages
Elasticsearch: Is Elasticsearch free?
Yes, Elasticsearch can be deployed as free and open-source software for self-managed installations. Elastic Cloud managed service starts at $16.40 per month, with a free 14-day trial available.
SourceTiDB: Is TiDB MySQL-compatible?
Yes, TiDB speaks the MySQL protocol, so existing MySQL clients, ORMs, and drivers work without modification. However, TiDB is not 100% MySQL-compatible.
SourceElasticsearch: Can I use Elasticsearch without Kibana?
Yes, Elasticsearch is a search engine independent of Kibana. Kibana is a visualization and analytics tool that works with Elasticsearch but is optional. You can use the Elasticsearch API directly for searching.
SourceTiDB: How does TiDB scale?
TiDB provides automatic horizontal scaling with compute and storage scaling independently. It splits compute (TiDB servers) from storage (TiKV) to allow adding nodes without data replication.
SourceElasticsearch: Does Elasticsearch support real-time indexing?
Elasticsearch indexes data with a refresh interval, typically 1 second. Data becomes searchable after the refresh cycle, making it near-real-time but not instantaneous. This can be configured but impacts performance.
SourceTiDB: Does TiDB support analytics workloads?
Yes, TiDB is an HTAP database with TiFlash columnar engine providing analytics capabilities alongside transactional processing on the same data without separate pipelines.
SourceElasticsearch: What are Elasticsearch's scaling limitations?
Elasticsearch requires careful operational management at scale, including shard balancing, heap sizing, and monitoring. Large clusters can suffer from garbage collection issues and become expensive to operate.
SourceElasticsearch: Does Elasticsearch support transactions and rollbacks?
No, Elasticsearch does not support ACID transactions or rollbacks. Updates are expensive operations that delete and re-insert documents, making it unsuitable for transactional workloads.
Source