sql-new

MySQL Compatible

Use what you know, since TiDB relies on standard SQL commands. There is no need to learn a new query language or make massive and painful changes to your application. TiDB enables application developers and users to continue working with what they already use but still benefit from the speed and capability of a single unified database.

htap

Modern Hybrid Transactional and Analytical Processing (HTAP)

Make better business decisions by removing data silos, providing everyone in your organization with the real-time information they need to do their job, all from a single database. TiDB automatically stores your data in both a row and column store, then optimally determines which is used to respond to a query, providing your results quickly and in the most efficient way.

Key Benefits

scale

Horizontal Scalability

Manage operating expense with the ability to grow on-demand through horizontal read/write scaling

Learn More

HA

Reduce Outages

Enable business continuity with built-in high availability, automatic partitioning, and cross-region data replication

Learn More

transactional

Transactional and Analytical Processing

Provide business adaptability through fast results for transactional and analytical workloads from a single database

Learn More

real-time results

Real-Time Results

Ensure predictable results since all users are querying the same data for both OLTP and OLAP

Learn More

business intelligence

Business Intelligence

Utilize agile development methodologies and deliver a dynamic approach to managing your applications

Learn More

cloud-native

Cloud-Native

Automate operational tasks through the use of a Kubernetes Operator

Learn More

Case Study

Why Streak Chose TiDB to Make Its CRM Real-Time

Streak is a Google Chrome extension that directly integrates with Google Workspace to create a CRM dashboard of sales pipelines, contacts, and action items. Founded in 2011, they now have over 6000 customers worldwide with industry leading companies such as Opendoor, Uber, Atlassian, Logitech, Rappi, and Keller Williams.   Streak is layered on top of Gmail […]

TiDB is enabling Streak users to share emails and metadata effortlessly, and is enabling our developers to move faster than ever before.

Fred Wulff, VP of Engineering
Why_TiDB

Why TiDB?

PingCAP is dedicated to building TiDB, an Open Source, Cloud Native, distributed, MySQL compatible database for elastic scale and real-time analytics

Request a Demo & Get Started

Request Demo

Battle-tested...

Group 2846

An express delivery company serving over 96% of China needed a database that supported horizontal scalability, distributed transactions with strong consistency, highly concurrent writes, and minute-level, multi-dimensional queries. With TiDB, they increased IT efficiency by 300%, and in the second quarter of 2020, reducing the cost per order by 17.1% year-on-year.

Group 2844

A bank in China, with over 260 branches throughout the country, needed an OLTP system that supports massive amounts of data and completely distributed transactions. They chose TiDB and see that query latency is reduced from tens of seconds to tens of milliseconds.

Group 2870

An online marketplace for classified ads, with more than 500 million users, wanted to move away from traditional ETL-based analytics. They deployed 52 TiDB clusters in the production environment to store 160+ TB of data, with 320+ servers running in 15 applications. The databases have 5.5 billion daily visits. To maintain such large-scale clusters, they only need two DBAs, who also manage MySQL databases.

Group 2875

A gaming company, currently supporting more than 100 million active users, needed a database that could accommodate their expected growth while still staying cost-competitive. After deploying the entire TiDB data analytics system on the cloud, they reduced hardware costs by 50%.

Group 2847

An online auto trading company found that with nearly 1 billion data records and 1,000 QPS, the 99.9th percentile latency is still lower than 128 ms with TiDB. They also expanded the time range an application can query from the most recent three months to all historical data.

Group 2873

TiDB supports organizations looking for transactional and analytical processing to replace their traditional data processing system. It provides a transactional key-value store along with the ability to perform large-scale analytics. TiDB is the one database that delivers OLTP and OLAP capabilities in real-time.

Feature TiDB Amazon Aurora Google Cloud Spanner YugaByteDB CockroachDB
Elastic Scalability
Automated failover and high availability
Distributed ACID transactions
Hybrid Transactional and Analytical Processing (HTAP)
SQL compatibility and protocol MySQL MySQL and PostgreSQL Proprietary PostgreSQL PostgreSQL
Open source license Apache 2.0
Apache 2.0 BSL and CCL
Open source contributor count 500+
100+ 300+
TiDB Cloud logo-black

TiDB Cloud

Get the massive scale and resiliency of TiDB databases in a fully managed cloud service

TiDB logo-black

TiDB

TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise

Documentation

Access tutorials, guides, release notes, and more

View Docs
Community

Join our community to connect with TiDB contributors from around the world

Community
FAQs

Check out TiDB and TiDB Cloud Frequently Asked Questions

FAQs