Help Center> Data Replication Service> User Guide (Paris Region) > Troubleshooting> Solutions to Failed Check Items> Disk Space> Checking Whether the Destination Database Has Sufficient Storage Space
Updated on 2023-01-05 GMT+08:00

Checking Whether the Destination Database Has Sufficient Storage Space

MySQL Migration

Table 1 Checking whether the destination database has sufficient storage space

Check Item

Whether the destination database has sufficient storage space

Description

Check whether the destination database has sufficient storage space. If storage space is insufficient, the migration will fail.

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: Insufficient user permissions

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

Failure cause: The destination database does not have sufficient storage space (at least 2.5 times the size of the source database).

Handling suggestion: Scale up or clean up the destination database storage space. If you clean up the storage space, you will obtain more space within 2 to 3 minutes.

NOTE:

It is recommended that the size of the destination database disk be set to the smaller value of the following two values:

  1. 2.5 times the size of the data to be migrated in the source database.
  2. The size of the data to be migrated in the source database plus 200 GB.

PostgreSQL Synchronization

Table 2 Checking whether the destination database has sufficient storage space

Check Item

Whether the destination database has sufficient storage space

Description

Check whether the destination database has sufficient storage space. If storage space is insufficient, the synchronization will fail.

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 destination database does not have sufficient storage space (at least 1.5 times the size of the source database).

Handling suggestion: Scale up or clean up the destination database storage space. If you clean up the storage space, you will obtain more space within 2 to 3 minutes.

NOTE:

It is recommended that the size of the destination database disk be set to the smaller value of the following two values:

  1. 1.5 times the size of the data to be migrated in the source database.
  2. The size of the data to be migrated in the source database plus 200 GB.

MongoDB Migration

Table 3 Checking whether the destination database has sufficient storage space

Check Item

Whether the destination database has sufficient storage space

Description

Check whether the destination database has sufficient storage space. If storage space is insufficient, the migration will fail.

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 destination database does not have sufficient storage space (at least 1.5 times the size of the source database).

Handling suggestion: Scale up or clean up the destination database storage space. If you clean up the storage space, you will obtain more space within 2 to 3 minutes.

NOTE:

It is recommended that the size of the destination database disk be set to the smaller value of the following two values:

  1. 1.5 times the size of the data to be migrated in the source database.
  2. The size of the data to be migrated in the source database plus 200 GB.