OceanBase Database is available in two forms: OceanBase Database Enterprise Edition and OceanBase Database Community Edition.
OceanBase Database Enterprise Edition is an enterprise-level, native distributed database independently developed by the OceanBase team. It provides financial-grade high availability on commodity hardware. Its groundbreaking deployment mode of "five IDCs across three regions" sets a new standard for automatic, lossless disaster recovery at the region level. OceanBase Database has also set new records in the TPC-C benchmark test, supporting more than 1,500 nodes in one cluster. It is cloud-native, highly consistent, and highly compatible with Oracle and MySQL.
OceanBase Database Community Edition is a standalone distributed and integrated database that is fully compatible with MySQL. It leverages a native distributed architecture and incorporates enterprise-level features such as high availability suitable for financial-grade applications, transparent horizontal scaling, distributed transactions, multitenancy, and syntax compatibility. OceanBase Database Community Edition is open-source and compatible with MySQL. It not only supports connectivity with virtualization and big data applications and products, but also supports a comprehensive range of GUI-based development tools, O&M and monitoring tools, and data migration tools. Furthermore, it offers open APIs and various eco-capabilities to meet the diverse business requirements of enterprises or individuals.
Note
In this topic, a distributed transaction is an internal transaction within an OceanBase cluster. A distributed transaction is supported only in one tenant although the data that the transaction accesses involves multiple participants. eXtended Architecture (XA) ensures the atomicity of committing cross-database transactions. If a global transaction of an application accesses data in multiple databases, an external distributed transaction manager that is independent from OceanBase Database can call an XA transaction interface to ensure the atomicity of committing the global transaction. This way, the global transaction can also be seen as an XA transaction.
The following table describes the features supported by these two editions.
| 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 | 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 syntaxes 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 | Not supported |
| Compatibility | LOCK TABLE | Supported | Not supported |
| 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 | 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 atomicity, consistency, isolation, and durability (ACID), and multi-version support | Supported | Supported |
| High performance | Data partitioning (RANGE, HASH, and LIST) | Supported | Supported |
| High performance | Global indexes | Supported | Supported |
| High performance | Advanced compression | Supported | Supported |
| High performance | Dynamic sampling | Supported | Supported |
| High performance | Auto degree of parallelism (DOP) | Supported | Supported |
| Cross-data source access | Read-only external tables (CSV) | Supported | Supported |
| Cross-data source access | DBLink | Supported | Supported |
| Multimodel | TableAPI | Supported | Supported |
| Multimodel | HBaseAPI | Supported | Supported |
| Multimodel | JSON | Supported | Supported |
| Multimodel | Geographic information system (GIS) | Supported | Supported |
| Multimodel | XML | 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 row-level labels, transparent data encryption (TDE), or ShangMi 4 (SM4). |
| O&M management | End-to-end diagnostics | Supported | Supported |
| O&M management | O&M components (liboblog and ob_admin) | Supported | Supported |
| O&M management | obloader/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. 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 its official 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. |