TiDB
TiDB delivers modern Hybrid Transactional and Analytical Processing. TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise.
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.
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
Horizontal Scalability
Manage operating expense with the ability to grow on-demand through horizontal read/write scaling
Reduce Outages
Enable business continuity with built-in high availability, automatic partitioning, and cross-region data replication
Transactional and Analytical Processing
Provide business adaptability through fast results for transactional and analytical workloads from a single database
Real-Time Results
Ensure predictable results since all users are querying the same data for both OLTP and OLAP
Business Intelligence
Utilize agile development methodologies and deliver a dynamic approach to managing your applications
Case Study
Why Streak Chose TiDB to Make Its CRM Real-Time
Streak is a Google Chrome extension that directly integrates with Google Workplace 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
Case Study
NetEase Games: Why We Chose TiDB over Other MySQL-based and NewSQL Storage Solutions
As business boomed, NetEase Games met bottlenecks in database scalability and data isolation. This post introduces why they chose TiDB over other MySQL-based and NewSQL storage solutions to solve their pain points.
TiDB is compatible with the MySQL protocol, which means few code modifications and low migration costs. This scale-out distributed SQL database enables us to gain insights from data and create value for our users. Our current success with using TiDB gives us the confidence to move more of our services to TiDB in the future.
Wenjie Li, Senior Database Administrator
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 DemoBattle-tested...
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.
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.
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.
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%.
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.
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
TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise
TiDB Cloud
Get the massive scale and resiliency of TiDB databases in a fully managed cloud service