OceanBase Database vs TBase

OceanBase Database is a distributed database for transactional, analytical, and AI workloads in one system. Built-in compatibility with Oracle and MySQL is intended to simplify migration. Deployment choices include the open-source Community Edition, self-hosted Enterprise, and fully managed OceanBase Cloud across cloud providers. Documentation describes high availability and disaster recovery at node, data-center, and region levels. Linux installation packages are listed for Alibaba Cloud Linux, CentOS, Red Hat, Ubuntu, Debian, and Anolis OS. Docker deployment can be used on Windows and macOS, though the documentation cautions that this method has not been validated at scale. A standalone instance can be used for learning; production environments require at least three servers. Community Edition is free and includes full kernel capabilities. Enterprise pricing is available on request. Security features include role and permission management, network whitelists, encrypted communication, transparent data encryption, and SQL auditing, but Community Edition does not support security audit.

TBase is Tencent-published, open-source database software for distributed hybrid transactional and analytical processing. It provides database and data warehouse services through one cluster and supports an extended subset of SQL, including transactions, foreign keys, user-defined types, and functions. A cluster uses Coordinator Nodes to plan queries, DataNodes to store user data, and a Global Transaction Manager. Tables can be distributed or replicated, with queries sent to DataNodes and results gathered. Deployment is self-hosted; setup guidance describes compiling from source and deploying across one or more hosts, including basic x86 servers. Administrators can use pgxc_ctl to configure and manage clusters. Table options include shard, partitioned shard, hot-and-cold partitioned shard, and replication tables. Shard-table distribution-key values, lengths, and types cannot be modified. Replication tables keep a full copy on every DataNode, and the guide cautions against using them for large tables. Monitoring includes session memory, DataNode operator details, and cluster-wide active sessions. TBase is listed as free under the BSD 3-Clause License.