DBMS > TiDB

TiDB System Properties

Please select another system to compare it with TiDB.

Our visitors often compare TiDB with Oracle Berkeley DB, OceanBase and GeoSpock.

Editorial information provided by DB-Engines

Name

Description

TiDB is an open source distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability.

Primary database model

Relational DBMS

Secondary database models

Vector DBMS

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	3.19
Rank	#83	Overall
	#43	Relational DBMS

Website

pingcap.com

Technical documentation

docs.pingcap.com/tidb/stable

Developer

PingCAP, Inc.

Initial release

2016

Current release

8.2.0, July 2024

License

Commercial or Open Source

Open Source

Apache 2.0

Cloud-based only

Only available as a cloud service

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.

Implementation language

Go, Rust

Server operating systems

Linux

Data scheme

yes

Typing

predefined data types such as float or date

yes

XML support

Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.

Secondary indexes

yes

SQL

Support of SQL

yes

APIs and other access methods

GORM
JDBC
ODBC
Proprietary protocol
SQLAlchemy

Supported programming languages

Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl

Server-side scripts

Stored procedures

Triggers

Partitioning methods

Methods for storing different data on different nodes

horizontal partitioning (by key range)

Replication methods

Methods for redundantly storing data on multiple nodes

Using Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.

MapReduce

Offers an API for user-defined Map/Reduce methods

yes

with TiSpark Connector

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Foreign keys

Referential integrity

yes

full support since version 6.6

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

ACID

Concurrency

Support for concurrent manipulation of data

yes

Durability

Support for making data persistent

yes

In-memory capabilities

Is there an option to define some or all structures to be held in-memory only.

User concepts

Access control

Fine grained access rights according to SQL-standard

More information provided by the system vendor

Specific characteristics

TiDB is an open-source, distributed SQL database built for cloud-native, data-intensive, and AI-driven applications. It unifies OLTP, real-time operational analytics, and AI-ready workloads within a single platform. TiDB’s distributed architecture provides Competitive advantages

HORIZONTAL SCALING: TiDB provides seamless scaling with automatic sharding, while built-in security controls safeguard data as it scales effortlessly. 99.99% AVAILABILITY: TiDB ensures continuous access to data with automated failover, self-healing capabilities, and secure data recovery, providing uninterrupted uptime and zero data loss. STRONG ACID CONSISTENCY: Maintains ACID transactions with strong data consistency, integrity checks, and compliance with global data privacy regulations when distributing data globally. OPTIMIZED FOR MIXED WORKLOADS: TiDB’s streamlined tech stack is optimized for transactional, analytical, and AI workloads, while ensuring data security and privacy. MYSQL COMPATIBILITY: Leverage the world’s most MySQL-compatible distributed SQL database, with enhanced security and reliability, all built on a familiar platform. MULTI-CLOUD: Easily deploy database clusters across your preferred cloud platforms. Benefit from end-to-end encryption and full compliance with each cloud provider’s security standards. OPEN SOURCE FOUNDATION: TiDB unlocks business innovation with a transparent, community-driven, and secure database that’s 100% open source. ROBUST SECURITY & COMPLIANCE: TiDB protects data with enterprise-grade encryption, both in-flight and at-rest, supported by regular security audits and compliance certifications such as GDPR, CCPA, and SOC2. CLOUD-NATIVE OBJECT STORAGE: TiDB offers durable, low-cost, cloud-optimized storage that enables elastic scale and fast Point-In-Time Recovery (PITR). WORKLOAD ISOLATION: TiDB separates background jobs from foreground queries with modular services. TiDB’s cloud-native design separates and compute to deliver elasticity and resilience. TiDB’s SQL Layer provides distributed SQL processing and automatic load balancing, while the Placement Driver (PD) manages metadata, load balancing, and data distribution across clusters. TiDB’s Storage Layer combines row-store, column-store, and object-store engines to handle transactional, operational, and AI workloads efficiently while delivering up to 11 nines of durability.

Typical application scenarios

TiDB is ideal for transactional applications that require extreme scalability and reliability.

Common use cases include:

System of record (product catalog, financial ledger, transactions, orders)
Serving layer for customer-facing applications
Single view for real-time operational insights
General purpose database

Key customers

Block, Pinterest, Catalyst, Bolt, Flipkart, Capcom, Shopee (E-commerce), JD Cloud & AI (Cloud Computing), Zhihu (Knowledge Sharing), VNG (Mobile Payments), Xiaomi (Consumer Electronics), Jinri Toutiao (Mobile News Platform), Dailymotion (Media and Entertainment), Qunar.com (Travel), YOOZOO GAMES (Gaming), FUNYOURS JAPAN (Gaming), 360 Financial (FinTech) [See Customer Stories]

Market metrics

34K+ GitHub stars

5K+ members in TiDB Community Slack

1K+ community contributors

3K+ production adopters

Licensing and pricing models

TiDB Community: Free open source software (Apache 2.0)
TiDB Self-Hosted: Enterprise subscription, self-managed TiDB clusters
TiDB Dedicated: Fully-managed cloud DBaaS for predictable workloads [Pricing Calculator]
TiDB Serverless: Fully-managed cloud DBaaS for auto-scaling workloads [Pricing Calculator]

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources

Recent citations in the news

PingCAP Launches TiDB X and New AI Capabilities at SCaiLE Summit 2025
8 October 2025, Yahoo Finance

At TiDB SCaiLE 2025, Global Data Leaders Share Growth Strategies for the AI Era
18 September 2025, GlobeNewswire

Build a data lakehouse in a hybrid Environment using Amazon EMR Serverless, Apache DolphinScheduler, and TiDB
20 March 2025, Amazon Web Services

Why TiDB Thinks S3 Will Power the AI-First Database Era
13 August 2025, Analytics India Magazine

PingCAP’s Max Liu Is Aiming High
24 July 2025, The Software Report

provided by Google News

Share this page