Supplementary instruction about the figure:
Support to migrate tables in sharding rule configuration only, can't support to migrate specified tables.
The process of migration splits into two steps, inventory data migration and incremental data synchronization.
During inventory data migration, ShardingSphere-Scaling use select *
statement to acquire the data, and use insert
statement to migrate the data to the target;
During incremental data migration, ShardingSphere-Scaling use binlog to migrate the data, and mark the binlog position before migration.
where predication
.MySQL: 5.1.15 ~ 5.7.x
ShardingSphere-Proxy: 3.x ~ 5.x
Refer to the Quick Start