Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Versions/ Checking Whether the Source Database Version Is Supported
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Database Version Is Supported

MySQL Migration

Table 1 Checking whether the source database version is supported

Check Item

Whether the source database version is supported

Description

Check whether the source database version is MySQL 5.5.x, MySQL 5.6.x, MySQL 8.0.x, and MySQL 5.7.x.

Failure Cause and Handling Suggestion

Failure cause: The source database version is not supported.

Handling suggestion: Export data and then import it following the instructions provided in the Migrating MySQL Data Using mysqldump section in the Relational Database Service User Guide.

Failure cause: Insufficient user permissions

Handling suggestion: Check whether the database user permissions meet the migration requirements.

Failure cause: An internal error occurs.

Handling suggestion: Contact Huawei technical support.

Failure cause: This item cannot be checked because the source database fails to be connected.

Handling suggestion: Check whether the source database is connected.

Migration from MongoDB to DDS

Table 2 Checking whether the source database version is supported

Check Item

Whether the source database version is supported

Description

Check whether the source database version is MongoDB 3.2.x, 3.4.x, or 4.0.x.

Failure Cause and Handling Suggestion

Failure cause: The source database version is not supported.

Handling suggestion: Check whether the source database version is MongoDB 3.2x, 3.4.x, and 4.0.x.

Failure cause: This item cannot be checked because the source database fails to be connected.

Handling suggestion: Check whether the source database is connected.

Failure cause: The incremental data is obtained in changeStream mode but the source database version is earlier than 4.0.

Handling suggestion: In changeStream mode, ensure that the source database version is 4.0 or later.

Failure cause: An internal error occurs.

Handling suggestion: Contact Huawei technical support.

PostgreSQL to GaussDB(DWS) Synchronization

Table 3 Checking Whether the Source Database Version Is Supported

Check Item

Whether the source database version is supported

Description

Check whether the source database version is PostgreSQL 9.4, PostgreSQL 9.5, PostgreSQL 9.6, PostgreSQL 10.0, PostgreSQL 11.0, PostgreSQL 12.0, and PostgreSQL 13.0..

Failure Cause and Handling Suggestion

Failure cause: This item cannot be checked because the source database fails to be connected.

Handling suggestion: Check whether the source database is connected.

Failure cause: The source database version is not supported.

Handling suggestion: Check whether the source database version is supported. Currently, only PostgreSQL 9.4, PostgreSQL 9.5, PostgreSQL 9.6, PostgreSQL 10.0, PostgreSQL 11.0, and PostgreSQL 12.0, and PostgreSQL 13.0. are supported.

Failure cause: Insufficient user permissions

Handling suggestion: Check whether the database user permissions meet the migration requirements.

Failure cause: An internal error occurs.

Handling suggestion: Contact Huawei technical support.

Oracle Synchronization

Table 4 Checking whether source database version is supported

Check Item

Whether the source database version is supported

Description

Check whether the source database version is Oracle 10g, 11g, 12c, 18c, or 19c.

Failure Cause and Handling Suggestion

Failure cause: The source database version is not supported.

Handling suggestion: Check whether the source database version is supported. Currently, only Oracle 10g, 11g, 12c, 18c, and 19c are supported.

MySQL -> PostgreSQL Synchronization

Table 5 Checking whether the source database version is supported

Check Item

Whether the source database version is supported

Description

Check whether the source database version meets the requirements for synchronization from MySQL to PostgreSQL.

Failure Cause and Handling Suggestion

Failure cause: The source database version is not supported.

Handling suggestion: Check whether the source database version is supported. Currently, only MySQL 5.5, 5.6, 5.7, and 8.0 are supported.