MySQL to openGauss Migration Tool Chameleon

Availability

This feature is available since openGauss 3.0.0.

Introduction

Chameleon is Python-based. It supports real-time data replication from MySQL to openGauss. The tool can replicate initial full data and incremental data in real time to migrate them from MySQL to openGauss. It supports migration of various data types in MySQL, and maintains the precision of floating-point data, including decimal, dec, numeric, float, float4, float8, real, double, double precision and fixed after migration.

Benefits

You can use Chameleon to migrate data from the MySQL database to the openGauss database.

Description

Chameleon provides full and incremental data replication functions to migrate data from the MySQL database to the openGauss database. Chameleon stores the mappings between MySQL and openGauss data types and supports migration of various data types in MySQL. Specifically, floating-point data in MySQL, including decimal, dec, numeric, float, float4, float8, real, double, double precision and fixed, will be converted to the numeric[p, s] type in openGauss if the precision is specified or contained by default. If the precision is not specified, the data will be converted to the numeric data type in openGauss. In this way, the data precision remains unchanged after offline and online migration.

Enhancements

None.

Constraints

  • MySQL 5.7 is supported.
  • If incompatibility still exists after data type mapping, table data migration fails, but the subsequent offline data migration process does not terminate.

Dependencies

None.

Feedback
编组 3备份
    openGauss 2024-04-21 00:47:23
    cancel