[GitHub] [shardingsphere] sandynz commented on pull request #15161: Refactor to use unified PipelineTableMetaDataLoader in scaling

[GitBox <gi...@apache.org>]

sandynz commented on pull request #15161:
URL: https://github.com/apache/shardingsphere/pull/15161#issuecomment-1024270245


   Real test on MySQL 5.7.
   Use `t_order` and `t_order_item`, every table has 5000 records.
   
   New column was added in `t_order`, the same as  #10314:
   ```
   alter table t_order add column client_type TINYINT(2) NULL DEFAULT '-1';
   
   update t_order set client_type=-1 where client_type is null;
   ```
   
   Update `t_order` after scaling job starting:
   ```
   update t_order set status='ok1' where order_id>=1 and order_id<=1000;
   
   update t_order set client_type=1 where order_id>=1 and order_id<=100;
   ```
   
   Scaling job succeeded:
   ```
   mysql> show scaling status 464040641282341;
   +------+-------------+----------+--------+-------------------------------+--------------------------+
   | item | data_source | status   | active | inventory_finished_percentage | incremental_idle_minutes |
   +------+-------------+----------+--------+-------------------------------+--------------------------+
   | 0    | ds_0        | FINISHED | false  | 100                           | 1                        |
   | 1    | ds_1        | FINISHED | false  | 100                           | 1                        |
   +------+-------------+----------+--------+-------------------------------+--------------------------+
   2 rows in set (0.01 sec)
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org