OceanBase Database supports both MySQL- and Oracle-compatible tenants in a system. You can select the MySQL- or Oracle-compatible mode when you create a tenant. After you create a tenant, you cannot change its compatibility mode. All its data types, SQL features, and internal views conform with either a MySQL or Oracle database.
MySQL-compatible mode
To reduce the costs of business system transformation due to the migration from MySQL databases to OceanBase Database, OceanBase Database provides the MySQL-compatible mode. The mode allows database designers, developers, and administrators to get a quick start with OceanBase Database with the knowledge and experience they gained from using MySQL databases. OceanBase Database is compatible with MySQL 5.5, 5.6, and 5.7. You can migrate MySQL-based applications to OceanBase Database in a seamless way.
Oracle-compatible mode
OceanBase Database V2.x.x and later provides the Oracle-compatible mode. The rationale for why OceanBase Database provides the Oracle-compatible mode is similar to why OceanBase Database provides the MySQL-compatible mode. The Oracle-compatible mode supports a majority of Oracle syntax and procedural language features. This helps implement automatic migration for most Oracle-based business after minor adjustments.