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, city-level 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 enterprise-grade features such as 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 monitoring, and data migration tools. The Community Edition also provides open APIs and rich ecosystem capabilities, 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 data accessed by such a transaction involves multiple participants, the transaction 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 |
|---|---|---|---|
| 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, C driver, and Java driver | Supported | Supported |
| High availability | Multi-replica support | Supported | Supported |
| High availability | Deployment across three regions and five IDCs | Supported | Supported |
| High availability | Transparent horizontal scaling | Supported | Supported |
| High availability | Multi-tenant management | 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 sources | Read-only external tables | Supported | Supported |
| Cross data sources | DBLink | Supported | Supported |
| Multi-model | OBKV-Table | Supported | Supported |
| Multi-model | OBKV-HBase | Supported | Supported |
| Multi-model | JSON | Supported | Supported |
| Multi-model | Spatial data | 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. The Community Edition does not support row-level labeling, transparent data encryption (TDE), RPC transmission encryption based on SM algorithms, or password-free login via TLS. |
| 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 | Data export and import tools (obloader/obdumper) | Supported | Supported |
| O&M management | Graphical development and management tools | Supported | Supported The Community Edition supports the free binary download and use of commercial 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 | The Community Edition provides only 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 | The Community Edition supports online service consultation only on the official OceanBase Community website or in the 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 | The Community Edition does not provide expert assurance services |
| Support and services | Fault response | 7x24 service | The Community Edition does not provide emergency fault handling services |