Help Center/ Distributed Database Middleware/ Best Practices/ Sharding Database and Table Data of an RDS for MySQL Instance/ Creating a DRS Migration Task/ Checking Migration Results
Updated on 2022-11-14 GMT+08:00
View PDF
Share

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