OpenTenBase
An Open and Neutral Open-Source Database

OpenTenBase is the community edition of TDSQL, an enterprise-grade distributed database. It includes two database kernels, OpenTenBase and TXSQL, and provides high scalability, compatibility with commercial database syntax, distributed processing, multi-level disaster recovery, and multi-dimensional resource isolation. It has been deployed in mission-critical systems across financial services, healthcare, aerospace, and other industries.

Key Features

Commercial Database Compatibility

Full SQL:2011 compatibility with support for Oracle-compatible syntax.

MySQL and PostgreSQL Compatibility

Provides strong compatibility with the MySQL and PostgreSQL ecosystems through the TXSQL and OpenTenBase kernels, respectively.

Complete Distributed Transaction Support

Provides full ACID-compliant distributed transactions and consistent reads across the distributed system.

Dual-Kernel Architecture

Includes both the OpenTenBase and TXSQL kernels, with efficient distributed execution and support for petabyte-scale data processing.

High Performance

Provides elastic distributed scalability with support for high concurrency and high throughput.

Data + AI

Supports distributed vector search and multimodal Data + AI analytics.

Install, Use, Contribute — Get Started with OpenTenBase

What is OpenTenBase

OpenTenBase is an open-source distributed database designed to efficiently handle large-scale data storage, analytics, and queries.

Quick Start

Learn about the OpenTenBase architecture, source code compilation and installation, cluster status, startup and shutdown, and more.

Basic Usage

Create shard tables, hot/cold partitioned tables, and replication tables, and perform basic DML operations.

Contribute

If you have suggestions or improvements, feel free to open an Issue or Pull Request and contribute to the OpenTenBase community.

Explore More OpenTenBase Features OpenTenBase GitHub Repository

Community Voices

CHENG Xiaoming
Secretary-General, OpenAtom Foundation
The establishment of the OpenTenBase Community Committee marks an important step toward open and neutral governance for the OpenTenBase project. We sincerely appreciate the active participation and strong support of all community member organizations. Going forward, we will continue to support the OpenTenBase Community Committee in upholding the principles of open governance, bringing together core database developers, ecosystem builders, and users to create an open, inclusive, and vibrant collaboration platform. We look forward to advancing database innovation and building OpenTenBase into a solid data foundation for open digital infrastructure in China and around the world. We also welcome more organizations committed to open source to join the community and contribute to its continued growth.
WANG Yicheng
General Manager, Tencent Cloud Database
Data volumes continue to grow rapidly as the Internet, IoT, intelligent manufacturing, and cloud computing accelerate data generation and aggregation. TDSQL now provides a comprehensive database product portfolio covering financial-grade distributed databases, cloud-native databases, analytical engines, and other technologies, with capabilities including financial-grade high availability, storage-compute separation, data warehousing, and enterprise security. We will continue investing in core database technologies and working with the industry to build a healthy and sustainable database ecosystem and open-source community, providing long-term momentum for enterprise digital transformation.
PAN Anqun
General Manager of Database R&D, Tencent Cloud
OpenTenBase fills an important gap in open-source PostgreSQL-based distributed OLTP systems. It combines HTAP capabilities, distributed transaction consistency, broad SQL compatibility, and complex query processing to provide strong support for enterprise digital transformation. OpenTenBase supports both OLTP and OLAP workloads, helping reduce business architecture complexity and cost. It uses global transaction management to maintain transaction consistency in distributed environments, provides strong PostgreSQL and Oracle compatibility, and includes a distributed query optimizer designed to significantly improve complex query performance.
PING Lei
Deputy General Manager, Cybersecurity Center, CHN Energy Information Technology
We are pleased to work with the OpenTenBase open-source distributed database community and jointly contribute to this open-source database project. Through collaboration, we believe we can build a higher-quality, more efficient, and more reliable database product and provide better support and services for developers worldwide. We look forward to continuing our close cooperation with OpenTenBase, solving technical challenges together, exploring the future of database technology, and achieving greater success through the openness and shared innovation of the open-source community.
BAI Shi
Deputy Director, Chengtong Digital Technology Co., Ltd.
China Chengtong serves as a key platform supporting the high-quality reform and development of central state-owned enterprises. We are pleased to participate in the open-source database community initiated by Tencent and to work with the OpenTenBase community to advance China’s open-source database ecosystem. We will continue to embrace innovation and practical exploration while supporting the digital transformation of state-owned enterprises.
WANG Yunlong
Product Director, Tencent Cloud Database
OpenTenBase is an open-source distributed database that has been extensively used within Tencent and refined through more than a decade of practice in financial services, gaming, advertising, social networking, and other businesses before expanding into a wide range of industries. Looking ahead, the Tencent Cloud TDSQL team will continue working with the industry to build an open-source domestic database ecosystem and strengthen Oracle-compatible database capabilities, helping enterprises address high-performance and high-availability requirements for massive data while reducing the barrier to database adoption.
ZHAO Zhenping
Former Chair of the PostgreSQL Chinese Community
Best wishes to the OpenTenBase community as it continues to advance database technology, serve users in China and around the world, and grow into an influential global technology community.
BAI Guohua
Vice Chair and Secretary-General, China PostgreSQL Association
As an enterprise-grade distributed HTAP open-source database, OpenTenBase fills an important gap in open-source PostgreSQL-based distributed OLTP systems. The Tencent Cloud TDSQL PG team has deployed its open-source database kernel in mission-critical systems across financial services, government, telecommunications, healthcare, aerospace, and other industries. Going forward, the China PostgreSQL Association will continue working with Tencent to bring this open-source technology to a broader range of users and application scenarios.

Community News

Tencent Meeting and TencentOS were selected into the catalog of "Outstanding Innovative Software Products of the Year"

On August 31, the China International Software Expo (hereinafter referred to as the Software Expo) was held in Tianjin. The Meeting announced the “2022-2023 Outstanding Innovative Software Product Catalog”, and Tencent Meeting and Tencent operating system TencentOS Server were selected into the catalog. At the same time, Tencent continued to rank first in the “Top 100 Software”.
Read More
View All News

Technical Blog


Basic Usage


In < Quick Start > article, we introduced opentenbase architecture, source code compilation and installation, cluster running status, startup and stop, etc. This article will introduce the creation of shard table, hot and cold partition table, replication table and basic DML operation in opentenbase.

Quick Start


What’s OpenTenBase OpenTenBase is a relational database cluster platform that provides write reliability and multi node data synchronization. You can configure OpenTenBase on one or more hosts and store OpenTenBase data on multiple physical hosts. There are two ways to store data tables: distributed or replicated.

Latest Events

OpenTenBase user case call

OpenTenBase is an open-source project incubated and operated by the OpenAtom Open Source Foundation. It is an enterprise-level distributed HTAP database that features high scalability, compatibility with commercial database syntax, a distributed HTAP engine, multi-level disaster recovery, and multi-dimensional resource isolation. It has been successfully applied in the core business systems of various industries, including finance, healthcare, and aerospace.
Read More

Join the OpenTenBase Campus Ambassador program and become a campus technology pioneer!

Are you passionate about learning databases? Do you want to connect with more database enthusiasts and events? Do you want to establish your influence in the open-source community? The opportunity is right in front of you: Join the OpenTenBase Campus Ambassador program! About OpenTenBase
Read More
View All Events