Overview of MYSQL-compatible Mode

MYSQL-compatible Mode compares GaussDB in MYSQL-compatible mode (that is, when sql_compatibility is set to 'MYSQL', b_format_version is set to '5.7', and b_format_dev_version is set to 's1') with MySQL 5.7. Only compatibility features added later than GaussDB Kernel 503.0.0 are described. You are advised to view the specifications and restrictions of the features in Developer Guide.

The implementation logic of MYSQL-compatible mode (sql_compatibility set to 'MYSQL') in distributed mode is similar to that of the B-compatible mode (sql_compatibility set to 'B') in centralized mode. For details, see "Overview > B-compatible Mode" in the centralized MySQL Compatibility Description.

GaussDB is compatible with MySQL in terms of data types, SQL functions, and database objects.

GaussDB and MySQL implement different underlying frameworks. Therefore, there are still some differences between GaussDB and MySQL.