pingcap/tidb

TiDB is built for agentic workloads that grow unpredictably, with ACID guarantees and native support for transactions, analytics, and vector search. No data silos. No noisy neighbors. No infrastructure ceiling.

What it solves

TiDB is a distributed SQL database designed to handle massive amounts of data while maintaining high availability and strong consistency. It solves the problem of scaling traditional SQL databases, which often struggle with horizontal scalability and the ability to handle both transactional (OLTP) and analytical (OLAP) workloads simultaneously.

How it works

TiDB separates computing from storage to allow independent scaling. It uses a row-based storage engine (TiKV) for transactions and a columnar storage engine (TiFlash) for analytical queries, enabling Hybrid Transactional/Analytical Processing (HTAP). The system ensures data reliability and consistency using the Raft consensus protocol and a two-phase commit protocol for distributed transactions.

Who it’s for

It is intended for developers and organizations that need a MySQL-compatible, cloud-native distributed database that can scale horizontally and vertically without downtime.

Highlights

  • MySQL Compatibility: Compatible with MySQL 8.0, allowing for easy migration with minimal code changes.
  • HTAP Capability: Combines row-based and columnar storage for real-time analytics on live transactional data.
  • Cloud-Native: Deployable on public clouds, on-premises, or natively in Kubernetes via the TiDB Operator.
  • Strong Consistency: Uses Raft and two-phase commit to ensure ACID compliance across multiple nodes.

Related

  • Project
    crate/crate

    A distributed SQL database that combines the scalability of NoSQL with the power of standard SQL for real-time analysis of massive datasets.

  • Project
    typedb/typedb

    TypeDB is a next-generation database that unifies relational, document, and graph models into a single strongly-typed system to simplify the management of complex, interconnected data.

  • Project
    oceanbase/seekdb

    A MySQL-compatible state store for AI agents featuring hybrid vector and full-text search, high-concurrency streaming writes, and copy-on-write sandboxes for safe state exploration.

  • Project
    heavyai/heavydb

    HeavyDB is an open-source, GPU-accelerated SQL database engine that enables millisecond queries on multi-billion row datasets without needing indexes or pre-aggregation.

  • Project
    MariaDB/server

    An open-source relational database that provides MySQL compatibility and advanced features like native vector search and pluggable storage engines.