Hi fellows,
I am working on providing ShardingSphere[1] as one of the server storages for Skywalking. ShardingSphere will help shard the data collected by Skywalking into different databases(Popular RDBMS, like MySQL, PostgreSQL and so on) and tables to seek better query performance and do scale-out of database. Since it is not an easy job, and needs some helps from community, i put task schedule and discussion items here to welcome your comments and suggestions. If you are interested in this one, welcome to be my partner! :-) ------------ Here is the schedule, 1. Acquire all required tables and query SQLs from db logs, like general log of MySQL. [DONE] 2. Analyse those tables and query SQLs to explore appropriate sharding strategy.[DOING] 3. Provide class implementation of `PreciseShardingAlgorithm` and `RangeShardingAlgorithm` of ShardingSphere to do sharding.[TODO] 4. Provide configuration of Sharding Proxy[2] for Skywalking.[TODO] 5. Provide Acceptance test(maybe e2e tests of Skywalking?).[TODO] 6. Update readme[3].[TODO] 7. Update storage doc[4].[TODO] ------------- It seems a long-term work, and i will do it step by step. Any progress will be updated here, also ISSUE [5] will give you thread of PRs and discussion detail. [1] https://shardingsphere.apache.org/ [2] https://shardingsphere.apache.org/document/current/en/quick-start/sharding-proxy-quick-start/ [3] https://github.com/apache/skywalking/tree/master/install [4 ]https://github.com/apache/skywalking/blob/master/docs/en/setup/backend/backend-storage.md [5] https://github.com/apache/skywalking/issues/4131 Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org
