OceanBase Database provides the Enterprise Edition and Community Edition.
OceanBase Database Enterprise Edition: OceanBase Database is an enterprise-level native distributed database independently developed by Alibaba Group. It provides financial-grade high availability on ordinary hardware and implements the city-level, automatically lossless disaster recovery standard with five IDCs across three regions for the first time. It also redefines the TPC-C benchmark. In addition, it provides cloud-native, strong-consistency, and high compatibility with Oracle Database and MySQL Database. A single OceanBase cluster can contain up to 1,500 nodes.
OceanBase Database Community Edition: A MySQL-compatible, unified database for single-instance and distributed applications, it has native distributed architecture and provides the enterprise-level capabilities of high availability, horizontal scaling, distributed transactions, multi-tenant, and syntax compatibility. OceanBase Database Community Edition, which is open source, is compatible with MySQL Database and integrates with virtualization and big data technologies and products. It also supports various graphical development tools, operation and maintenance tools, and data migration tools. In addition, it provides open APIs and rich ecosystem capabilities to help enterprises and individuals meet their business needs more efficiently.
Note
Here, a distributed transaction refers to a transaction inside an OceanBase cluster. The transaction involves data across multiple participants, but is limited to one tenant. The XA protocol can address the atomicity of transaction commit in cross-database scenarios. When a global transaction in an application involves data across multiple databases, a distributed transaction manager (a service outside OceanBase Database) can use the XA transaction interface to ensure the atomicity of the global transaction commit. This global transaction is also called an XA transaction.
The features supported by the Enterprise Edition and Community Edition are described as follows:
Feature |
Description |
Enterprise Edition |
Community Edition |
|---|---|---|---|
| Product architecture | Storage and compute separation | 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, C driver, and Java driver | Supported | Supported |
| High availability | Multi-replica support | Supported | Supported |
| High availability | Five IDCs across three regions | 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 protocols | Supported | Supported |
| Compatibility | Data types and functions | Supported | Supported |
| Compatibility | Stored procedures and packages | Supported | Supported |
| Compatibility | Complex character sets | Supported | Supported |
| Compatibility | Oracle syntax | Supported | Not supported |
| Compatibility | XA transactions | Supported | Supported |
| Compatibility | LOCK TABLE | Supported | Supported
NoteIn V4.3.5, this feature is supported starting from V4.3.5 BP2. |
| Compatibility | Function-based indexes | Supported | Supported |
| High performance | Cost-based optimizer | Supported | Supported |
| High performance | Optimization and rewriting of complex queries | Supported | Supported |
| High performance | Parallel execution engine | Supported | Supported |
| High performance | Vectorized engine | Supported | Supported |
| High performance | Columnar engine | Supported | Supported |
| High performance | Advanced SQL plan management (SPM) | Supported | Not supported |
| High performance | Minimum specifications | Supported | Supported |
| High performance | Paxos-based log transmission | Supported | Supported |
| High performance | Distributed strong-consistency transactions, complete ACID, and multi-version support | Supported | Supported |
| High performance | Data partitioning (RANGE, HASH, and LIST) | Supported | Supported |
| High performance | Partition exchange | Supported | Supported |
| High performance | Partition splitting | Supported | Supported |
| High performance | Global indexes | Supported | Supported |
| High performance | Multi-valued indexes | Supported | Supported |
| High performance | Full-text indexes | Supported | Supported |
| High performance | Advanced compression | Supported | Supported |
| High performance | Dynamic sampling | Supported | Supported |
| High performance | Auto degree of parallelism (DOP) | Supported | Supported |
| High performance | Materialized views | Supported | Supported |
| Cross-data source access | Read-only external tables | Supported | Supported |
| Cross-data source access | DBLink | Supported | Supported |
| Multimodel | OBKV-Table | Supported | Supported |
| Multimodel | OBKV-HBase | Supported | Supported |
| Multimodel | JSON | Supported | Supported |
| Multimodel | Geographic information system (GIS) | Supported | Supported |
| Multimodel | Vector | Supported | Supported |
| Security | Audit | Supported | Not supported |
| Security | Privilege management | Supported | Supported |
| Security | Communication encryption | Supported | Supported |
| Security | Advanced security scaling | Supported | Not supported. OceanBase Database Community Edition does not support transparent data encryption (TDE) or row-level labels. |
| Security | Column encryption | Supported | Not supported |
| Cost efficiency | Clog compression for storage | Supported | Not supported |
| O&M management | End-to-end tracing | Supported | Supported |
| O&M management | O&M components (liboblog and ob_admin) | Supported | Supported |
| O&M management | obloader and obdumper | Supported | Supported |
| O&M management | GUI-based development and management tools | Supported | Supported. OceanBase Database Community Edition supports GUI-based development and management tools such as OceanBase Cloud Platform (OCP), OceanBase Migration Service (OMS), and OceanBase Developer Center (ODC). You can download these tools for free. However, OceanBase Migration Assessment (OMA) is a paid service. |
| Support and services | Technical consultation (on products) | Supported | OceanBase Database Community Edition provides only community-based technical consultation on products through the community issues model. No commercial expert team is provided for technical consultation. |
| Support and services | Service acquisition (channels for obtaining technical support) | Commercial expert team | OceanBase Database Community Edition provides online service consultation only on its official website or in OceanBase Database Community and does not provide commercial expert teams. |
| Support and services | Expert services (planning, implementation, inspection, fault recovery, and production assurance) | On-site services by commercial experts | OceanBase Database Community Edition does not provide expert assurance services. |
| Support and services | Response to faults | 24/7 services | OceanBase Database Community Edition does not provide emergency troubleshooting services. |