Updated on 2022-11-14 GMT+08:00

Checking Migration Results

Procedure

  1. After the migration task is complete, log in to the DDM instance to view migration results. Ensure that the DDM instance has the same data as the existing RDS for MySQL instance.

    Figure 1 Viewing data in table user_test
    Figure 2 Viewing data in table address_test

  2. Run the following command to view data distribution of tables. The broadcast table stores the same data in each shard. Data in the sharded table is distributed based on the algorithms you specified.

    show topology from <table_name>;
    Figure 3 Broadcast table user_test
    Figure 4 Sharded table address_test