Compatibility modes

OceanBase Database supports both MySQL- and Oracle-compatible tenants in a system. You may select the MySQL or Oracle compatibility mode when you create a tenant. After you create a tenant, you cannot change its compatibility mode. All its data types, SQL functions, and views are in line with the MySQL or Oracle-compatible mode that you selected.

MySQL-compatible mode

The MySQL-compatible mode of OceanBase Database is designed to reduce the cost of business system transformation when migrating from MySQL Database to OceanBase Database. It allows database designers, developers, and administrators to get a quick start with OceanBase Database with the knowledge and experience they gained from using MySQL Database. The MySQL-compatible mode of OceanBase Database is compatible with most features and syntaxes in MySQL 5.7, including full compatibility with MySQL 5.7 and partial compatibility with JSON functions in version 8.0. Applications based on MySQL Database can smoothly migrate to OceanBase Database.

Oracle-compatible mode

OceanBase Database has supported Oracle compatibility mode since V2.x.x. The Oracle-compatible mode of OceanBase Database aims to reduce the cost of business system transformation when migrating from Oracle Database to OceanBase Database. It allows database designers, developers, and administrators to get a quick start with OceanBase Database with the knowledge and experience they gained from using Oracle Database. The Oracle-compatible mode of OceanBase Database supports a majority of Oracle syntax and procedural language features. This helps implement automatic migration for most Oracle-based business after minor adjustments.