OceanBase sets MySQL or Oracle compatibility mode when you create the tenant. You cannot switch later without migrating data to a new tenant. Choose the mode that matches your application drivers and SQL dialect before go-live.
MySQL mode
- Backtick identifiers,
LIMIT,AUTO_INCREMENT. - Fits apps that already use MySQL drivers (JDBC
jdbc:mysql://via OBProxy).
Oracle mode
ROWNUM,DUAL,VARCHAR2, PL/SQL packages (subset).- Use Oracle JDBC thin driver or OceanBase Oracle tenant URL.
Migration impact
| Feature | MySQL mode | Oracle mode |
|---|---|---|
| Sequences | AUTO_INCREMENT | SEQUENCE + trigger |
| Pagination | LIMIT n | ROWNUM / FETCH |
| Empty string | ” allowed | ” treated as NULL |
Run application integration tests in staging with production driver settings before cutover.