Full Migration Tool gs_mysync
Availability
This feature is available since openGauss 5.0.0.
Introduction
gs_mysync is a Python-based tool that supports replication from MySQL to openGauss. This tool provides the capability of replicating initial full data and objects (views, triggers, functions, and stored procedures) to migrate data and objects from MySQL to openGauss. It supports full migration of various data types in MySQL, and maintains the precision of floating-point data after migration, including the decimal, dec, numeric, float, float4, float8, real, double, double precision, and fixed types.
Benefits
You can use gs_mysync to migrate data from the MySQL database to the openGauss database.
Description
gs_mysync provides the full data replication function to migrate data from the MySQL database to the openGauss database. gs_mysync 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 number[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 number 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.
Dependencies
gs_mysync depends on the MySQL migration tool gs_rep_portal.