OceanBase Database is available in two editions: the Enterprise Edition and the Community Edition.
OceanBase Database Enterprise Edition: OceanBase Database Enterprise Edition is a fully self-developed, enterprise-grade, native distributed database. It achieves financial-grade high availability on standard hardware. It introduces a new standard for automatic, lossless disaster recovery across five IDCs in three regions. It also sets a new benchmark in TPC-C standard testing, with a single cluster supporting over 1,500 nodes. It features cloud-native architecture, strong consistency, and high compatibility with Oracle and MySQL.
OceanBase Database Community Edition: OceanBase Database Community Edition is a single-node, distributed, integrated database compatible with MySQL. It features a native distributed architecture and supports financial-grade high availability, transparent horizontal scaling, distributed transactions, multi-tenancy, and syntax compatibility. The core of OceanBase Database Community Edition is open source and compatible with MySQL. It can be integrated with virtualization and big data technologies and products. It supports various graphical development, O&M, and data migration tools. The Community Edition also provides open APIs and a rich ecosystem, enabling enterprises or individuals to better meet their customization needs.
Note
In this topic, a distributed transaction refers to a transaction within an OceanBase cluster. Although the transaction involves multiple participants, it is confined to a single tenant. The XA protocol ensures atomicity in cross-database transaction commits. When an application's global transaction accesses data from multiple databases, a distributed transaction manager (an external service independent of OceanBase Database) can use the XA transaction interface to ensure the atomicity of the global transaction commit. This global transaction is also known as an XA transaction.
The following table lists the features supported by the Enterprise Edition and the Community Edition.
| Category | Feature | Enterprise Edition | Community Edition |
|---|---|---|---|
| Architecture | Separated storage and compute architecture | Supported | Not supported |
| Architecture | Independent log service | Supported | Not supported |
| Core Components | Integrated SQL engine | Supported | Supported |
| Core Components | Integrated transaction engine | Supported | Supported |
| Core Components | Integrated storage engine | Supported | Supported |
| Core Components | Cluster scheduling service | Supported | Supported |
| Core Components | Cluster proxy service | Supported | Supported |
| Core Components | Client with C driver and Java driver | Supported | Supported |
| High Availability | Multi-replica support | Supported | Supported |
| High Availability | Deployment across three regions and five zones | Supported | Supported |
| High Availability | Transparent horizontal scaling | Supported | Supported |
| High Availability | Multi-tenant management | Supported | Supported |
| High Availability | Tenant cloning | Supported | Supported |
| High Availability | Data backup and restore | Supported | Supported |
| High Availability | Resource isolation | Supported | Supported |
| High Availability | Physical standby database | Supported | Supported |
| High Availability | Arbitration service | Supported | Not supported |
| Compatibility | MySQL syntax and protocol compatibility | Supported | Supported |
| Compatibility | Data types and functions compatibility | Supported | Supported |
| Compatibility | Stored procedures and packages | Supported | Supported |
| Compatibility | Complex character sets | Supported | Supported |
| Compatibility | Oracle syntax compatibility | Supported | Not supported |
| Compatibility | XA transactions | Supported | Supported |
| Compatibility | LOCK TABLE | Supported | Supported |
| Compatibility | Function indexes | Supported | Supported |
| High Performance | Cost-based optimizer | Supported | Supported |
| High Performance | Complex query optimization and rewriting | Supported | Supported |
| High Performance | Parallel execution engine | Supported | Supported |
| High Performance | Vectorized engine | Supported | Supported |
| High Performance | Columnar engine | Supported | Supported |
| High Performance | Advanced execution plan management (SPM) | Supported | Not supported |
| High Performance | Small specifications | Supported | Supported |
| High Performance | Log transmission based on the Paxos protocol | Supported | Supported |
| High Performance | Distributed strong-consistency transactions, complete ACID, and support for multiple versions | Supported | Supported |
| High Performance | Data partitioning (Range/Hash/List) | Supported | Supported |
| High Performance | Partition exchange | Supported | Supported |
| High Performance | Partition splitting | Supported | Supported |
| High Performance | Global indexes | Supported | Supported |
| High Performance | Multi-value indexes | Supported | Supported |
| High Performance | Full-text indexes | Supported | Supported |
| High Performance | Advanced compression capabilities | Supported | Supported |
| High Performance | Dynamic sampling | Supported | Supported |
| High Performance | Auto DOP | Supported | Supported |
| High Performance | Materialized views | Supported | Supported |
| Cross-Data Source | Read-only external tables | Supported | Supported |
| Cross-Data Source | DBLink | Supported | Supported |
| Multi-Model | OBKV-Table | Supported | Supported |
| Multi-Model | OBKV-HBase | Supported | Supported |
| Multi-Model | JSON | Supported | Supported |
| Multi-Model | GIS | Supported | Supported |
| Multi-Model | Vector | Supported | Supported |
| Security | Audit | Supported | Not supported |
| Security | Permission management | Supported | Supported |
| Security | Communication encryption | Supported | Supported |
| Security | Advanced security extension capabilities | Supported | Not supported Community Edition does not support row-level tagging, transparent data encryption (TDE), RPC encryption based on the SM2/SM4 algorithm, and TLS password-free login. |
| Low Cost | CLOG storage compression | Supported | Not supported |
| O&M Management | End-to-end tracing | Supported | Supported |
| O&M Management | O&M components (liboblog, ob_admin) | Supported | Supported |
| O&M Management | Derivative tools (obloader/obdumper) | Supported | Supported |
| O&M Management | Graphical development and management tools | Supported | Supported Community Edition supports the binary download and use of graphical development and management tools such as OCP, OMS, and ODC, but does not include OMA. |
| Support and Services | Technical consultation (product technical consulting services) | Supported | Community Edition provides community-based product technical consulting services, operating through community issues, without commercial expert team technical consultation |
| Support and Services | Service acquisition (channels to obtain technical support) | Professional commercial support team | Community Edition only supports online service consultation on the OceanBase Community website or official community, without exclusive services from commercial expert teams |
| Support and Services | Expert services (planning, implementation, inspection, fault recovery, production assurance) | Commercial expert on-site services | Community Edition does not provide expert assurance services |
| Support and Services | Fault response | 7*24 service | Community Edition does not provide emergency fault handling services |