Hi Daming, That’s not a big issue, we can do it step by step and you can learn it more at link[1].
@Wu-Sheng and @Daming, 2nd sub-task concerning tables and SQLs analysis was presented at issue[2], please review it and give your comments. :-) [1] https://shardingsphere.apache.org/ [2] https://github.com/apache/skywalking/issues/4131#issuecomment-587302393 Sincerely, trista Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 02/18/2020 11:32,Daming<zt...@foxmail.com> wrote: Hi Trista, I am not very familiar with ShardingSphere. I think I need to learn how to run it for e2e test, so I pick up the task. :-) ——————— Daming(@dmsolr) Apache SkyWalking 在 2020年2月18日,上午10:49,Juan Pan <panj...@apache.org> 写道: Hi Daming, I am glad you can take part in, of course ,you could. Therefore i will take care of sub-task 1to 3. BTW, do you know something about Sharding Proxy[1]? To finish sub-task 4 and 5, you have to use Sharding Proxy to shard DBs and tables, so as to make e2e tests run well. Don’t worry, i will work with you together, and to be frank, it is a good chance to learn two of Apache projects and coordinate them together for a better solution! [1] https://shardingsphere.apache.org/document/current/en/quick-start/sharding-proxy-quick-start/ Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 02/17/2020 10:33,Daming<zt...@foxmail.com> wrote: Could I pick up this two sub-tasks? 4. Provide configuration of Sharding Proxy[2] for Skywalking.[TODO] 5. Provide Acceptance test(maybe e2e tests of Skywalking?).[TODO] ————————— Daming(@dmsolr) Apache SkyWalking 在 2020年2月17日,上午9:58,Juan Pan <panj...@apache.org> 写道: That exactly what i concerned, moreover thanks for your joining. Could you tell me which part you are interested in, so that we can share the task list and work together. :-) Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 02/17/2020 00:34,吴晟 Sheng Wu<wu.sh...@foxmail.com> wrote: Hi Which part or both? Sheng Wu 吴晟 From Wu Sheng 's phone. ------------------ Original ------------------ From: apmail-wusheng-owner <apmail-wusheng-ow...@apache.org> Date: Mon,Feb 17,2020 0:26 AM To: dev <dev@skywalking.apache.org> Subject: Re: [DISCUSS] Add Apache ShardingSphere as the server storage for Apache SkyWalking hi&nbsp; I am glad to take part in. 发自我的iPhone ------------------ Original ------------------ From: Sheng Wu <wu.sheng.841...@gmail.com&gt; Date: Sun,Feb 16,2020 10:20 PM To: dev <dev@skywalking.apache.org&gt; Subject: Re: [DISCUSS] Add Apache ShardingSphere as the server storage for Apache SkyWalking Juan Pan <panj...@apache.org&gt; 于2020年2月16日周日 下午6:36写道: &gt; Hi fellows, &gt; &gt; &gt; I am working on providing ShardingSphere[1] as one of the server storages &gt; for Skywalking. &gt; ShardingSphere will help shard the data collected by Skywalking into &gt; different databases(Popular RDBMS, like MySQL, PostgreSQL and so on) and &gt; tables to seek better query performance and do scale-out of database. &gt; &gt; &gt; Since it is not an easy job, and needs some helps from community, i put &gt; task schedule and discussion items here to welcome your comments and &gt; suggestions. &gt; If you are interested in this one, welcome to be my partner! :-) &gt; &gt; &gt; ------------ &gt; Here is the schedule, &gt; 1. Acquire all required tables and query SQLs from db logs, like general &gt; log of MySQL. [DONE] &gt; 2. Analyse those tables and query SQLs to explore appropriate sharding &gt; strategy.[DOING] &gt; 3. Provide class implementation of `PreciseShardingAlgorithm` and &gt; `RangeShardingAlgorithm` of ShardingSphere to do sharding.[TODO] &gt; 4. Provide configuration of Sharding Proxy[2] for Skywalking.[TODO] 5. Provide Acceptance test(maybe e2e tests of Skywalking?).[TODO Yes. We call it e2e. You could find many storage implementation tests there. Zhenxu Ke and Haochao Zhuang are the two leading this part. BTW, your plan looks good to me. Sheng Wu 吴晟 Twitter, wusheng1108 &gt; ] &gt; 6. Update readme[3].[TODO] &gt; 7. Update storage doc[4].[TODO] &gt; ------------- &gt; &gt; &gt; It seems a long-term work, and i will do it step by step. Any progress &gt; will be updated here, also ISSUE [5] will give you thread of PRs and &gt; discussion detail. &gt; &gt; &gt; [1] https://shardingsphere.apache.org/ &gt; [2] &gt; https://shardingsphere.apache.org/document/current/en/quick-start/sharding-proxy-quick-start/ &gt; [3] https://github.com/apache/skywalking/tree/master/install &gt; [4 ] &gt; https://github.com/apache/skywalking/blob/master/docs/en/setup/backend/backend-storage.md &gt; [5] https://github.com/apache/skywalking/issues/4131 &gt; &gt; &gt; &gt; &gt; &gt;&nbsp; Juan Pan (Trista) &gt; &gt; Senior DBA &amp; PPMC of Apache ShardingSphere(Incubating) &gt; E-mail: panj...@apache.org &gt; &gt; &gt; &gt;