Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking the Database Compatibility Type
Updated on 2025-12-17 GMT+08:00
View PDF
Share

Checking the Database Compatibility Type

Check the compatibility type of the destination database. If the database type is incompatible, data may contain garbled characters or the synchronization may fail.

Failure Cause

  • During synchronization from MySQL to GaussDB, the destination database is incompatible with MySQL.

Handling Suggestion

  • Use a destination GaussDB instance that is compatible with MySQL.

    If the destination instance is a distributed instance, run the following statement to create a compatible database: CREATE DATABASE mysql_compatible_db DBCOMPATIBILITY 'MYSQL';

    If the destination instance is a primary/standby instance, run the following statement to create a compatible database: CREATE DATABASE mysql_compatible_db DBCOMPATIBILITY 'B';

Parent topic: Database Parameters