OceanBase Database is available in two forms: OceanBase Database Enterprise Edition and OceanBase Database Community Edition.
OceanBase Database Enterprise Edition is a native, enterprise-class distributed database developed independently by the OceanBase team. It provides financial-grade high availability on commodity hardware and introduces a new city-level disaster recovery standard known as "Five IDCs across Three Regions". As the world's first distributed database to pass the TPC-C benchmark test, it can support over 1,500 nodes in a single cluster. Additionally, it features cloud-native architecture, strong consistency, and high compatibility with other popular databases such as 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 an open-source database management system that 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.
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 | Compatibility with 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 | Compatibility with Oracle syntax | Supported | Not supported |
| Compatibility | XA transactions | Supported | Not supported |
| Compatibility | Table locks | Supported | Not supported |
| Compatibility | Function 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 execution 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, or LIST) | Supported | Supported |
| High performance | Global indexes | Supported | Supported |
| High performance | Advanced compression | Supported | Supported |
| High performance | Dynamic sampling | Supported | Supported |
| High performance | Auto DOP | Supported | Supported |
| Cross-data source access | Read-only foreign tables (CSV format) | Supported | Supported |
| Cross-data source access | DBLink | Supported | Not supported |
| Multimodel | TableAPI | Supported | Supported |
| Multimodel | HbaseAPI | Supported | Supported |
| Multimodel | JSON | Supported | Supported |
| Multimodel | Geographic information system (GIS) | Supported | Supported |
| Multimodel | XML | Supported | Not 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) for row-level labels, data, and logs. |
| O&M management | Full-link 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 charged. |
| 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) | Professional commercial support 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. |