tristaZero commented on issue #4131: ShardingSphere storage configuration, e2e test and doc for SkyWalking 7 URL: https://github.com/apache/skywalking/issues/4131#issuecomment-587314368 For the 2nd one sub-task, i present an analysis for us to discuss, welcome your comment and opinion. Specially ping @wu-sheng and @dmsolr here. Here are 311 tables created by sw, and 282 tables will be targets for sharding (initally supposed) since @wu-sheng told me tables with `all_` starter and `_inventory` terminator and one `register_lock` table are excluded. After digging the MySQL general log, i picked up some representative SQLs for us to discuss. From my point, it seems `time_bucket` and `id` are feasible for tables to do range sharding. I appended all the tables, target tables and SQLs for analysis below for you to review. Looking forward to your suggestion. In addtion, there are many tables and SQLs to shard, so i suggest at the beginning, we can pick up some important tables and SQLs to do sharding, the aim of which is to check our solution can run well from A to Z. After that, we can add more tables to `configuration` of `ShardingProxy` to shard continually, which can help split a huge task into many small ones and PRs.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
