Updated on 2024-09-05 GMT+08:00

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 AP-Singapore.
  3. Click in the upper left corner of the page and choose Databases > Data Replication Service.
  4. Click the DRS instance name.
  5. Click Migration Comparison.
  6. Under the Compare Data - Validate ALL Rows/Values and Compare Data - Double Check During Cutover tabs, 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 AP-Singapore.
  3. Click in the upper left corner of the page and choose Databases > 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 test is successful, click Log In.
  7. 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.