OpenTenBase
an enterprise-level distributed HTAP open source database
OpenTenBase is an enterprise-level distributed HTAP open source database. It has high scalability, commercial database syntax compatibility, distributed HTAP engine, multi-level disaster recovery and multi-dimensional resource isolation. It has been successfully used in core businesses in finance, medical, aerospace and other industries system.

Key Feature

Commercial Database Compatibility
Fully compatible with SQL2011, Supports commercial database syntax
PostgreSQL Compatibility
Highly compatible with PostgreSQL syntax and following the community ecology
Complete Distributed Transaction Capabilities
Complete distributed transaction ACID capabilities to ensure distributed read consistency
HTAP Dual Engine
Equipped with efficient OLTP and powerful OLAP dual engine capabilities, supporting PB level
Flexible Extension
Distributed flexible expansion, distributed efficient elastic expansion and contraction
Superior performance
Superior performance, good distributed elastic expansion, supporting high concurrency and high-speed throughput

Install, Use, Contribute? Get started quickly with OpenTenBase!

What is OpenTenBase

OpenTenBase is an open source distributed database that can easily handle the storage, analysis and query of billions of data.

Quick Start

OpenTenBase architecture, introduction, compilation and installation, cluster running status, start and stop, etc.

Basic Use

Creation of shard table, hot and cold partition table, copy table, and basic DML operations.

Contribute

If you have good comments or suggestions, welcome to create Issues or Pull Requests to contribute to the OpenTenBase open source community.

Messages from Celebrities
FENG Guanlin
Secretary General of OpenAtom Foundation
I am very happy to see that Tencent can open source OpenTenBase, a basic software database project that has been developed for many years and has passed the test of massive business scenarios, and donated it to the foundation. In the future, the foundation will uphold a neutral and open attitude and work with the industry to build OpenTenBase into a globally influential excellent open source projects.
WANG Yicheng
General Manager of Tencent Cloud Database
In recent years, the amount of data has continued to increase dramatically. The development of the Internet, IoT, and smart manufacturing has brought explosive growth of data. The development of cloud computing has made data aggregation easier. At present, TDSQL has covered a complete database product system that integrates financial-grade distributed, cloud-native, analytical and other multi-engines, and provides industry-leading financial-grade high availability, storage and calculation separation, data warehouse, enterprise-level security and other capabilities. In the future, we will continue to invest in and break through core database technologies, create a more healthy and sustainable database ecosystem and open source community, and provide long-term impetus for the digital transformation of enterprises.
PING Lei
Vice General Manager of Cybersecurity Center of CHN Energy
Let’s work together to share the wisdom of open source databases! We are very happy to work together with the OpenTenBase open source distributed database community to work together on this open source database project. We believe that by working together, we can create a more high-quality, efficient, and reliable database product and provide better support and services to developers around the world. We look forward to continuing to work closely with OpenTenBase to jointly solve the technical problems encountered and jointly explore the future of database technology. We believe that through openness and sharing in the open source community, we can achieve greater success!
BAI Shi
Vice Director of China Chengtong
China Chengtong is the “reform toolbox” for the high-quality development of central enterprises. We are very happy to participate in the open source database community initiated by Tencent and work with the OpenTenBase community to promote the open source ecosystem of domestic databases. At the same time, we will use the concept of pioneering, reform and innovation to continue Promote the digital transformation of state-owned enterprises.
WANG Yunlong
Product Director of Tencent Cloud Database
OpenTenBase is an open source distributed database deeply practiced within Tencent. After 10 years of development in finance, games, advertising, social networking and other businesses, it has been gradually promoted to applications in thousands of industries. The Tencent Cloud distributed database TDSQL team has been working hard for ten years. In the future, we will work with the industry to create an open source ecosystem for domestic databases and an ecosystem compatible with Oracle databases to better assist enterprises in digital transformation and cope with the challenges of high performance and high availability of massive data. , and lower the user threshold.
ZHAO Zhenping
Former Chairman of PostgreSQL Chinese Community
I wish the Tencent OpenTenBase community to delve deeply into the database field, serve China and serve the world. Become a large and influential technology community in the world.
BAI Guohua
Vice Chairman and Secretary General of China PostgreSQL Association
OpenTenBase is an enterprise-level distributed HTAP open source database that fills the gap in the industry’s open source distributed OLTP system based on PostgreSQL. The Tencent Cloud TDSQL PG team also applies the open source kernel to core business systems in finance, government, telecommunications, medical, aerospace and other industries. In the future, China PostgreSQL Association will work with Tencent to promote open source products to a broader application market.

Latest 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

Latest Post


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 Event

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