Help Center/ GaussDB(for MySQL)/ Best Practices/ From ECS-hosted MySQL to GaussDB(for MySQL)/ Procedure/ Cloud Migration/ Checking the Migration Results
Updated on 2023-10-19 GMT+08:00
View PDF

Checking the Migration Results

You can check migration results with either of the following methods:

Method 1: (Automatically) View the migration results on the DRS console. DRS can compare migration objects, users, and data of source and destination databases and obtain the migration results.

Method 2 (manually): View the migration results on the GaussDB(for MySQL) console. Log in to the destination database to check whether the databases, tables, and data are migrated. Manually confirm the data migration status.

Viewing Migration Results on the DRS Console

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select EU-Dublin.
  3. Under the service list and choose Database > Data Replication Service.
  4. Click the target DRS instance name.
  5. Click Migration Comparison.

  6. Under Compare Data - Validate ALL Rows/Values and Compare Data - Double Check During Cutover tab to check whether the objects of the source database have been migrated to destination database.

Viewing Migration Results on the GaussDB(for MySQL) Console

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select EU-Dublin.
  3. Under the service list, choose Database > GaussDB(for MySQL).
  4. Click GaussDB(for MySQL). Locate the target instance and choose More > Log In in the Operation column.
  5. In the displayed dialog box, enter the password and click Test Connection.
  6. After the connection is successful, click Log In.
  7. Enter the password to log in to the GaussDB(for MySQL) instance.
  8. Check and confirm the destination database name and table name. Check whether the data migration is complete.

Testing GaussDB(for MySQL) Performance

After the migration is complete, test GaussDB(for MySQL) performance by referring to Performance White Paper.

Parent topic: Cloud Migration