Re: Sharingsphere for Django
Jdbc is 30-40% higher than proxy based on different scenarios [1]. However, since `proxy + mysql` is similar with other distributed database architecture, that means proxy has the similar performance with other sharding databases and is ready for production env (from the feedback of our community [2, 3]). [1] https://shardingsphere.apache.org/document/current/en/test-manual/performance-test/benchmarksql-proxy-sharding-test/ [2] https://shardingsphere.apache.org/blog/en/material/ [3] https://www.mysql.com/customers/view/?id=1461 -- Trista Pan Twitter & Github: tristaZero On 10/4/2022 19:05，Edward J. Yoon wrote： Just curious about whether there's some performance difference between jdbc vs. proxy. On Tue, Oct 4, 2022 at 8:01 PM Edward J. Yoon wrote: Currently there are 4 set consists of single master and single slave, and one integrated db based on multi source replication. % 4 modular sharding is used at application level. So, I'm looking for the elastic scalability, easy-to-use/maintenance, and the high performance middleware like shardingsphere. On Tue, Oct 4, 2022 at 7:50 PM Juan Pan wrote: Hello Edward J. Yoon, adopting shardingshpere for the order database that requires to cover heavy read and write. Does that mean you want ShardingSphere to do the read-write-splitting function? sharded mysql cluster with division method You already sharded your mysql database cluster? Do you plan to let ShardingSphere help you manage all the mysql shards? ShardingSphere currently offers two clients: ShardingSphere-JDBC (for Java APP) and ShardingSphere-Proxy. In your case, I recommend deploying ShardingSphere-Proxy[1] to help you with read-write-splitting or sharding management. Then, for your Python workload, simply connect to ShardingSphere-Proxy using the MySQLdb library. Best wishes, Trista [1] https://shardingsphere.apache.org/document/current/en/quick-start/shardingsphere-proxy-quick-start/ -- Trista Pan Twitter & Github: tristaZero On 10/4/2022 18:29，Edward J. Yoon wrote： Hello, I am edwardyoon, currently working at Delivery Hero. From there, I am considering adopting shardingshpere for the order database that requires to cover heavy read and write. Our system is consists of django and sharded mysql cluster with division method at this moment. I’d like to know whether there is a reliable django library that can be used for real production. Thanks. -- Best Regards, Edward J. Yoon -- Best Regards, Edward J. Yoon -- Best Regards, Edward J. Yoon
Re:Sharingsphere for Django
Hello Edward J. Yoon, > adopting shardingshpere for the order database that requires to cover heavy > read and write. Does that mean you want ShardingSphere to do the read-write-splitting function? > sharded mysql cluster with division method You already sharded your mysql database cluster? Do you plan to let ShardingSphere help you manage all the mysql shards? ShardingSphere currently offers two clients: ShardingSphere-JDBC (for Java APP) and ShardingSphere-Proxy. In your case, I recommend deploying ShardingSphere-Proxy[1] to help you with read-write-splitting or sharding management. Then, for your Python workload, simply connect to ShardingSphere-Proxy using the MySQLdb library. Best wishes, Trista [1] https://shardingsphere.apache.org/document/current/en/quick-start/shardingsphere-proxy-quick-start/ -- Trista Pan Twitter & Github: tristaZero On 10/4/2022 18:29，Edward J. Yoon wrote： Hello, I am edwardyoon, currently working at Delivery Hero. From there, I am considering adopting shardingshpere for the order database that requires to cover heavy read and write. Our system is consists of django and sharded mysql cluster with division method at this moment. I’d like to know whether there is a reliable django library that can be used for real production. Thanks. -- Best Regards, Edward J. Yoon
Re:[DISCUSS] Removing ElasticJob-Cloud for now
Looks like this thread re-active! My +1 for that, because it still takes a lot of effort to maintain these legacy APIs. -- Trista Pan Twitter & Github: tristaZero On 08/16/2022 21:34，吴伟杰 wrote： Hi community I want to discuss removing ElasticJob-Cloud from ShardingSphere ElasticJob in release 3.1.0. ElasticJob-Cloud is a part of ElasticJob distributed scheduling solution, which uses Apache Mesos to manage and isolate resources. But I have to start this discussion for some reason: - Apache Mesos was voted to Move to Attic [1]. - Due to few people familiar with Apache Mesos and limited time available, it is difficult for ShardingSphere community to maintain ElasticJob-Cloud. I'm truly grateful for those contributed to ElasticJob-Cloud in the past. Please voice your opinions as fully as possible. Thank you. [1] https://lists.apache.org/thread/ysvw7bb1rd8p88fk32okkzr75mscdjo8 Regards, Weijie --- Wu Weijie 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN
Re:[VOTE] Release Apache ShardingSphere 5.2.0 [Round 2]
+1 Hi, here is my checking list. [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] LICENSE, NOTICE and DISCLAIMER files are correct. [x] All files have license headers if necessary. -- Trista Pan Twitter & Github: tristaZero On 09/5/2022 18:08，Zhengqiang Duan wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.2.0 Release notes: https://github.com/apache/shardingsphere/blob/5.2.0-release/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.2.0/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1109/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.2.0/ Release Commit ID: https://github.com/apache/shardingsphere/commit/d4c0048a5c3fd61625b3b502380c65b7e88cd927 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/involved/release/shardingsphere/ GPG user ID: Zhengqiang Duan The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. Best regards, Zhengqaing —— Zhengqaing Duan (duanzhengqi...@apache.org) Apache ShardingSphere PMC GitHub@strongduanmu
Re:[DISCUSS] Add original authors as collaborators of shardingsphere-on-cloud
Hello, It’s glad to see they are willing to contribute here continuously! Actually, It’s not necessary to vote it. So definitely my +1 for this one. Best, Trista -- Trista Pan Twitter & Github: tristaZero On 08/22/2022 15:55，吴伟杰 wrote： Hi community The project ShardingSphere on Cloud has been donated to Apache ShardingSphere community. Since the original authors of ShardingSphere on Cloud are not committers of Apache ShardingSphere, they have no write access to the repository https://github.com/apache/shardingsphere-on-cloud. My proposal is adding non-committer original authors as collaborators of ShardingSphere on Cloud, so they could keep contributing to the projects without unnecessary restrictions. The discussion will last until August 25 08:00:00 AM UTC 2022. If there are no objections, the following GitHub account (original authors of shardingsphere-on-cloud) will be added to .asf.yaml. ``` collaborators: - windghoul - mlycore ``` Regards, Weijie --- Wu Weijie 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN
Re:[DISCUSS] ShardingSphere on Cloud Donation Proposal
Hello +1 I like this idea. -- Trista Pan Twitter & Github: tristaZero On 08/1/2022 13:34，吴伟杰 wrote： Hi community, I want to discuss about donating ShardingSphere on Cloud to ShardingSphere community. The proposal is: https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSphere+on+Cloud+Donation+Proposal The content in wiki is as below: # Description The shardingsphere-on-cloud project, including ShardingSphere Operator, Helm Charts, and other cloud solutions, aims at enhancing the deployment and management capabilities of Apache ShardingSphere Proxy on the cloud. ShardingSphere Operator is a Kubernetes software extension written with the Operator extension pattern of Kubernetes. ShardingSphere Operator can be used to quickly deploy an Apache ShardingSphere Proxy cluster in the Kubernetes environment and manage the entire cluster life cycle. # Proposal This proposal aims to introduce existing shardingsphere-on-cloud repositories, developers, and communities to the Apache Software Foundation (ASF) as sub-items of ShardingSphere. The project aims to improve Apache ShardingSphere Proxy's deployment and management capabilities on Kubernetes. Thus, this proposal is submitted to contribute shardingsphere-on-cloud to the Apache ShardingSphere Incubator under the Apache License, Version 2.0. Please refer to the following link for all items available for the project: https://github.com/SphereEx/shardingsphere-on-cloud # Background For applications, relevant details and differences of the underlying infrastructure have been shielded, and all applications in the Kubernetes cluster can enjoy these pooled resources, maximizing the utilization of each machine under Kubernetes' automatic scheduling. Additionally, some features of Kubernetes can reduce the management consumption of applications in the Kubernetes environment. Apache ShardingSphere, as an outstanding open source distributed database middleware, requires a cloud solution to help Apache ShardingSphere adopt the cloud and enhance its capabilities on the cloud - so SphereEx decided to contribute shardingsphere-on-cloud as a sub-project of Apache ShardingSphere. # Status Quo The development of ShardingSphere Operator v0.1.0 has been completed recently and passed the usability test. The project involves complete user documentation. # Developer Founded by the Apache ShardingSphere core team, SphereEx is a software provider that provides a new generation of open source heterogeneous, distributed data service platforms for enterprises and is committed to providing targeted products and solutions that best fit business scenarios. Its core capability is to improve users' data service capability by creating the upper standard and ecology of the heterogeneous database. # Code Contribution Github Repo: https://github.com/SphereEx/shardingsphere-on-cloud # Source and Intellectual Property Submission Plan Shardingsphere-on-cloud was developed by SphereEx in 2022. The core developer of the project is Li Zhuo. SGA is provided by SphereEx. Regards, Weijie --- Weijie Wu 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN
Re:[ANNOUNCE] New PMC: Zhengqiang Duan
Congrats! -- Trista Pan Twitter & Github: tristaZero On 07/19/2022 20:41，吴伟杰 wrote： Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Zhengqiang to become a PMC and we are pleased to announce that he has accepted. Zhengqiang has given his enormous energy to ShardingSphere and community so far. Thanks for your dedication! We welcome more people to join this wonderful community. Thanks, everyone! Regards, Weijie --- Weijie Wu 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN
Re:[VOTE] Release Apache ShardingSphere 5.1.2 [Round 3]
Hello, +1 binding But some suggestions for next time, 1. Remove the license of ShardingSphere from charts package since there is no relevant file references. 2. Add the license of zookeeper chats, which is Apache 2 license but doesn’t mention them in license file of charts package 3. As the version of chats is independent from ShardingSphere, its package name is better to be `apache-shardingsphere-proxy-chart-1.1.0.tgz` Best, Trista -- Trista Pan Twitter & Github: tristaZero On 06/14/2022 00:11，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.1.2 [Round 3]. Release notes: https://github.com/apache/shardingsphere/blob/5.1.2/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.1.2/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1087/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.1.2/ Release Commit ID: https://github.com/apache/shardingsphere/commit/97d0d59ebd3a68612aad20896d1bc31f7d83 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG key ID: 55C1A242B0F517C4 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. Regards, Weijie --- Weijie Wu 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN
Re:[VOTE] Release Apache ShardingSphere 5.1.2 [Round 2]
Hello -1. I suggested re-releasing them, since I found there is no LICENSE and NOTICE files in chart package. BTW, from my view, I prefer apache-shardingsphere-proxy-1.1.0-chart to shardingsphere-chart, FYI. Best, Trista --- Email：panj...@apache.org Juan Pan(Trista) Apache ShardingSphere On 06/10/2022 10:38，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.1.2 [Round 2]. Release notes: https://github.com/apache/shardingsphere/blob/5.1.2/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.1.2/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1085/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.1.2/ Release Commit ID: https://github.com/apache/shardingsphere/commit/afe7c824ac70e34ea866bdde4f43e6be49989aef Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG key ID: 55C1A242B0F517C4 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. Regards, Weijie --- Weijie Wu 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN
[GSoC'22] Contributor Proposals Open!
Hello guys, The contributor's application for GSoC'22 is undergoing. If you are interested in being part of Apache ShardingSphere[1], welcome your application there! You could get all the ShardingSphere programs of GSoC'22 here [2]. From my last year's experience, 1. The task detail, e.g., [3], is supposed to be important input for your proposal, and then make your schedule in that proposal case by case. 2. We would like to invite our candidates to try some preliminary help you quickly enter into this area. Our potential mentors are willing to give a hand！ At last, we still have slack channel [4] if you like. ;-) [1] https://shardingsphere.apache.org/ [2] https://github.com/apache/shardingsphere/discussions/15417#discussioncomment-2565788 [3] https://issues.apache.org/jira/browse/COMDEV-447 [4] https://join.slack.com/t/apacheshardingsphere/shared_invite/zt-sbdde7ie-SjDqo9~I4rYcR18bq0SYTg Any questions, please be free to let me know. Best, Trista -- Trista Pan Twitter & Github: tristaZero
Re:[VOTE] Release Apache ShardingSphere 5.1.1 [Round 2]
+1 Thanks, I checked, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] LICENSE, NOTICE and DISCLAIMER files are correct. [x] All files have license headers if necessary. -- Trista Pan Twitter & Github: tristaZero On 04/8/2022 19:53，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.1.1 [Round 2]. Release notes: https://github.com/apache/shardingsphere/blob/5.1.1/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.1.1/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1081/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.1.1/ Release Commit ID: https://github.com/apache/shardingsphere/commit/11df594e22b7b30e90cc23093093c30c8668d2c6 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG key ID: 55C1A242B0F517C4 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. --- Weijie Wu 吴伟杰 Apache ShardingSphere PMC GitHub@TeslaCN
Re:[VOTE] Release Apache ShardingSphere 5.1.1
Hello +1, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] LICENSE, NOTICE and DISCLAIMER files are correct. [x] All files have license headers if necessary. -- Trista Pan Twitter & Github: tristaZero On 04/2/2022 16:01，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.1.1 Release notes: https://github.com/apache/shardingsphere/blob/5.1.1/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.1.1/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1080/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.1.1/ Release Commit ID: https://github.com/apache/shardingsphere/commit/b7ae496facef0523138f9d7ff815369609a561cb Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG key ID: 55C1A242B0F517C4 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. --- Weijie Wu 吴伟杰 Apache ShardingSphere Committer GitHub@TeslaCN
Re:[ANNOUNCE] New PMC: Weijie Wu
Congrats, Weijie! -- Trista Pan Twitter & Github: tristaZero On 04/6/2022 14:39，Juan Pan wrote： Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Weijie to become a PMC and we are pleased to announce that he has accepted. Weijie has given his enormous energy to ShardingSphere and ShardingSphere-elastic job community so far. Thanks for your dedication! We welcome more people to join this wonderful community. Thanks, everyone! Regards, Trista -- Trista Pan, Apache ShardingSphere PMC Twitter, @tristaZero
[ANNOUNCE] New PMC: Weijie Wu
Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Weijie to become a PMC and we are pleased to announce that he has accepted. Weijie has given his enormous energy to ShardingSphere and ShardingSphere-elastic job community so far. Thanks for your dedication! We welcome more people to join this wonderful community. Thanks, everyone! Regards, Trista -- Trista Pan, Apache ShardingSphere PMC Twitter, @tristaZero
Re:[DISCUSS] Release Plan of ShardingSphere 5.1.1
Looks nice to me. -- Trista Pan Twitter & Github: tristaZero On 03/28/2022 21:11，吴伟杰 wrote： Hi community, After the release of 5.1.0 version, we have received a lot of feedback from users and developers. Now we plan to release the ShardingSphere 5.1.1 version this week, which has made a lot of optimization and improvement for these feedback. Please refer to this release notes[1] to confirm whether it contains the features you expect. If I miss anything, please remind me ASAP. If there are any suggestions, please feel free to tell us. [1] https://github.com/apache/shardingsphere/issues/16439 --- Weijie Wu 吴伟杰 Apache ShardingSphere Committer GitHub@TeslaCN
Re:[VOTE] Donate ShardingSphere-Proxy Helm Chart
So great +1 -- Trista Pan Twitter & Github: tristaZero On 03/29/2022 11:24，zhangli...@apache.org wrote： Hi community, Please vote about donate ShardingSphere-Proxy Helm Chart to ShardingSphere community. The proposal is: https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSphere-Proxy+Helm+Chart+Donation+Proposal I paste the content below: # Abstract ShardingSphere-Proxy Helm Chart utilizes the Helm Charts tool to deploy ShardingSphere-Proxy to Kubernetes clusters. Leveraging Helm syntax, SphereEx builds and distributes the project. # Proposal The goal of this proposal is to bring the existing ShardingSphere-Proxy Helm Chart codebase, developers and community into the Apache Software Foundation (ASF) as ShardingSphere's sub-project. This project aims to improve the delivery capability of ShardingSphere-Proxy on Kubernetes. ShardingSphere-Proxy Helm Chart is submitting this proposal to donate it to the Apache ShardingSphere Incubator under the Apache License, Version 2.0, in order to replace the existing scheduler framework. These artifacts are currently available on GitHub at: https://github.com/SphereEx/shardingsphere-charts.git # Background ShardingSphere is a Top-Level open source distributed database middleware. However, currently ShardingSphere cannot be quickly deployed and upgraded in a cloud environment. SphereEx created the Helm Chart tool ShardingSphere-Proxy Helm Chart to manage ShardingSphere-Proxy in Kubernetes. The project allows users to quickly deliver ShardingSphere-Proxy projects for a cloud environment such as Kubernetes. SphereEx decided to donate ShardingSphere-Proxy Helm Chart as a ShardingSphere sub-project with the desire to provide cloud services. # Current Status ShardingSphere-Proxy Helm Chart has recently completed the development of its own v1.0.0 version, and passed the usability test. The project also contains full usage documentation. We think that bringing ShardingSphere-Proxy Helm Chart into the ShardingSphere community can help ShardingSphere expand its deployment and delivery capabilities on the cloud, and help ShardingSphere grow closer to the cloud environment. # Core Developer SphereEx provides a new generation of open source heterogeneous distributed data service platform. SphereEx's core competence can be found in its ability to improve users’ data service capabilities, by creating upper-level standards and ecosystems for heterogeneous databases. # Donation Source Github Repo: https://github.com/SphereEx/shardingsphere-charts.git # Source and Intellectual Property Submission Plan ShardingSphere-Proxy Helm Chart was originally created by SphereEx in 2022. The core developer of the project is li zhuo. Last but not least, the SGA will be provided by SphereEx. -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:Example generator is completed nearly
Nice work! -- Trista Pan Twitter & Github: tristaZero On 03/26/2022 19:52，zhangli...@apache.org wrote： Hi Commnumity, May I have your attention please. Our new example system - automatic example codes generator is completed nearly. The example code of ShardingSphere-JDBC is done for now; the example code of ShardingSphere-Proxy still need to be adjust. The example generator is in [1], please try if you are interested. It is the best way to show examples for lots of configuration domains. The old example may be removed in the future. Let's expect the new example online. Thanks for @Guocheng Tang do the great job. [1] https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-example-generator -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re: Apply to join the project
Hello Panagiotis, If you could receive this email, that means you’re literally part of this community, welcome! (As it's TO dev@shardingsphere.apache.org rather than someone’s specific address.) ShardingSphere community is always open to everyone, and hope to vote more committers! There are many ways to contribute, like programming, fixing and providing doc, promotion, organizing meetup, and anything that could help the community grow up [1,2]. In this process, you will interact more with the community and have more connections. Meanwhile, the people in this community will be impressed by your activities and be voted to be our committer. May I get your interests or which part you want to have a try? Generally, we still have many good-first-issues[3] (Filter by label) for newcomers. BTW, here is the team [4]. Any questions, please be free to raise them here. Best, Trista [1] https://shardingsphere.apache.org/community/en/contribute/document-contributor/ [2] https://shardingsphere.apache.org/community/en/contribute/contributor/ [3] https://github.com/apache/shardingsphere/issues?q=is%3Aopen+is%3Aissue+label%3A%22good+first+issue%22 [4] https://shardingsphere.apache.org/community/en/team/ -- Trista Pan Twitter & Github: tristaZero On 03/22/2022 19:37，Panagiotis Parthenis wrote： Dear community, I have already joined the project. I receive the `welcome email`, but I am not sure if I added it to the community. In addition, I would like to become a Committer, if I fulfil the requirements. Please let me know about the Committer process. I would like to thank you in advance for your help, time, and collaboration. I remain at your disposal for any further information. Best regards, Panagiotis Parthenis On Wed, 16 Mar 2022 at 14:54, Panagiotis Parthenis wrote: Dear community, I have already have joined on the project!! Best Regards, Panagiotis Parthenis On Mon, 14 Mar 2022 at 10:59, 亚幸 wrote: Hi Panagiotis, Please refer to the following for useful links to join the community's Slack, Twitter etc: https://linktr.ee/ApacheShardingSphere Tutors are available on Slack and GitHub issues. Best,
[GSoC 2022] Apache ShardingSphere is going to attend as the mentoring community
Hello community, As you know, [GSoC 2022](https://summerofcode.withgoogle.com/) is coming, our community would like to be part of it and provide mentoring for all the participants! You will learn more here [1]. Currently, we are collecting ideas. Anyone from our community wants to be the mentor for this program, welcome your ideas! Besides, if you want to be a contributor to this program, please keep an eye on the following[1] discussion and GSoC page! 磊 [1] https://github.com/apache/shardingsphere/discussions/15417 -- Trista Pan Twitter & Github: tristaZero
Re:[VOTE] Release Apache ShardingSphere 5.1.0 [round 4]
Hi, +1 [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] LICENSE, NOTICE and DISCLAIMER files are correct. [x] All files have license headers if necessary. -- Juan Pan(Trista), Twitter: @tristaZero On 02/9/2022 19:03，Haoran Meng wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.1.0 Release notes: https://github.com/apache/shardingsphere/blob/5.1.0/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.1.0/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1077/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.1.0/ Release Commit ID: https://github.com/apache/shardingsphere/commit/938a4bcc553d350ca5936fed36965ee0c0a0c1ad Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG user ID: menghaoran The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Best, Haoran Meng Apache ShardingSphere
回复：订阅
Hello, This page[1] could guide you how to subscribe this ML, and welcome. [1] https://shardingsphere.apache.org/community/en/contribute/subscribe/ Trista -- Juan Pan(Trista), Twitter: @tristaZero 在2022年01月3日 21:43，setdaemon 写道： | | setdaemon | | setdae...@163.com | 签名由网易邮箱大师定制
Re:[VOTE] Release Apache ShardingSphere ElasticJob UI 3.0.1
Hi +1, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] LICENSE, NOTICE files are correct. [x] All files have license headers if necessary. -- Juan Pan(Trista), Twitter: @tristaZero On 12/28/2021 10:31，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob UI version 3.0.1 Release notes: https://github.com/apache/shardingsphere-elasticjob-ui/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-ui-3.0.1/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob-ui/tree/3.0.1/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob-ui/commit/cee1d31a058bcb3627ac23e9eb37e04b954157e1 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob-ui/ GPG key ID: 2DE3A2A9 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. --- Weijie Wu 吴伟杰 Apache ShardingSphere Committer GitHub@TeslaCN
Re:In January 2022，Apache APISIX Community want to online meetup with Apache ShardingSphere
Hello Yeliang and APISIX community, Nice to meet you. ;-) This proposal sounds cool, we’d like to be part of this co-meetup. Plus, if we like, we still can involve other communities. @Liye could you have a look this event invitation? Best, Trista -- Juan Pan(Trista), Twitter: @tristaZero On 11/17/2021 13:49，yeliang wang wrote： Hi, community, My name is Yeliang Wang, and I am Apache APISIX Committer. i want to have the Apache APISIX Online Meetup on January 15, 2022, and I hope to invite ShardingSphere to participate. Participation content: 1、Two keynote, One topic for 45 minutes. Thanks, Yeliang Wang, Apache APISIX Committer Github: wang-yeliang
[ANNOUNCE] New committer: Thanoshan MV
Hello community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Thanoshan MV to become a committer, and we are pleased to announce that he has accepted. Thanoshan MV helped proofread a large chunk of parser files and provided his help to the community. Thanks for your contributions. Hope see your further interactions with the community! Fellows, could we have your welcome to our new committer? Regards, Trista -- Juan Pan(Trista), Twitter: @tristaZero
CVE-2021-26558: Apache ShardingSphere-UI: Deserialization of Untrusted Data
Severity: low Description: Deserialization of Untrusted Data vulnerability of Apache ShardingSphere-UI allows an attacker to inject outer link resources. This issue affects Apache ShardingSphere-UI Apache ShardingSphere-UI version 4.1.1 and later versions; Apache ShardingSphere-UI versions prior to 5.0.0. Mitigation: This issue is related to ShardingSphere-UI project. If you do not deploy UI project, it is not required to upgrade. Otherwise, the vulnerability issue of servers deployed UI project or version upgrade is supposed to consider.
Re:[VOTE] Release Apache ShardingSphere 5.0.0
HI +1 binding. My checked items, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] Source code distributions have correct names matching the current release. [x] LICENSE and NOTICE files are correct for each ShardingSphere repo. [x] All files have license headers if necessary. A tiny tip for the tar name, Instead of `apache-shardingsphere-5.0.0-src-release`, I think `apache-shardingsphere-5.0.0-src` will be better to be compressed as apache-shardingsphere-5.0.0-src.zip -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) & AGE (Incubating) mentor Twitter, @tristaZero On 11/2/2021 01:00，Haoran Meng wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.0.0 Release notes: https://github.com/apache/shardingsphere/blob/5.0.0/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1069/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.0.0/ Release Commit ID: https://github.com/apache/shardingsphere/commit/d3409a2e36b4233372cfd048038634b7a518dc5d Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG user ID: menghaoran The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive.
回复：官网图文描述问题咨询
Hi, Thanks for your question, but 1. The mail is expected to be written in English. 2. The image didn’t show well, could you raise an issue on [1]? I suppose images can not work well on apache ML. Thanks, Trista [1] https://github.com/apache/shardingsphere/issues -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) & AGE (Incubating) mentor Twitter, @tristaZero 在2021年11月7日 13:09，廖凌浩(10016253) 写道： 尊敬的ShardingSphere开发组织： 我于2021年11月2日阅读以下网址https://shardingsphere.apache.org/document/current/cn/overview/中对应的信息进行学习时，发现文中有一副图片的 箭头指向有问题，特反馈如下： 正确的图片如下： 图中箭头连线代表的含义，我理解为是应用程序通过 ShardingSphere-JDBC 和ShardingSphere-Proxy 调用数据库时，ShardingSphere-JDBC 和ShardingSphere-Proxy 会从注册中心拉取分库分表配置策略。 有疑问的图片如下： 如果之前我的理解无误，那么，我怀疑这幅图片中的箭头连线应该画反了。如果是这样，期望能够修正官网中的图片。
Welcome to Apache ShardingSphere first DEV meetup
Hello community, Hope you all do well! Good news here! We plan to hold the first ShardingSphere Dev meetup on 13th Nov in Beijing and ONLINE! (You know, due to the coronavirus, it's likely the offline meetup will be canceled.) This is our first community meetup. We truly pay a lot of effort to prepare it and invite our PMC, committers, and partner communities to give some talks on Tech and Apache Opensource way! Very appreciated our mentors, Craig, Willem, Gosling for providing valuable and helpful guides to ShardingSphere! Much thanks to our team [1] and contributors to make this community active and diverse so far! We greatly welcome anyone interested in ShardingSphere or making new friends here to join offline and online ;-) ! I will append the Livestream link later on, but you will learn the schedule at this point, ### Schedule 1. The introduction of community development after becoming TLP, Liang Zhang (PMC Chair) 2. New features and the highlight of Apache ShardingSphere 5.0.0, Trista Pan (PMC) 3. The best practice of Apache ShardingSphere, Haoran Meng (PMC) 4. How to leverage Apache ShardingSphere, Zhengchao Hu (Seed user) 5. How to start my openSource journey in ShardingSphere community, Guocheng Tang(Contributor) 6. OpenSource Roundtable, Sheng Wu (PMC Chair of Skywalking) & Ming Wen (PMC Chair of APISIX) & Hualiang Wang (Contributor of APISIX) & Liang Zhang ### Date & venue Date: 14:00-17:30, 13th Nov Venue: Intelligent Manufacturing Innovation Center, No.32 Zhongguancun Street, Haidian District, Beijing See you online and offline at this first ShardingSphere meetup! Warmly regards, Trista [1] https://shardingsphere.apache.org/community/en/team/ ---------- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) & AGE (Incubating) mentor Twitter, @tristaZero
Re: [VOTE] Release Apache ShardingSphere 5.0.0-RC1
Hi Sheng, Skywalking eyes will check the license of binary release, right? That way, I suggest we have a try, @Haoran. -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) & AGE (Incubating) mentor Twitter, @tristaZero On 10/23/2021 13:48，Sheng Wu wrote： Hi, SkyWalking eyes tool provides capabilities to resolve all dependencies for Maven. You could use it to check. zhangli...@apache.org 于2021年10月23日 周六下午12:24写道： Sorry, I have to say -1. The new lib `rxtx` is LGPL which is CATEGORY X. I find other problems which is not block issue, but it is better to fix them into next release. 1. The licenses of new libraries are not add yet, they are: Aalto XML (Apache 2.0) Barchart UDT Bundle (BSD2) Stax2 API (BSD2) The missing licenses are all compatible. 2. he reference of `commons-compiler 3.0.11` is wrong. 3. ElasticJob has already upgraded to 3.0.1, ShardingSphere is still using 3.0.0-beta which is not stable. -- Sincerely, Liang Zhang (John) Apache ShardingSphere Zheng Feng 于2021年10月21日周四 下午6:04写道： +1 (non-binding) Haoran Meng 于2021年10月20日周三 下午4:38写道： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.0.0-RC1 Release notes: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-RC1/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1067/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.0.0-RC1/ Release Commit ID: https://github.com/apache/shardingsphere/commit/d38a546468a3eb3397cb3d218f61d626229f113a Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG user ID: menghaoran The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sheng Wu 吴晟 Apache SkyWalking Apache Incubator Apache ShardingSphere, ECharts, DolphinScheduler podlings Zipkin Twitter, wusheng1108
Re: [VOTE] Release Apache ShardingSphere 5.0.0-RC1
Hi Liang, All these license issues are all about binary package, rather than source code release, right? -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) & AGE (Incubating) mentor Twitter, @tristaZero On 10/23/2021 12:23，zhangli...@apache.org wrote： Sorry, I have to say -1. The new lib `rxtx` is LGPL which is CATEGORY X. I find other problems which is not block issue, but it is better to fix them into next release. 1. The licenses of new libraries are not add yet, they are: Aalto XML (Apache 2.0) Barchart UDT Bundle (BSD2) Stax2 API (BSD2) The missing licenses are all compatible. 2. he reference of `commons-compiler 3.0.11` is wrong. 3. ElasticJob has already upgraded to 3.0.1, ShardingSphere is still using 3.0.0-beta which is not stable. -- Sincerely, Liang Zhang (John) Apache ShardingSphere Zheng Feng 于2021年10月21日周四 下午6:04写道： +1 (non-binding) Haoran Meng 于2021年10月20日周三 下午4:38写道： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.0.0-RC1 Release notes: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-RC1/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1067/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.0.0-RC1/ Release Commit ID: https://github.com/apache/shardingsphere/commit/d38a546468a3eb3397cb3d218f61d626229f113a Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG user ID: menghaoran The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive.
[ANNOUNCE] New PMC: Haoran Meng
Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Haoran to become a PMC and we are pleased to announce that he has accepted. Haoran has given enormous energies to ShardingSphere community so far. Thanks for your continued contributions! We welcome more people to join this wonderful community. Thanks, everyone. Regards, Trista -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) & AGE (Incubating) mentor Twitter, @tristaZero
Re:Discuss about remove the ShardingSphere-UI project
IMO, I agree to remove this UI project. The reasons are, 1. UI project is dependent with the API of ShardingSphere, which has been totally refactoring. So I have to say currently UI project can not setup. 2. Actually UI project is immature, and we always receive many vulnerability reports. Plus, it is not easy to update and maintain UI project. 3. We have other better solution [1] to solve the similar jobs of UI project. Based on that, My +1 on removing UI project [1] https://shardingsphere.apache.org/document/current/en/features/dist-sql/ -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) IPMC Twitter, @trista86934690 On 10/1/2021 23:29，zhangli...@apache.org wrote： Hi team, The ShardingSphere-UI is not required component. In new version of ShardingSphere 5.x, there are new feature - DistSQL which can instead of the ShardingSphere-UI to help user operate ShardingSphere more friendly, just like operate the native database. How about remove ShardingSphere-UI and focus the kernel of ShardingSphere in the community? -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:[VOTE] Release Apache ShardingSphere ElasticJob 3.0.1
+1 binding, here is my check list, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] LICENSE, NOTICE files are correct. [x] All files have license headers if necessary. -- Juan Pan(Trista), Apache member, Apache ShardingSphere PMC, Apache brpc (Incubator) & Apache AGE (Incubator) mentor Twitter, @trista86934690 On 10/4/2021 21:44，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob 3.0.1 Release notes: https://github.com/apache/shardingsphere-elasticjob/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-3.0.1/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1065/org/apache/shardingsphere/elasticjob/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob/tree/3.0.1/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob/commit/b3a9b50ea374b5af16d10da8ea3b311c6d5eb16a Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob/ GPG key ID: 2DE3A2A9 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sincerely, Weijie Wu (TeslaCN) Apache ShardingSphere
[ANNOUNCE] New committer: Longtao Jiang
Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Longtao to become a committer and we are pleased to announce that he has accepted. Longtao is active in ShardingSphere community, hope see your further interactions with the community! Thanks for your contributions. Regards, Trista -- Juan Pan(Trista), Apache member, Apache ShardingSphere PMC, Apache brpc (Incubator) & Apache AGE (Incubator) mentor Twitter, @trista86934690
[ANNOUNCE] New committer: Hongsheng Zhong
Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Hongsheng to become a committer and we are pleased to announce that he has accepted. Hongsheng is active in ShardingSphere community, hope see your further interactions with the community! Thanks for your contributions. Regards, Trista -- Juan Pan(Trista), Apache member, Apache ShardingSphere PMC, Apache brpc (Incubator) & Apache AGE (Incubator) mentor Twitter, @trista86934690
回复：参加订阅
Hi, looks like you want to subscribe this list? Please refer to [1] for subscription guide. Plus, you can consider joining our slack channel [2]. Best, Trista [1] https://shardingsphere.apache.org/community/cn/contribute/subscribe/ [2] https://app.slack.com/client/T026JKU2DPF/D02AQU03W9Z -- Juan Pan(Trista), Apache member, Apache ShardingSphere PMC, Apache brpc (Incubator) & Apache AGE (Incubator) mentor Twitter, @trista86934690 在2021年08月7日 22:51，xinglj 写道： 邢立军 系统架构师 诺祺科技 联系我
Re:[DISCUSS][ElasticJob] support annotation plan of ElasticJob
Hi Sunkai,
Thanks for your proposal. We will give it a review and contact you ASAP.
Best,
Trista
--
Juan Pan(Trista), Apache member, Apache ShardingSphere PMC, Apache brpc
(Incubator) & Apache AGE (Incubator) mentor
Twitter, @trista86934690
On 08/10/2021 15:43，sk c wrote：
Hi everyone,
I prefer to discuss the annotation of ElasticJob plan.
example:
```
@ElasticScheduled(
cron = "0/5 * * * * ?",
jobName = "SimpleTestJobSecond",
shardingTotalCount = 3,
shardingItemParameters = "0=Beijing,1=Shanghai,2=Guangzhou",
jobListenerTypes = {"NOOP", "LOG"},
props = {
@ElasticJobProp(key = "print.title", value = "test title"),
@ElasticJobProp(key = "print.content", value = "test
content")
}
)
public class SimpleTestJob implements CustomJob {
@Override
public void execute(final ShardingContext shardingContext) {
}
}
```
```
@Configuration
@EnableElastic(scanBasePackages =
"org.apache.shardingsphere.elasticjob.lite.example.job.simple")
public class ElasticConfig {
}
```
we can look at it on
https://github.com/apache/shardingsphere-elasticjob/pull/1954
I am going to work it soon. Please remind me if you have a suggestion.
--
Sincerely,
SunKai Cai (skai)
Re: What is the useful of asf branch on https://github.com/apache/shardingsphere-doc
Hi, It was fixed that website has been stale for a long time even the asf-site is updated. -- Juan Pan(Trista), Apache ShardingSphere PMC Twitter, @trista86934690 On 07/27/2021 20:36，zhangli...@apache.org wrote： The asf-site branch is used by ASF INFRA. After research, the branch asf is useless, I will remove it soon. -- Sincerely, Liang Zhang (John) Apache ShardingSphere Sheng Wu 于2021年7月26日周一 下午2:04写道： It is used by ASF INFRA to host the static website files and deploy them on the environment. Sheng Wu 吴晟 Twitter, wusheng1108 zhangli...@apache.org 于2021年7月26日周一 下午1:53写道： Hi, I notice there is asf branch on https://github.com/apache/shardingsphere-doc . It seems useless, can I remove the branch? -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:[VOTE] Release Apache ShardingSphere ElasticJob UI 3.0.0
Hi +1 binding here is my checking list. [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] LICENSE, NOTICE files are correct. [x] All files have license headers if necessary. -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) IPMC Twitter, @trista86934690 On 07/15/2021 11:04，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob UI version 3.0.0 Release notes: https://github.com/apache/shardingsphere-elasticjob-ui/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-ui-3.0.0/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob-ui/tree/3.0.0/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob-ui/commit/1c1707b3aac284f957babc89023a24c8355dae2d Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob-ui/ GPG key ID: 2DE3A2A9 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive.
Re: [DISCUSS] Remove ShardingSphere SkyWalking agent plugins for legacy version from SkyWalking's master branch
+1 from me. -- Juan Pan(Trista), Apache ShardingSphere PMC Twitter, @trista86934690 On 07/11/2021 19:05，吴伟杰 wrote： Hi Consider the 3.x is a GA release, and the plugins for 4.x RC are no longer needed because there are already plugins for 4.x GA. Our primary conclusion is removing the following plugins: 1. sharding-jdbc-1.5.x-plugin 2. sharding-sphere-4.x-rc3-plugin 3. sharding-sphere-4.x-plugin (This is for RC1 and RC2) If no one objects, I will clear up the codebase next weekend. -- Sincerely, Weijie Wu (TeslaCN) Apache ShardingSphere Sheng Wu 于2021年7月11日周日 上午9:12写道： Hi Do we have a conclusion? And Weijie, could you follow this and clear up the codebase? Sheng Wu 吴晟 Twitter, wusheng1108 Juan Pan 于2021年7月1日周四 上午9:11写道： Hi, I have no clear idea on how each plugin is different, but they are actually different. Considering users' preference for different releases,My +1 to keep the 4.0 and 4.1 GA versions. -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) IPMC Twitter, @trista86934690 On 07/1/2021 07:50，Sheng Wu wrote： Hi ``` 3. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.0.x-plugin 4. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.1.0-plugin 5. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-RC3-plugin 6. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-plugin ``` What is the difference between 4.x and 4.0/4.1 plugins? Could some of them be removed? And RC3 should be removed as you have plugins for GA releases already. Sheng Wu 吴晟 Twitter, wusheng1108 吴伟杰 于2021年6月30日周三 下午11:19写道： Hi All, SkyWalking's master branch hosts 7 agent plugins for different versions of ShardingSphere. They think the plugins are too many. ( https://github.com/apache/skywalking/pull/7171#issuecomment-868353013) Here is the list: 1. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-jdbc-1.5.x-plugin 2. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-3.x-plugin 3. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.0.x-plugin 4. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.1.0-plugin 5. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-RC3-plugin 6. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-plugin 7. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/shardingsphere-5.0.0-beta-plugin Since the sharding-jdbc-1.5.x and the sharding-sphere-3.x have no longer been maintained, I propose to remove sharding-jdbc-1.5.x-plugin < https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-jdbc-1.5.x-plugin and sharding-sphere-3.x-plugin < https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-3.x-plugin from SkyWalking's master branch to reduce maintenance costs. -- Sincerely, Weijie Wu (TeslaCN) Apache ShardingSphere
Re: [VOTE] Release Apache ShardingSphere ElasticJob-3.0.0
Thanks Sheng, helping this vote move forward. ;-) -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) IPMC Twitter, @trista86934690 On 07/5/2021 16:46，Sheng Wu wrote： +1 binding 1. Download source correct 2. sha512 exist 3. asc checked 4. version correct. Sheng Wu 吴晟 Twitter, wusheng1108 吴伟杰 于2021年6月26日周六 下午8:45写道： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob-3.0.0 Release notes: https://github.com/apache/shardingsphere-elasticjob/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-3.0.0/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1063/org/apache/shardingsphere/elasticjob/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob/tree/3.0.0/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob/commit/1b2b15d7bf653b1fd6d455d940eabb13793347bb Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob/ GPG key ID: 2DE3A2A9 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sincerely, Weijie Wu (TeslaCN) Apache ShardingSphere
回复：自定义复合分片算法的binding-tables配置失效
Hi,
English communication is required.
How to create binding tables?
- To configure the same sharding table rule for these tables
- Add bind table configuration item for them.
You will get more from examples [1].
[1] https://github.com/apache/shardingsphere/tree/master/examples
--
Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) IPMC
Twitter, @trista86934690
在2021年07月4日 00:34，xiaomingrui 写道：
你好
请问下，使用自定义分片算法的时候，怎样可以使binding-tables生效？期望order_info_ext和order_info的连表查询的分片保持一致，但是现在发现不一致。
配置如下：
order_info_ext:
# 真实表
actualDataNodes: order-s-ms.order_info_ext_s_$->{0..25}
# 分库策略
databaseStrategy:
none:
# 分表策略
tableStrategy:
complex:
# 分片字段
shardingColumns: order_id,create_time
# 自定义分片算法
algorithm-class-name:
sharding.algorithm.order.config.OrderShardingAlgorithm
查询语句如下：
2021-03-25 15:38:15.117 [http-nio-12000-exec-1] INFO ShardingSphere-SQL
- Actual SQL: gac-order-s-statistics ::: SELECT count(*) FROM `order_info_s_22`
t
LEFT JOIN order_info_ext_s_10 t2 ON t.order_id = t2.order_id
WHERE
t.user_id
=
?
AND
t.order_id
>
? ::: [123, 0]
2021-03-25 15:38:15.117 [http-nio-12000-exec-1] INFO ShardingSphere-SQL
- Actual SQL: gac-order-s-statistics ::: SELECT count(*) FROM `order_info_s_22`
t
LEFT JOIN order_info_ext_s_10 t2 ON t.order_id = t2.order_id
WHERE
t.user_id
=
?
AND
t.create_time
>
? ::: [123, 1970-11-05 15:43:12]
Re: [DISCUSS] Remove ShardingSphere SkyWalking agent plugins for legacy version from SkyWalking's master branch
Hi, I have no clear idea on how each plugin is different, but they are actually different. Considering users' preference for different releases,My +1 to keep the 4.0 and 4.1 GA versions. -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) IPMC Twitter, @trista86934690 On 07/1/2021 07:50，Sheng Wu wrote： Hi ``` 3. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.0.x-plugin 4. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.1.0-plugin 5. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-RC3-plugin 6. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-plugin ``` What is the difference between 4.x and 4.0/4.1 plugins? Could some of them be removed? And RC3 should be removed as you have plugins for GA releases already. Sheng Wu 吴晟 Twitter, wusheng1108 吴伟杰 于2021年6月30日周三 下午11:19写道： Hi All, SkyWalking's master branch hosts 7 agent plugins for different versions of ShardingSphere. They think the plugins are too many. ( https://github.com/apache/skywalking/pull/7171#issuecomment-868353013) Here is the list: 1. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-jdbc-1.5.x-plugin 2. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-3.x-plugin 3. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.0.x-plugin 4. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.1.0-plugin 5. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-RC3-plugin 6. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-4.x-plugin 7. https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/shardingsphere-5.0.0-beta-plugin Since the sharding-jdbc-1.5.x and the sharding-sphere-3.x have no longer been maintained, I propose to remove sharding-jdbc-1.5.x-plugin < https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-jdbc-1.5.x-plugin and sharding-sphere-3.x-plugin < https://github.com/apache/skywalking/tree/master/apm-sniffer/apm-sdk-plugin/sharding-sphere-3.x-plugin from SkyWalking's master branch to reduce maintenance costs. -- Sincerely, Weijie Wu (TeslaCN) Apache ShardingSphere
Re:[VOTE] Release Apache ShardingSphere ElasticJob-3.0.0
Hi binding +1, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] Source code distributions have correct names matching the current release. [x] LICENSE and NOTICE files are correct for each ShardingSphere repo. [x] All files have license headers if necessary. [x] No compiled archives bundled in source archive. -- Juan Pan(Trista), Apache ShardingSphere PMC, Apache brpc (Incubating) IPMC Twitter, @trista86934690 On 06/26/2021 20:44，吴伟杰 wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob-3.0.0 Release notes: https://github.com/apache/shardingsphere-elasticjob/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-3.0.0/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1063/org/apache/shardingsphere/elasticjob/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob/tree/3.0.0/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob/commit/1b2b15d7bf653b1fd6d455d940eabb13793347bb Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob/ GPG key ID: 2DE3A2A9 The vote will be open for at least 72 hours or until the necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others are +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sincerely, Weijie Wu (TeslaCN) Apache ShardingSphere
[Event] Apache ShardingSphere will participate OSD2021 program as the partner project
Hi community, We are honored to accept the invitation from `AnitaB.org` to attend OpenSourceDayGHC2021[1]. Open Source Day (OSD) is an all-day hackathon (including workshops), in which participants of all skill levels learn about Open Source while contributing to projects designed to solve real-world problems (**Appreciated, IMO**). In order to get involved in this great event, Apache ShardingSphere community is about to prepare some issues or tasks for everyone interested in this program and our community! Please give a look at [2] for more details. Thanks for your interest in this community and this event. **Please have our big welcome!** [3] will point you how to join this wonderful event. ;-) [1] https://ghc.anitab.org/programs-and-awards/open-source-day/ [2] https://github.com/apache/shardingsphere/issues/10887 [3] https://anitab-org.github.io/open-source-day/open-source-day-2021-summer-contribution/ Warm regards, Trista -- Juan Pan(Trista), Apache ShardingSphere PMC Twitter, @trista86934690
[ANNOUNCE] Apache ShardingSphere 5.0.0-beta available
Hi all, Apache ShardingSphere Team is glad to announce the new release of Apache ShardingSphere 5.0.0-beta. ShardingSphere is an open-source ecosystem consisted of a set of distributed database solutions, including 2 independent products, ShardingSphere-JDBC & ShardingSphere-Proxy. They both provide functions of data scale out, distributed transaction and distributed governance, applicable in a variety of situations such as Java isomorphism and heterogeneous language. Apache ShardingSphere aiming at reasonably making full use of the computation and storage capacity of existed database in distributed system, rather than a totally new database. As the cornerstone of enterprises, relational database still takes a huge market share. Therefore, we prefer to focus on its increment instead of a total overturn. Download Links: https://shardingsphere.apache.org/document/current/en/downloads/ Release Notes: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md Website: https://shardingsphere.apache.org/ ShardingSphere Resources: - Issue: https://github.com/apache/shardingsphere/issues/ - Mailing list: dev@shardingsphere.apache.org - Documents: https://shardingsphere.apache.org/document/current/ - Apache ShardingSphere Team ------ Juan Pan(Trista), Apache ShardingSphere PMC Twitter, @trista86934690
[RESULT][VOTE] Release Apache ShardingSphere 5.0.0-beta
Hi community, We’ve received 3 +1 binding votes, +4 non-binding, and +0 non-binding vote: +1 binding, Yonglun Zhang +1 binding, Liang Zhang +1 binding, KimmKing +1 non-binding, sei.jun +1 non-binding, Weijie Wu +1 non-binding, Raigor Jiang +1 non-binding, guocheng Tang +0 non-binding, guangyuan Wang Thank you everyone for taking the time to review the release and help us. I will process to publish the release and send ANNOUNCE. Note, the issues about NOTICE and LICENSE have been fixed on [1][2]. [1] https://github.com/apache/shardingsphere/pull/10831 [2] https://github.com/apache/shardingsphere/pull/10835 -- Juan Pan(Trista), Apache ShardingSphere PMC Twitter, @trista86934690
Re: [VOTE] Release Apache ShardingSphere 5.0.0-beta
Hi guangyuan,
Thanks for your feedback.
I just uploaded the new `apache-shardingsphere-5.0.0-beta-src.zip`, and its
`asc` and `sha512` to svn. So please recheck the latest files.
All the information of this vote is unchanged, please go ahead, community.
Warm regards,
Trista
--
Juan Pan(Trista), Apache ShardingSphere PMC
Twitter, @trista86934690
On 06/14/2021 11:16，guangyuan wang wrote：
After run command "diff -r apache-shardingsphere-${RELEASE.VERSION}-src-release
shardingsphere-${RELEASE.VERSION}"
The result is below, is this acceptable?
唐国城 于2021年6月13日周日 下午2:45写道：
+1non-binding.
--原始邮件--
发件人:
"dev"
https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md
The release candidates:
https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-beta/
Maven 2 staging repository:
https://repository.apache.org/content/repositories/orgapacheshardingsphere-1061/org/apache/shardingsphere/
Git tag for the release:
https://github.com/apache/shardingsphere/tree/5.0.0-beta/
Release Commit ID:
https://github.com/apache/shardingsphere/commit/9bb3dfd975c88344786e86c2a712fec218085bbc
Keys to verify the Release Candidate:
https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS
Look at here for how to verify this release candidate:
https://shardingsphere.apache.org/community/en/contribute/release/
GPG user ID:
panjuan
The vote will be open for at least 72 hours or until necessary number of votes
are reached.
Please vote accordingly:
[ ] +1 approve
[ ] +0 no opinion
[ ] -1 disapprove with the reason
PMC vote is +1 binding, all others is +1 non-binding.
Checklist for reference:
[ ] Download links are valid.
[ ] Checksums and PGP signatures are valid.
[ ] Source code distributions have correct names matching the current release.
[ ] LICENSE and NOTICE files are correct for each ShardingSphere repo.
[ ] All files have license headers if necessary.
[ ] No compiled archives bundled in source archive.
----------
Juan Pan(Trista), Apache ShardingSphere PMC
Twitter, @trista86934690
[VOTE] Release Apache ShardingSphere 5.0.0-beta
Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.0.0-beta Release notes: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-beta/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1061/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.0.0-beta/ Release Commit ID: https://github.com/apache/shardingsphere/commit/9bb3dfd975c88344786e86c2a712fec218085bbc Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG user ID: panjuan The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Juan Pan(Trista), Apache ShardingSphere PMC Twitter, @trista86934690
[DISCUSS] New release 5.0.0-beta
Hi community, This email is a starting signal for our next release, i.e., 5.0.0-beta. As you know, we have been preparing for this release for over half of a year. But I assume it is worth waiting for this wonderful release. So please give a look at [1] to learn more about its release note. Hope the features you expect are on this list! If you are still working on some issues which are supposed to catch this release, please contact me ASAP. What's more, we welcome any suggestions and feedback from you. Warm regards, Trista [1] https://u01f1kqxrl.feishu.cn/sheets/shtcnA9X7ChUhpb2N4AASwgExKf -- Juan Pan(Trista), Apache ShardingSphere PMC Twitter, @trista86934690
回复：shardingsphere遇到的线上问题-高并发情况下出错
Hi, Could you set `sql-show` so that we can get more detailed info? BTW, It is still suggested to raise an issue on our github page to track your problem. Cheers, Trista --- Email：panj...@apache.org Juan Pan(Trista) Apache ShardingSphere 在2021年04月21日 21:24，zouhan...@bilibili.com.INVALID 写道： 问题:在高并发情况下发现数据库查询连续出错,捞取mysql_dump,发现shardingsphere指向的表发生错误,请问是否是shardingsphere的上下文出现问题? Select * from cp_account_relation_7 where source = 6 业务配置: 使用的版本信息:
Re:hello,world!
Hi welcome. :) Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 04/9/2021 17:06，陈攀<787110...@qq.com> wrote： Hello everyone ! I am a novice and I am observing and learning.
Re:subscribe dev
Hi, I guess this one[1] will help you subscribe this mail list. [1] https://shardingsphere.apache.org/community/cn/contribute/subscribe/ Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 04/9/2021 14:25，sei.jun wrote： subscribe
??????#ShardingSphere#??????????????????????????????????
Hi, Suppose you give a scan at [1], generally you can have the basic answer. BTW, English communication is needed here. Cheers, Trista [1] http://shardingsphere.apache.org/index_zh.html Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org ??2021??03??23?? 09:15 ?? hi
Re: [GSoC] Proofread the DDL/TCL SQL definitions for ShardingSphere Parser
Hi Liangda, I can see your efforts from this analysis, nice. :) Here are some tips for your questions, 1. Since the proofread work of MySQL definitions has finished, its SQL classification is a great reference for our Oracle work. It is more precise to classify each SQL by Oracle doc though, in order to lessen the refactoring work and keep the classification in line among different databases, it is suggested to refer to MySQL file to sort out Oracle SQLs. 2. In fact, there are definitely some specific SQLs from Oracle. A preferable way to handle them is to keep aligned with the Oracle document. 3. Until now, we have been using Release 19 of Oracle for proofreading, so please take your task by this release. Cheers, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 03/17/2021 08:02，Liangda Wang wrote： Hi Trista, thanks a lot for your answer! It’s much clear now :) Based on the guidline I‘ve tried to map the Oracle DDL/TCL SQL to its targeting file in following table. And I have still questions regarding it: I find it a little bit difficult to distingish between DCL and DDL. Based on MySQL standard I could find ANALYZE defined as DCL (more specific: Table Maintenance Statement), and RENAME as DDL (linked below). Others are not defined in MySQL and I think they’re more like DDL as defined in Oracle originally. Could you please have a look whether this would be the correct mapping? For example, I first thought ALTER SYNONYM and ALTER SESSION will be DCL like ALTER ROLE, but after this mapping exercise I find only ALTER/CREATE… related to Account Management are defined DCL. So the others like ALTER SYNONYM and ALTER SESSION should be still DDL, is it right? Sorry for this silly question, just want to make sure I’m writing in the correct file For AUDIT and NOAUDIT there’re two versions: traditional (used in releases earlier than Oracle Database 12c) and unified (beginning with Oracle Database 12c). Are we going to use only unified version or do we need both? | DDL in Oracle (except ALTER, DROP, CREATE, TRUNCATE) | Targeting File regarding to Definition and MySQL standard | Estimated effort: 1(low)-5(high) | | ANALYZE | DCL | 5 | | ASSOCIATE STATISITICS | DDL | 5 | | DISASSOCIATE STATISITICS | DDL | 3 | | AUDIT (Traditional Auditing) | DDL | 4 | | AUDIT (Unified Auditing) | DDL | 3 | | NOAUDIT (Traditional Auditing) | DDL | 3 | | NOAUDIT (Unified Auditing) | DDL | 2 | | COMMENT | DDL | 4 | | FLASHBACK DATABASE | DDL | 3 | | FLASHBACK TABLE | DDL | 4 | | PURGE | DDL | 2 | | RENAME | DDL | 1 | | REVOKE | Already defined in DCL | - | | GRANT | Already defined in DCL | - | | TCL in Oracle | Targeting File regarding to MySQL | Estimated effort: 1(low)-5(high) | | SET TRANSACTION | TCL | 2 | | SET CONSTRAINT(S) | TCL | 1 | | COMMIT | Already defined in TCL | - | | ROLLBACK | Already defined in TCL | - | | SAVEPOINT | Already defined in TCL | - | Thanks and best regards Liangda From: Juan Pan Sent: Sunday, March 14, 2021 11:59 AM To: Liangda Wang Subject: Re:[GSoC] Proofread the DDL/TCL SQL definitions for ShardingSphere Parser Hi Liangda, Since the SQL classification mainly refers to MySQL, that will confuse you when considering Oracle's SQL. I will try to answer your questions. Firstly, your summary about the DDL/TCL of Oracle is precisely the content of GSoC. Secondly, what're the grounds for SQL classification? Here are some principles FYR, 1. MySQL's standard 2. The idea of each definition itself, e.g., TCL means Transaction Control Language. Therefore all the SQLs for transaction control are supposed to be TCL. But don't worry. You can apply for GSoC using the SQL definition of Oracle and do this task in practice referring to `shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql` Cheers, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 03/13/2021 07:31，Liangda Wang wrote： Hi Trista, this is Liangda from Github/Jira I would like to connect with you to learn more about the scope of this GSoC task with Apache Shardingsphere, as I’ll start to prepare the proposal in the following weeks. In COMDEV-399 you’ve listed: This issue is to proofread the following definitions, All the DDL SQL definitions for Oracle except for ALTER, DROP, CREATE and TRUNCATE. All the TCL (Transaction Control Language) SQL definitions for Oracle I took a look in the Oracle Types of SQL Statement document and summerize the following
Re:GSoC participation
Hi Ilias Kyrannas, Welcome. :-) Here[1] is a similar example for this GSoC task and [2] is for our contributor. Also, @Liang Zhang, I guess we need a few preliminary issues to help students quickly come into this community. [1] https://github.com/apache/shardingsphere/pull/9600/files [2] https://shardingsphere.apache.org/community/en/contribute/contributor/ Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 03/16/2021 21:09，Ηλίας Κυράννας wrote： Hello all, I am currently doing my PhD and I would like to participate in the GSoC this year. I have around three years of professional experience with the Spring framework and I would like to learn more about the "Apache ShardingSphere: Add unit test for example". I would like to ask if there is a preferable way to show our work for example by contributing to an issue. If so is there a recommendation for the parts that the team thinks are most critical for refactoring? Best regards, Ilias Kyrannas
Re: [Community Application] Apache ShardingSphere community applies for Summer 2021
Hi Committee, As we talked before, a post is expected to introduce ShardingSphere community on the Wechat public account of Summer 2021. Here[1] is a drat. Could you give it a look? If there is any issue, please be free to contact us. Regards, Trista [1] https://shimo.im/docs/rwqdkhrt9tx93YRQ Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 03/3/2021 16:41，Juan Pan wrote： Hi Committee, This email is to inform you of the link address [1] of the `Summer 2021` page of ShardingSphere community. I can see ShardignSphere community is on the community list [2], very appreciated your kind work. According to [3], the next step for the cooperative community is to launch the `Summer 2021` page for candidate students and inform the committee about that link address. That's why you receive this email. We will update that page with the tasks from the community later. Please give it a review. If there is anything missed, please be free to contact me. Kindly regards, Trista [1] https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/Open+Source+Promotion+Plan+-+Summer+2021 [2] https://summer.iscas.ac.cn [3] https://summer.iscas.ac.cn/help/en/community/ Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 02/8/2021 12:40，开源之夏 wrote： Dear Trista， Thanks for your mail and participation. Please kindly complete “社区信息模板” as attached. If community information is requested to be shown on Summer2021 website both in Chinese and English, please also complete Template for Community Application. For more information please click : 中文：https://summer.iscas.ac.cn/help/ ENG: https://summer.iscas.ac.cn/help/en/ Welcome to subscribe Public Mailing List: Discussion mailing list: summer-o...@googlegroups.com · For general discussion and feedback about Summer 2021. · Anyone can send mail to this list, subscribe this and view mail archive. · Visit mail archive: https://groups.google.com/g/summer-ospp Also attached General Milestone of Summer2021 for your reference. Many thanks. Summer 2021 of Open Source Promotion Plan Committee 尊敬的潘娟老师， 您好！感谢您对 开源软件供应链点亮计划-暑期2021 的热情支持与参与，社区信息劳烦补充至附件1：社区信息模板 ，如贵社区想于活动官网同时展示社区中英双语信息，请同时填写附件2：Template for Community Application，一并回复至此邮件，谢谢！ 更多活动信息请点击官网帮助链接： 中文：https://summer.iscas.ac.cn/help/ ENG: https://summer.iscas.ac.cn/help/en/ 欢迎订阅活动邮件列表： 通用邮件列表：summer-o...@googlegroups.com 用于一般性讨论和问题反馈，任何人都可发、可订阅、可查看。 进入讨论组：https://groups.google.com/g/summer-ospp 本届活动里程碑见 附件3 活动里程碑一览 开源之夏，点亮暑期！ 开源软件供应链点亮计划-暑期2021 组委会 发件人:hannk...@163.com 代表 Juan Pan 发送时间: 2021年2月4日 14:54 收件人: summer 抄送: ShardingSphere DEV 主题: [Community Application] Apache ShardingSphere community applies for Summer 2021 Hi organizer and ShardingSphere community, We would like to join in Summer 2021 of Open Source Promotion Plan. This email is a formal application for this wonderful activity. ShardingSphere has an active and diverse open-source community[1] and is willing to welcome newcomers and students to join. Considering the great collaboration in Summer 2020, we are pleased to participate in Summer 2021 to provide kind mentoring. If there is any process needs follow later, please make us updated. Regards, Trista [1] https://github.com/apache/shardingsphere ---- Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
Re: [Community Application] Apache ShardingSphere community applies for Summer 2021
Hi Committee, This email is to inform you of the link address [1] of the `Summer 2021` page of ShardingSphere community. I can see ShardignSphere community is on the community list [2], very appreciated your kind work. According to [3], the next step for the cooperative community is to launch the `Summer 2021` page for candidate students and inform the committee about that link address. That's why you receive this email. We will update that page with the tasks from the community later. Please give it a review. If there is anything missed, please be free to contact me. Kindly regards, Trista [1] https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/Open+Source+Promotion+Plan+-+Summer+2021 [2] https://summer.iscas.ac.cn [3] https://summer.iscas.ac.cn/help/en/community/ Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 02/8/2021 12:40，开源之夏 wrote： Dear Trista， Thanks for your mail and participation. Please kindly complete “社区信息模板” as attached. If community information is requested to be shown on Summer2021 website both in Chinese and English, please also complete Template for Community Application. For more information please click : 中文：https://summer.iscas.ac.cn/help/ ENG: https://summer.iscas.ac.cn/help/en/ Welcome to subscribe Public Mailing List: Discussion mailing list: summer-o...@googlegroups.com · For general discussion and feedback about Summer 2021. · Anyone can send mail to this list, subscribe this and view mail archive. · Visit mail archive: https://groups.google.com/g/summer-ospp Also attached General Milestone of Summer2021 for your reference. Many thanks. Summer 2021 of Open Source Promotion Plan Committee 尊敬的潘娟老师， 您好！感谢您对 开源软件供应链点亮计划-暑期2021 的热情支持与参与，社区信息劳烦补充至附件1：社区信息模板 ，如贵社区想于活动官网同时展示社区中英双语信息，请同时填写附件2：Template for Community Application，一并回复至此邮件，谢谢！ 更多活动信息请点击官网帮助链接： 中文：https://summer.iscas.ac.cn/help/ ENG: https://summer.iscas.ac.cn/help/en/ 欢迎订阅活动邮件列表： 通用邮件列表：summer-o...@googlegroups.com 用于一般性讨论和问题反馈，任何人都可发、可订阅、可查看。 进入讨论组：https://groups.google.com/g/summer-ospp 本届活动里程碑见 附件3 活动里程碑一览 开源之夏，点亮暑期！ 开源软件供应链点亮计划-暑期2021 组委会 发件人:hannk...@163.com 代表 Juan Pan 发送时间: 2021年2月4日 14:54 收件人: summer 抄送: ShardingSphere DEV 主题: [Community Application] Apache ShardingSphere community applies for Summer 2021 Hi organizer and ShardingSphere community, We would like to join in Summer 2021 of Open Source Promotion Plan. This email is a formal application for this wonderful activity. ShardingSphere has an active and diverse open-source community[1] and is willing to welcome newcomers and students to join. Considering the great collaboration in Summer 2020, we are pleased to participate in Summer 2021 to provide kind mentoring. If there is any process needs follow later, please make us updated. Regards, Trista [1] https://github.com/apache/shardingsphere Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[Enhancement] Authentication feature of ShardingProxy
Hi everyone, This is an update for this enhancement feature. As you know, we plan to build the authentication system to help users facilitate access control of ShardingProxy. This is an extensive work, but it is scheduled to publish with the next release. ### Introduction This feature is the same as the authentication of MySQL or PostgreSQL. ShardingProxy has to do access control when users login in. ### Three key points need to clarify - This issue is an enhancement feature for the current `Authentication` module - All users configured in `server.yaml` of `ShardingProxy` still work and are seen as system users. - We will leverage the access-control power of different Databases ### Tasks - [x] ShardingProxy supports `create user` SQL, which will be pushed down to databases - [x] ShardingProxy supports `grant` SQL, which will be pushed down to databases - [x] ShardingProxy supports `revoke` SQL, which will be pushed down to databases - [x] Get the `IP` or `hostname` once users login in - [ ] Get the `user name`, `password` once users login in - [ ] Get the user privilege information from databases once users login in - [ ] Transform the privilege information into the cached `auth` object - [ ] Compare the authentication from the user-login and database You can learn more from [1]. Cheers, Trista [1] https://github.com/apache/shardingsphere/issues/8966 Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[New Feature] Support to show execution process for running SQLs by RQL
Hi, community, This is a new plan to support showing the execution process for running SQLs, especially for DML/DDL always needing much time to run. With my thinking, there are three main tasks for this new feature. ### Tasks Generate Job IDs - Add configuration item to allow users to set instance ID for each proxy - Generate distributed IDs by snowflake for this job's trunk and branches - Pass these IDs through the whole execution Report execution process from one Proxy - `ExecutorEngine` reports the context (IDs, beginTime, etc.) of each query to `governance` - Each branch job reports its status and ID to `governance` once it finishes in `ExecutorCallback` - `Governance` handles these requests synchronously Query execution process from other Proxies - It is triggered by `show processlist` - Get the execution status from all the jobs from `governance` - Make up the result based on `show processlist`' original result with the collected data If you’re interested in this one, please watch [1]. Regards, Trista [1] https://github.com/apache/shardingsphere/issues/9568 --- Email：panj...@apache.org Juan Pan(Trista) Apache ShardingSphere
Re: [Community Application] Apache ShardingSphere community applies for Summer 2021
Hi, Thanks for your guidance. The necessary files are attached below. If there is any issue, please contact us. Regards, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 02/7/2021 10:51，开源之夏 wrote： Dear Trista， Thanks for your mail and participation. Please kindly complete “社区信息模板” as attached. If community information is requested to be shown on Summer2021 website both in Chinese and English, please also complete Template for Community Application. For more information please click : 中文：https://summer.iscas.ac.cn/help/ ENG: https://summer.iscas.ac.cn/help/en/ Welcome to subscribe Public Mailing List: Discussion mailing list: summer-o...@googlegroups.com · For general discussion and feedback about Summer 2021. · Anyone can send mail to this list, subscribe this and view mail archive. · Visit mail archive: https://groups.google.com/g/summer-ospp Also attached General Milestone of Summer2021 for your reference. Many thanks. Summer 2021 of Open Source Promotion Plan Committee 尊敬的潘娟老师， 您好！感谢您对 开源软件供应链点亮计划-暑期2021 的热情支持与参与，社区信息劳烦补充至附件1：社区信息模板 ，如贵社区想于活动官网同时展示社区中英双语信息，请同时填写附件2：Template for Community Application，一并回复至此邮件，谢谢！ 更多活动信息请点击官网帮助链接： 中文：https://summer.iscas.ac.cn/help/ ENG: https://summer.iscas.ac.cn/help/en/ 欢迎订阅活动邮件列表： 通用邮件列表：summer-o...@googlegroups.com 用于一般性讨论和问题反馈，任何人都可发、可订阅、可查看。 进入讨论组：https://groups.google.com/g/summer-ospp 本届活动里程碑见 附件3 活动里程碑一览 开源之夏，点亮暑期！ 开源软件供应链点亮计划-暑期2021 组委会 发件人:hannk...@163.com 代表 Juan Pan 发送时间: 2021年2月4日 14:54 收件人: summer 抄送: ShardingSphere DEV 主题: [Community Application] Apache ShardingSphere community applies for Summer 2021 Hi organizer and ShardingSphere community, We would like to join in Summer 2021 of Open Source Promotion Plan. This email is a formal application for this wonderful activity. ShardingSphere has an active and diverse open-source community[1] and is willing to welcome newcomers and students to join. Considering the great collaboration in Summer 2020, we are pleased to participate in Summer 2021 to provide kind mentoring. If there is any process needs follow later, please make us updated. Regards, Trista [1] https://github.com/apache/shardingsphere Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[ANNOUNCE] Apache ShardingSphere UI 5.0.0-alpha available
Hi all, Apache ShardingSphere Team is glad to announce the new release of Apache ShardingSphere UI 5.0.0-alpha. ShardingSphere is an open-source ecosystem consisted of a set of distributed database middleware solutions, including 2 independent products, ShardingSphere-JDBC & ShardingSphere-Proxy. They both provide functions of data sharding, distributed transaction and database governance, applicable in a variety of situations such as Java isomorphism, heterogeneous language. Aiming at reasonably making full use of the computation and storage capacity of the database in a distributed system, ShardingSphere defines itself as a middleware, rather than a totally new type of database. As the cornerstone of many enterprises, relational database still takes a huge market share. Therefore, at the current stage, we prefer to focus on its increment instead of a total overturn. Download Links: https://shardingsphere.apache.org/document/current/en/downloads/ Release Notes: https://github.com/apache/shardingsphere-ui/blob/master/RELEASE-NOTES.md Website: https://shardingsphere.apache.org/ ShardingSphere Resources: - Issue: https://github.com/apache/shardingsphere-ui/issues/ - Mailing list: dev@shardingsphere.apache.org - Documents: https://shardingsphere.apache.org/document/current/ - Apache ShardingSphere Team Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[New feature] Federated SQL query and Query optimization are going to sail out
Hi community, As you know, ShardingSphere has made a lot of efforts on SQL parser and provided a great independent SQL parser to help users parse SQL. Based on this substantial work, we plan to do query optimization to optimize the input SQLs from users and produce an optimized SQL query plan to improve query efficiency. Plus, the federated SQL query feature (Like join query from different instances) is another essential highlight for our next release. : ) We will leverage Apache Calcite, an excellent framework to implement two of the features. Actually, there are plenty of works to do on this issue. We are in the investigation phase now and will seek contributors for this issue later. If you are interested in this one, please give [1] a watch. [1] https://github.com/apache/shardingsphere/issues/8284 Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[VOTE] Release Apache ShardingSphere UI 5.0.0-alpha [Round 2]
Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere UI version 5.0.0-alpha Release notes: https://github.com/apache/shardingsphere-ui/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/shardingsphere-ui-5.0.0-alpha/ Git tag for the release: https://github.com/apache/shardingsphere-ui/tree/5.0.0-alpha/ Release Commit ID: https://github.com/apache/shardingsphere-ui/commit/4d90dbaff9d8f3d334c8104ab289bea6b33fdb9b Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release_ui/ GPG user ID: panjuan The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[ANNOUNCE] Apache ShardingSphere 5.0.0-alpha available
Hi all, Apache ShardingSphere Team is glad to announce the new release of Apache ShardingSphere 5.0.0-alpha. ShardingSphere is an open-source ecosystem consisted of a set of distributed database middleware solutions, including 2 independent products, ShardingSphere-JDBC & ShardingSphere-Proxy. They both provide functions of data sharding, distributed transaction and database governance, applicable in a variety of situations such as Java isomorphism, heterogeneous language. Aiming at reasonably making full use of the computation and storage capacity of the database in a distributed system, ShardingSphere defines itself as a middleware, rather than a totally new type of database. As the cornerstone of many enterprises, relational database still takes a huge market share. Therefore, at the current stage, we prefer to focus on its increment instead of a total overturn. Download Links: https://shardingsphere.apache.org/document/current/en/downloads/ Release Notes: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md Website: https://shardingsphere.apache.org/ ShardingSphere Resources: - Issue: https://github.com/apache/shardingsphere/issues/ - Mailing list: dev@shardingsphere.apache.org - Documents: https://shardingsphere.apache.org/document/current/ - Apache ShardingSphere Team Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
Re: [VOTE] Release Apache ShardingSphere 5.0.0-alpha
Hi, Thank for this issue. +1 for this release. Plus, best wishes for our next one. :) Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/9/2020 13:23，zhangli...@apache.org wrote： Some licenses are still missing because of we upgrade new version of Guava. The new dependencies are all apache licenses, so I suggest we can do release now. I create an issue[1] to record the problem, we can fix it before next release. [1] https://github.com/apache/shardingsphere/issues/8085 -- Sincerely, Liang Zhang (John) Apache ShardingSphere 蒋晓峰 于2020年11月9日周一 上午10:02写道： +1 non-binding The following checklist has been verified. [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] Source code distributions have correct names matching the current release. [x] LICENSE and NOTICE files are correct for each ShardingSphere repo. [x] All files have license headers if necessary. [x] No compiled archives bundled in source archive. Nicholas Jiang Apache ShardingSphere On Tue, Nov 3, 2020 at 12:29 PM Juan Pan wrote: Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.0.0-alpha. Release notes: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-alpha/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1058/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.0.0-alpha Release Commit ID: https://github.com/apache/shardingsphere/commit/5dc690c2227571e83beada277dbb2dfb43c29427 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG user ID: panjuan The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[RESULT][VOTE] Release Apache ShardingSphere 5.0.0-alpha
Hi community, We’ve received 3 +1 binding votes and 3 +1 non-binding vote: +1 binding, Yonglun Zhang +1 binding, Jun Zhao +1 binding, KimmKing +1 non-binding, Zonglei Dong +1 non-binding, Zhengqiang Duan +1 non-binding, Xiaofeng Jiang Thank you everyone for taking the time to review the release and help us. I will process to publish the release and send ANNOUNCE. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
Re:Draft of ASF Board Report 2020 Nov for Apache ShardingSphere
LGTM. BTW do you think the sharings or talkings in some of the conferences like Apache@HOME should be presented to the board? Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 11/5/2020 17:26，zhangli...@apache.org wrote： Hi all, There is the draft of ASF Board Report of Apache ShardingSphere for this month. Please advice me if I missing something. -- ## Description: The mission of Apache ShardingSphere is the creation and maintenance of software related to a database clustering system providing data sharding, distributed transactions, and distributed database management ## Issues: None. ## Membership Data: Apache ShardingSphere was founded 2020-04-15 (7 months ago) There are currently 30 committers and 15 PMC members in this project. The Committer-to-PMC ratio is 2:1. Community changes, past quarter: - No new PMC members. Last addition was Kimm King on 2020-06-26. - Zhengqiang Duan was added as committer on 2020-09-24 - Guo Jiwei was added as committer on 2020-08-18 ## Project Activity: Software development activity: - We are releasing new milestone version 5.0.0-alpha of ShardingSphere. - We have released new version 3.0.0-beta of ShardingSphere-ElasticJob and ShardingSphere-ElasticJob-UI. - 2 committers joined us on this quarter. Meetups and Conferences: - Two PMC members attended OpenSource Conference 2020, giving two talks on Apache ShardingSphere. ## Community Health: Overall community health is good. The statistics is trending to stable. Contributors perter use GitHub issues than mailing list to discuss. -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:[VOTE] Release Apache ShardingSphere ElasticJob UI 3.0.0-beta
+1 binding My checking list, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] Source code distributions have correct names matching the current release. [x] LICENSE and NOTICE files are correct for each ShardingSphere repo. [x] All files have license headers if necessary. [x] No compiled archives bundled in source archive. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 10/26/2020 13:23，zhangli...@apache.org wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob UI version 3.0.0-beta Release notes: https://github.com/apache/shardingsphere-elasticjob-ui/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-ui-3.0.0-beta/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob-ui/tree/3.0.0-beta/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob-ui/commit/e515054bbb165667fd34fda528f7bce15e94a23b Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob-ui/ GPG user ID: zhangliang The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:[VOTE] Release Apache ShardingSphere ElasticJob-3.0.0-beta [Round 4]
+1 binding My checking list, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] Source code distributions have correct names matching the current release. [x] LICENSE and NOTICE files are correct for each ShardingSphere repo. [x] No compiled archives bundled in source archive. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 10/31/2020 22:57，zhangli...@apache.org wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob-3.0.0-beta Release notes: https://github.com/apache/shardingsphere-elasticjob/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-3.0.0-beta/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1056/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob/tree/3.0.0-beta/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob/commit/a842f4c86b38b2c3fa8ca611fb0724e5a47a36c8 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob/ GPG user ID: zhangliang The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sincerely, Liang Zhang (John) Apache ShardingSphere
[VOTE] Release Apache ShardingSphere 5.0.0-alpha
Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere version 5.0.0-alpha. Release notes: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-alpha/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1058/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere/tree/5.0.0-alpha Release Commit ID: https://github.com/apache/shardingsphere/commit/5dc690c2227571e83beada277dbb2dfb43c29427 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release/ GPG user ID: panjuan The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
Re:[New feature] New SQLASTParserEngine is pubic for user to parse your SQLs soon
Hi community, A quick survey about the API of SQL parser engine was given yesterday. Thanks for much feedback from the community, which gave us a better idea to support this feature. At last, we plan to adopt that most-expected way to improve the function and re-prepare the incoming 5.0.0-alpha release. I will finish this task ASAP. Please wait for my good news. BTW, if you want to learn more, please look at [1] [1] https://github.com/apache/shardingsphere/issues/7869 Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 10/21/2020 19:37，Juan Pan wrote： Hi community, I am glad to announce that ShardingSphere will provide an independent SQL parser engine for parsing SQLs! I believe you will have some of the scenarios or use the SQL parser engine to get a parsed AST. From now on, you will have another option for your cases. Here are some of the advantages for ShardingSphere parser engine. Advantages Mostly perfect SQL statements supported for MySQL database Mostly perfect SQL statements supported for PostgreSQL database Basically SQL statements supported for SQLServer database Basically SQL statements supported for Oracle database SQL parsed result cache for the parsing performance AST parsed result and SQLStatement parsed result are provided meanwhile Simple extension approach for SQLStatement visitors Simple supplement approach and for SQL definition Continuous improvement for the much better feature in the future. 5.x release will include this one, please wait for our good news! Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
Re: [DISCUSS] Rename MasterSlave module to ReadWriteSplit
Hi, community, I know it is a little late to deliver this email. Still, I want to drop some discussion about this issue here. Currently, with a crude talking with other guys, there are two great alternatives ( PrimaryReplica ad QueryReplica) for the original name (i.e., masterSlave). I prefer QueryReplica, but considering we have finished renaming it as PrimaryReplica, my opinion is to keep it that way. However, @John wants to have another renaming work with `QueryReplica` for this module's optimal name. I’d like to listen to your idea about this one, but keep in mind that our next release is close at hand. So we have to make a decision ASAP. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 09/25/2020 01:46，Liang Zhang wrote： Done by https://github.com/apache/shardingsphere/issues/7560 On 2020/09/22 10:44:29, "zhangli...@apache.org" wrote: Because the release date is coming soon, I will do this issue. -- Sincerely, Liang Zhang (John) Apache ShardingSphere Harvey 于2020年9月16日周三 下午8:03写道： Looks good to me Thanks, Hongwei Li On Sep 16, 2020, at 1:43 AM, "zhangli...@apache.org" < zhangli...@apache.org> wrote: Primary-replica is good to me. So, how about: MasterSlave -> PrimaryReplicaReplication MasterDataSource -> PrimaryDataSource SlaveDataSource -> ReplicaDataSource -- Sincerely, Liang Zhang (John) Apache ShardingSphere Hongwei Li 于2020年9月14日周一 下午10:31写道： FYI: primary and replica, replica replication are widely used terms in AWS. https://aws.amazon.com/blogs/database/best-practices-for-amazon-rds-postgresql-replication/ https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/Replication.Redis.Groups.html On Mon, Sep 14, 2020 at 1:07 AM Juan Pan wrote: Hi Liang, I also looked through many docs of other databases, like MySQL, MariaDB, PostgreSQL, and MongoDB. For me, I can accept your proposal. In short, no matter `PrimarySecondaryReplication` or `PrimaryReplicaReplication`, IMO. We need to focus on `replication` which means a synchronization process among primary nodes and secondary nodes (Replica nodes). The links below will help me explain more. [1] https://medium.com/@Jelastic/mongodb-replica-set-with-master-slave-replication-and-automated-failover-be3cb374452 [2] https://www.datadriveninvestor.com/2020/05/28/the-master-slave-database-concept-for-beginners/ [3] https://www.postgresql.org/docs/9.2/warm-standby.html [4] https://mariadb.com/resources/blog/database-master-slave-replication-in-the-cloud/ Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 09/14/2020 12:34，zhangli...@apache.org wrote： I investigate related materials again, maybe read-write-spilt is not a good name. There are two features in Apache ShardingSphere now, master-slave and replica. Master-slave: Write to master data source and replication data to slave data sources async, and then read from slave data sources. Benefit: performance. Replica: Still in dev mode, we plan to use Raft algorithm to keep the multiple replicas with consensus. Benefit: consensus. The tow features can not use together, users can choose one of them in the same time only. I prefer to rename master-slave module to primary-secondary-replication, and rename replica module to consensus-replication. The new names can describe the feature more accurate and can let user to know they are mutually exclusive. Primary-standby-replication is another choice, but I am afraid the meaning of `standby` is waiting here and do nothing if normal, but the secondary data source still need to process the query requests. So, how about to rename the concept to: MasterSlave -> PrimarySecondaryReplication MasterDataSource -> PrimaryDataSource SlaveDataSource -> SecondaryDataSource Please advice me. -- Sincerely, Liang Zhang (John) Apache ShardingSphere Hongwei Li 于2020年9月14日周一 下午12:02写道： I don't have any idea about how the module 'shardingsphere-master-slave' vs 'shardingsphere-read-write-split', was named. If there was no specific reason, it is like a historical debt, but does not matter so much, as it has been there for a long time, everyone knows the function of the module. In the meantime, 'read-write-split' is more obvious from the processing/action perspective of the module. 'Master/Slave' is also fine from the processing object(datasource) perspective. For simple processing and not considering much, the replacement of 'master/slave' to 'primary/replica' including the combinations is much straightforward. It is kind of 'leave it as is' processing. For moving one step further, renaming the module to 'read-write-split' is a way to go. The questions are: shall we replace 'MasterSlave' as 'ReadWriteSplit' at all places? Do we need to consider if the replacement
Re: [New feature] New SQLASTParserEngine is pubic for user to parse your SQLs soon
Hi, We are sorry to come late, and thanks for your attention from Skywalking community! Please be a bit patient for the incoming 5.x release and look forward to your feedback About this feature later. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 10/21/2020 19:48，Sheng Wu wrote： Great!! SkyWalking community is waiting for this for a long time. To SkyWalking dev team Once we have this, we could have `table` oriented metrics, such as write/table/second, read/table/second, or the `hot compose query tables`. These kinds of metrics would be helpful to identify the performance issue. Thanks, ShardingSphere to bring this to the open. Sheng Wu 吴晟 Twitter, wusheng1108 Juan Pan 于2020年10月21日周三 下午7:37写道： Hi community, I am glad to announce that ShardingSphere will provide an independent SQL parser engine for parsing SQLs! I believe you will have some of the scenarios or use the SQL parser engine to get a parsed AST. From now on, you will have another option for your cases. Here are some of the advantages for ShardingSphere parser engine. Advantages Mostly perfect SQL statements supported for MySQL database Mostly perfect SQL statements supported for PostgreSQL database Basically SQL statements supported for SQLServer database Basically SQL statements supported for Oracle database SQL parsed result cache for the parsing performance AST parsed result and SQLStatement parsed result are provided meanwhile Simple extension approach for SQLStatement visitors Simple supplement approach and for SQL definition Continuous improvement for the much better feature in the future. 5.x release will include this one, please wait for our good news! Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[New feature] New SQLASTParserEngine is pubic for user to parse your SQLs soon
Hi community, I am glad to announce that ShardingSphere will provide an independent SQL parser engine for parsing SQLs! I believe you will have some of the scenarios or use the SQL parser engine to get a parsed AST. From now on, you will have another option for your cases. Here are some of the advantages for ShardingSphere parser engine. Advantages Mostly perfect SQL statements supported for MySQL database Mostly perfect SQL statements supported for PostgreSQL database Basically SQL statements supported for SQLServer database Basically SQL statements supported for Oracle database SQL parsed result cache for the parsing performance AST parsed result and SQLStatement parsed result are provided meanwhile Simple extension approach for SQLStatement visitors Simple supplement approach and for SQL definition Continuous improvement for the much better feature in the future. 5.x release will include this one, please wait for our good news! Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[ANNOUNCE] New committer: Zhengqiang Duan
Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Zhengqiang to be our committer and we are pleased to announce that he has accepted. Zhengqiang has been really active in the community, welcome! Guys, welcome your warm greetings for him! Best wishes, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere
Re:test
Hi hicruiser, Welcome. If you have not subscribed this mail list, [1] will give you instruction. [1] https://shardingsphere.apache.org/community/cn/contribute/subscribe/ Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 09/20/2020 09:21， wrote：
Re: [DISCUSS] Rename MasterSlave module to ReadWriteSplit
Hi Liang, I also looked through many docs of other databases, like MySQL, MariaDB, PostgreSQL, and MongoDB. For me, I can accept your proposal. In short, no matter `PrimarySecondaryReplication` or `PrimaryReplicaReplication`, IMO. We need to focus on `replication` which means a synchronization process among primary nodes and secondary nodes (Replica nodes). The links below will help me explain more. [1] https://medium.com/@Jelastic/mongodb-replica-set-with-master-slave-replication-and-automated-failover-be3cb374452 [2] https://www.datadriveninvestor.com/2020/05/28/the-master-slave-database-concept-for-beginners/ [3] https://www.postgresql.org/docs/9.2/warm-standby.html [4] https://mariadb.com/resources/blog/database-master-slave-replication-in-the-cloud/ Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 09/14/2020 12:34，zhangli...@apache.org wrote： I investigate related materials again, maybe read-write-spilt is not a good name. There are two features in Apache ShardingSphere now, master-slave and replica. Master-slave: Write to master data source and replication data to slave data sources async, and then read from slave data sources. Benefit: performance. Replica: Still in dev mode, we plan to use Raft algorithm to keep the multiple replicas with consensus. Benefit: consensus. The tow features can not use together, users can choose one of them in the same time only. I prefer to rename master-slave module to primary-secondary-replication, and rename replica module to consensus-replication. The new names can describe the feature more accurate and can let user to know they are mutually exclusive. Primary-standby-replication is another choice, but I am afraid the meaning of `standby` is waiting here and do nothing if normal, but the secondary data source still need to process the query requests. So, how about to rename the concept to: MasterSlave -> PrimarySecondaryReplication MasterDataSource -> PrimaryDataSource SlaveDataSource -> SecondaryDataSource Please advice me. -- Sincerely, Liang Zhang (John) Apache ShardingSphere Hongwei Li 于2020年9月14日周一 下午12:02写道： I don't have any idea about how the module 'shardingsphere-master-slave' vs 'shardingsphere-read-write-split', was named. If there was no specific reason, it is like a historical debt, but does not matter so much, as it has been there for a long time, everyone knows the function of the module. In the meantime, 'read-write-split' is more obvious from the processing/action perspective of the module. 'Master/Slave' is also fine from the processing object(datasource) perspective. For simple processing and not considering much, the replacement of 'master/slave' to 'primary/replica' including the combinations is much straightforward. It is kind of 'leave it as is' processing. For moving one step further, renaming the module to 'read-write-split' is a way to go. The questions are: shall we replace 'MasterSlave' as 'ReadWriteSplit' at all places? Do we need to consider if the replacement is meaningful at any place, such as the below names: MasterSlaveDataSourceRuleConfiguration MasterSlaveLoadBalanceAlgorithm On Sat, Sep 12, 2020 at 11:29 PM zhangli...@apache.org < zhangli...@apache.org> wrote: I like MasterDataSource -> PrimaryDataSource SlaveDataSource -> ReplicaDataSource But I am not sure about MasterSlave -> PrimaryReplica Because ShardingSphere's feature is route the update SQL to PrimaryDataSource and route the query SQL to ReplicaDataSource. The name ReadWriteSplit may describe the feature more clear. Any suggestions? -- Sincerely, Liang Zhang (John) Apache ShardingSphere Juan Pan 于2020年9月13日周日 上午10:07写道： Hi Craig, Thanks for your suggestion. :-) For me, both `primary` and `source` are ok. usually using terms like "primary", "secondary", "source", and "replica" Considering the expression above is mentioned in [1]. There are good reasons for MySQL to use "source" instead of "primary" because in their model there may be many "source" databases. Actually, ShardingSphere could also have many "source" databases (Depending on the user's configuration). MasterSlave -> ReadWriteSplit IMO, this renaming does not sound wonderful. I prefer MasterSlave -> PrimaryReplica or MasterSlave -> SourceReplica Moreover, I'd like to listen to others' opinions. [1] https://mysqlhighavailability.com/mysql-terminology-updates/ Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 09/12/2020 22:26，Craig Russell wrote： Hi, This will be a significant change so I think it would be good to resolve all of the naming before any PR is proposed. The first place to start might be the documentation to see all of the name chan
Re: [DISCUSS] Rename MasterSlave module to ReadWriteSplit
Hi Craig, Thanks for your suggestion. :-) For me, both `primary` and `source` are ok. > usually using terms like "primary", "secondary", "source", and "replica" Considering the expression above is mentioned in [1]. > There are good reasons for MySQL to use "source" instead of "primary" because > in their model there may be many "source" databases. Actually, ShardingSphere could also have many "source" databases (Depending on the user's configuration). > MasterSlave -> ReadWriteSplit IMO, this renaming does not sound wonderful. I prefer > MasterSlave -> PrimaryReplica or MasterSlave -> SourceReplica Moreover, I'd like to listen to others' opinions. [1] https://mysqlhighavailability.com/mysql-terminology-updates/ Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 09/12/2020 22:26，Craig Russell wrote： Hi, This will be a significant change so I think it would be good to resolve all of the naming before any PR is proposed. The first place to start might be the documentation to see all of the name changes in one place. There are good reasons for MySQL to use "source" instead of "primary" because in their model there may be many "source" databases. Personally I don't think "source" is particularly obvious to users, but they did not ask me. ;-) For ShardingSphere, "primary" and "replica" seem to be better choices. It will be easy for us to tell users that ShardingSphere's "replica" corresponds to MySQL's "source". So the concepts to be changed might be: MasterSlave -> PrimaryReplica MasterDataSource -> PrimaryDataSource SlaveDataSource -> ReplicaDataSource And again, it might be easier to review the name changes in the context of documentation changes. HTH, Craig On Sep 6, 2020, at 2:42 AM, zhangli...@apache.org wrote: Hi All, I want to discuss to rename MasterSlave module to ReadWriteSplit module. MySQL[1] has already change the master and slave to source and replica. Some concepts I plan to change: MasterSlave -> ReadWriteSplit MasterDataSource -> SourceDataSource SlaveDataSource -> ReplicaDataSource Please advice me. [1] https://mysqlhighavailability.com/mysql-terminology-updates/ -- Sincerely, Liang Zhang (John) Apache ShardingSphere Craig L Russell c...@apache.org
Some of the summary on HA governance feature of ShardingSphere with orchestrator
Hi community, I took some time to dig into `orchestrator`. Here are some of my thinkings about this product. I'd like to share them with you. 1. The primary language for this project is `go`. On the other hand, ShardingSphere is programmed by `JAVA`. 2. The license of `orchestrator` is Apache 2.0, which is friendly to collaborate. 3. `orchestrator` is a standalone application that provides web service or command line for discovery, refactoring, and recovery. 4. The feature of the key-values stored Consul or ZooKeeper is just for master discovery currently. Here is my conclusion, In short, `orchestrator` is not the best solution as I expected. Still, we welcome volunteers to take part in this contribution. If we want to empower ShardingSphere with HA governance, `orchestrator` is not the best solution as I expected. My reason is that `orchestrator` is independent of ShardingSphere and deployed as a standalone service to provide replication information. Moreover, kv-store based on Zookeeper only has the master information, not the whole relationship among the master node and all the slaves. Otherwise, the server API can do that instead. Consequently, ShardingSphere will have a firm rely on its web API (Or KV-values on ZK If we just need master info). I can not think of a graceful approach to bring it into ShardingSphere ecosystem. So, what do you think? Please let me know your innovative ideas. Best wishes, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[DISCUSS] Properties API change for ShardingSphere
Hi everyone, Here is another significant change for property configuration needing your opinions and thoughts. Since `.` is no longer supported by SpringBoot from 2.0.0 release, we have to modify the property configuration method for all implements of `TypedSPI` interface accordingly. Can we give it an absolute API change without caring about the compatibility problem? Or how do we fix this issue with a forward compatibility mood? For more details, please look at [1]. And welcome any comments! Regards, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
[ANNOUNCE] New committer: Jiwei Guo
Hi everyone, The Project Management Committee (PMC) for Apache ShardingSphere has invited Jiwei to become a committer and we are pleased to announce that he has accepted. Jiwei did much important and splendid work for ElasticJob. Thanks for your continued contributions. Welcome your congratulations to him! Best wishes, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere
Re:[VOTE] Release Apache ElasticJob UI 3.0.0-alpha
+1 binding. My check list, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] Source code distributions have correct names matching the current release. [x] LICENSE and NOTICE files are correct for each ShardingSphere repo. [x] All files have license headers if necessary. [x] No compiled archives bundled in source archive. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 08/11/2020 16:32，zhangli...@apache.org wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob UI version 3.0.0-alpha Release notes: https://github.com/apache/shardingsphere-elasticjob-ui/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-ui-3.0.0-alpha/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob-ui/tree/shardingsphere-elasticjob-ui-3.0.0-alpha/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob-ui/commit/174661dc77366eb8ab0742ac61ab0f5c84a60f2c Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob-ui/ GPG user ID: zhangliang The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:[DISCUSS] Archive shardingsphere-example and shardingsphere-acceptance-test
+1 binding. Good job! Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 08/11/2020 14:26，Zhang Yonglun wrote： We should archive the following repos: https://github.com/apache/shardingsphere-example https://github.com/apache/shardingsphere-acceptance-test All codes of shardingsphere-example have been merged into shardingsphere and acceptance-test will not use any more, so we don't need these repos any more. -- Zhang Yonglun Apache ShardingSphere
Re: [ANNOUNCE] Apache ShardingSphere ElasticJob-3.0.0-alpha available
Hi, Welcome! You can look at the issue list[1] to find an easy and interesting one as the first step. If you like, [2] the public account of weChat will give you more chances to learn more. [1] https://github.com/apache/shardingsphere-elasticjob/issues [2] https://mp.weixin.qq.com/s/H89M5imR_tuqPeWU7Ilwkw Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 08/10/2020 22:46，宋鲁生<183631330s...@gmail.com> wrote： could i join to be a developer zhangli...@apache.org 于2020年8月9日周日 下午2:26写道： Hi all, Apache ShardingSphere Team is glad to announce the new release of Apache ShardingSphere ElasticJob-3.0.0-alpha. ElasticJob is a distributed scheduling solution consisting of two separate projects, ElasticJob-Lite and ElasticJob-Cloud. Through the functions of flexible scheduling, resource management and job management, it creates a distributed scheduling solution suitable for Internet scenarios, and provides a diversified job ecosystem through open architecture design. It uses a unified job API for each project. Developers only need code one time and can deploy at will. ElasticJob became an Apache ShardingSphere Sub project on May 28 2020. Download Links: https://shardingsphere.apache.org/elasticjob/current/en/downloads/ Release Notes: https://github.com/apache/shardingsphere-elasticjob/blob/master/RELEASE-NOTES.md Website: http://shardingsphere.apache.org/elasticjob/ ShardingSphere Resources: - Issue: https://github.com/apache/shardingsphere-elasticjob/issues/ - Mailing list: dev@shardingsphere.apache.org - Documents: https://shardingsphere.apache.org/elasticjob/current/en/overview/ - Apache ShardingSphere Team -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:hi
Hi Thanks for your attention. My feeling is that you got a wrong subscribe addressee, [1] will provide you help. [1]https://shardingsphere.apache.org/community/cn/contribute/subscribe/ Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 08/8/2020 10:30，jim wrote： hi i want in
Re:[VOTE] Release Apache ShardingSphere ElasticJob-3.0.0-alpha
+1 binding. My check items, [x] Download links are valid. [x] Checksums and PGP signatures are valid. [x] Source code distributions have correct names matching the current release. [x] LICENSE and NOTICE files are correct for each ShardingSphere repo. [x] All files have license headers if necessary. [x] No compiled archives bundled in source archive. Thanks. Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 08/5/2020 01:39，zhangli...@apache.org wrote： Hello ShardingSphere Community, This is a call for vote to release Apache ShardingSphere ElasticJob-3.0.0-alpha Release notes: https://github.com/apache/shardingsphere-elasticjob/blob/master/RELEASE-NOTES.md The release candidates: https://dist.apache.org/repos/dist/dev/shardingsphere/elasticjob-3.0.0-alpha/ Maven 2 staging repository: https://repository.apache.org/content/repositories/orgapacheshardingsphere-1052/org/apache/shardingsphere/ Git tag for the release: https://github.com/apache/shardingsphere-elasticjob/tree/3.0.0-alpha/ Release Commit ID: https://github.com/apache/shardingsphere-elasticjob/commit/11ca056e5d58825a102981e6e25703b6748ca890 Keys to verify the Release Candidate: https://dist.apache.org/repos/dist/dev/shardingsphere/KEYS Look at here for how to verify this release candidate: https://shardingsphere.apache.org/community/en/contribute/release-elasticjob/ GPG user ID: zhangliang The vote will be open for at least 72 hours or until necessary number of votes are reached. Please vote accordingly: [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove with the reason PMC vote is +1 binding, all others is +1 non-binding. Checklist for reference: [ ] Download links are valid. [ ] Checksums and PGP signatures are valid. [ ] Source code distributions have correct names matching the current release. [ ] LICENSE and NOTICE files are correct for each ShardingSphere repo. [ ] All files have license headers if necessary. [ ] No compiled archives bundled in source archive. -- Sincerely, Liang Zhang (John) Apache ShardingSphere
Re:Subscribe
Hi, Welcome to subscribe. :) But it looks like you got a mistook email address for subscribing. [1] will give you a guide. Best, Trista [1] https://shardingsphere.apache.org/community/cn/contribute/subscribe/ Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 07/31/2020 00:58，wu_chun_fu wrote： Subscribe
[DISCUSS] Speed metadata loading when ShardingSphere initialize
Hi community, ### Backgroud ShardingSphere is aiming at simplifying the configuration workload and placing itself as `distributed-database` as possible to help users manage all the tables (no matter whether it is a sharding table or not). It is better for users to **use ShardingSphere and do not care about** sharding tables, non-sharding tables, encrypted tables, etc. But some configurations are necessary. :) Based on that, we have to load metadata from all the tables. But the problem is that this process is time costing when there are thousands of tables to load. This discussion is about **speeding the metadata loading**. ### Solution After some of the researches, we propose another solution to solve this issue. Currently, **a rough solution** is that we can load metadata through [information_schema](https://en.wikipedia.org/wiki/Information_schema) from different databases. (Thanks for your work! @Yonglun) Specifically, we do some queries from `information_schema` and skip JDBC' call for databases. In addition, the JDBC loading method **will remain** for conservative treatment. ### Plan In the beginning, I will design the basic framework and interfaces and then implement `MySQL` loading process. After that, we would like to ask our community for help to implement `PostgreSQL`, `Oracle`, `SQLServer`, and `H2`. Looking forward to your involvement! Last but not least, **welcome your discussion and thoughts about this issue and solution**! Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org
回复：ShardingSphere 分库问题
Hi guy, Thanks for your email. Actually, images or files do not work right here. So I suggest you raise an issue and upload your image at github[1]. English is certainly required. Best Trista [1] https://github.com/apache/shardingsphere/issues Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org 在2020年07月27日 18:11，贺琦 写道： ShardingSphere 研发人员： 你们好！ 请教一下，我只想使用ShardingSphere配置分库功能，表结构都是一样的，请问我该怎么配置呢？ 以下是我的配置：
转发： sharingsphere 执行sql插入时的关键字usage错误
Hi, Firstly, I presume you want to ask questions for ShardingSphere community, right? However, it looks like you mistook the email address. Please check the email you sent. The recipient is supposed to `dev@shardingsphere.apache.org`, rather than `secur...@apache.org`, right? Apache Security Team contacted us with your email. So We also want to get your feedback. Thanks a lot. Besides, you could get the answer to the issue you mentioned at[1]. [1] https://github.com/apache/shardingsphere/issues/6429 Cheers, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org - 转发邮件信息 - 发件人：Apache Security Team Apache Security Team 发送日期： 2020年07月24日 21:09 发送至： 主题： Fwd: sharingsphere 执行sql插入时的关键字usage错误 I'm not able to determine if this is a report of a security issue; please respond to them accordingly. Regards, Mark -- Forwarded message - From: 大薛 Date: Fri, Jul 24, 2020 at 2:31 AM Subject: sharingsphere execute sql Keyword usage error when inserting To: Actual SQL: The backtick mark on the keyword usage was removed during execution, causing sql execution error sql executed by mybatis-plus ### SQL: INSERT INTO template_sickness_detail_temporary (price, `usage`, frequency, doctor_advice) VALUES (?, ?, ?,?) 2020-07-24 09:27:00.557 INFO 4660 --- [main] ShardingSphere-SQL: Logic SQL: INSERT INTO template_sickness_detail_temporary (price, `usage`, frequency, doctor_advice) VALUES (?, ?, ?, ?) 2020-07-24 09:27:00.558 INFO 4660 --- [ main] ShardingSphere-SQL : SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=template_sickness_detail_temporary, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[])])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=template_sickness_detail_temporary, quoteCharacter=NONE, schemaNameLength=0), SQLToken(startIndex=48)], parametersIndex=4, logicSQL=INSERT INTO template_sickness_detail_temporary ( price,`usage`,frequency,doctor_advice ) VALUES ( ?,?,?,? )), 2020-07-24 09:27:00.558 INFO 4660 --- [ main] ShardingSphere-SQL : Actual SQL: master0 ::: INSERT INTO template_sickness_detail_temporary (price, usage, frequency, doctor_advice) VALUES (?, ?, ?, ?) ::: [56, , deee, good]
[ANNOUNCE] New committer: Jingshang Lu
Hi community, The Project Management Committee (PMC) for Apache ShardingSphere has invited Jingshang Lu to become a committer and we are pleased to announce that he has accepted. Jingshang is active in ShardingSphere community, hope see your further interactions with the community! Thanks for your contributions. Best wishes, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere
Re:Apache Software Foundation, Trillions and Trillions Served with Chinese subtitle LIVE!
Hi Sheng, Thanks for your information. It is pleasing to see this video with Chinese subtitles online. I also learned more of the interesting stories and valuable beliefs when I was doing its translation. Thanks for everyone’s support. Best, Trista Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 07/17/2020 09:39，Sheng Wu wrote： Hi Sally, Michael, Dominik, DevCom, and ALC Beijing First of all, thank you to make the video `Apache Software Foundation, Trillions and Trillions Served`, provide helps to me. I am here glad to share, with the supports from the SkyWalking community, ALC Beijing community, and Kaiyuanshe, we have this video online hosted on bilibili which is China's local friendly platform. And we have provided Chinese subtitles on that. https://www.bilibili.com/video/BV1Uz411i7MH In this short time, we already have 200+ watches, and we expect more. Thank you all to make this happens. Sheng Wu 吴晟 Twitter, wusheng1108
Re:[DISCUSS] Archive elasticjob-cloud
Thanks for your effort. +1 Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 07/15/2020 10:59，Zhang Yonglun wrote： We should archive the following repo: https://github.com/apache/shardingsphere-elasticjob-cloud All codes of this repo have been merged into shardingsphere-elasticjob-lite, so we don't need this repo any more. -- Zhang Yonglun Apache ShardingSphere
????????????????????Sharding-Proxy??????????????
Hi Thanks for your email, however the attachment, i.e., your log, could not show well. So I suggested you??d better raise an issue with this log on github[1]. Besides, English communication is required. [1] https://github.com/apache/shardingsphere/issues Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org ??2020??07??11?? 01:07?? ?? ??log ??mysql8.0.20,mysql-connector-java-8.0.20.jar
Re: [DISCUSS] Rename ShardingSphere GitHub/GitBox repo
Got it. If so, my vote is +1. Thanks Juan Pan (Trista) Senior DBA & PMC of Apache ShardingSphere E-mail: panj...@apache.org On 07/9/2020 16:43，Zhang Yonglun wrote： Hi Zonglei, elasticjob-cloud will be merged into elasticjob-lite, so there's only one elasticjob after that. Please refer to https://github.com/apache/shardingsphere-elasticjob-lite/issues/999 . -- Zhang Yonglun Apache ShardingSphere Zonglei Dong 于2020年7月9日周四 下午4:39写道： Hi Yonglun, Why do we need to change the repo's name? If we remove the suffix, how to make a difference with "shardingsphere-elasticjob-cloud" repo? Thanks. -- Zonglei Dong Apache ShardingSphere At 2020-07-09 15:23:39, "Zhang Yonglun" wrote: Hi community, I'd like to rename the elasticjob repo below. Any comments? From: https://github.com/apache/shardingsphere-elasticjob-lite To: https://github.com/apache/shardingsphere-elasticjob -- Zhang Yonglun Apache ShardingSphere
Re:[ANN] Welcome a new committer Xiao Yu(yu199195)
Hi Looking forward to your more involvement! Good job! Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere E-mail: panj...@apache.org On 07/3/2020 21:56??Myth wrote?? Hello, Community very privileged to be part of the community, to be apache shardingSphere committer today. I'm an open source fan, Before that I creator of dromara Open Source (https://github.com/Dromara),. hope to communicate with you about technologies related to ShardingSphere to make the community better. -- -- ??:"KimmKing"https://github.com/yu199195 Yours, kimmking
Re: [ANN] Welcome a new committer Meng Haoran(menghaoranss)
Hi Welcome on board! Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere E-mail: panj...@apache.org On 07/4/2020 09:58，Haoran Meng wrote： Thanks to community, thanks to kimmking, I’m Meng Haoran, now mainly do development related to governance of ShardingSphere. I’m very honored to be an Apache ShardingSphere committer, I know that this is inseparable from the community’s help and support, and I will continue to contribute to community to make it better, looking forward to communicate with you. KimmKing 于2020年7月3日 周五下午9:26写道： Hello, Community, On behalf of the Apache ShardingSphere PMC, it is my honor to announce that Meng Haoran[1] has been voted in as a new Apache ShardingSphere committer. Please join me to say congratulations to him! Haoran, would you give us a briefly introduce of yourself to the community? 1. https://github.com/menghaoranss Yours, kimmking -- Haoran Meng menghaora...@gmail.com
Re:[DISCUSS] Rename ShardingSphere GitHub/GitBox repo
LGTM, Thanks for effort, +1 Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere E-mail: panj...@apache.org On 06/17/2020 10:59，Zhang Yonglun wrote： Hi community, I'd like to rename these elastic-job repos below, just like what we did for sharding-sphere before. Any comments? From: https://github.com/apache/shardingsphere-elastic-job-lite https://github.com/apache/shardingsphere-elastic-job-cloud https://github.com/apache/shardingsphere-elastic-job-example https://github.com/apache/shardingsphere-elastic-job-doc To: https://github.com/apache/shardingsphere-elasticjob-lite https://github.com/apache/shardingsphere-elasticjob-cloud https://github.com/apache/shardingsphere-elasticjob-example https://github.com/apache/shardingsphere-elasticjob-doc -- Zhang Yonglun Apache ShardingSphere
[Translation] Translate technical articles concerning Apache ShardingSphere
Hi, community, This email is to call for volunteers to **translate some technical articles from Chinese into English**. Anyone who enjoys translation or wants to make some contributions to open source community is warmly welcomed! ### Competencies needed 1. English translation skill 2. Basically, know what ShardingSphere is doing ### Article list 1. [Start ElasticJob off with new goal](https://mp.weixin.qq.com/s/XJFj_vOj3bR6HRQUzy1ikg) 2. [How to construct the distributed database](https://mp.weixin.qq.com/s/YSoX0Apq6vQeu8TU_53EAw) 3. [Apache ShardingSphere is included in CNCF Landscape](https://mp.weixin.qq.com/s/hAxON1CMYvgFf6sFIHtDHA) 4. [The mixed open-source distributed transaction solution](https://mp.weixin.qq.com/s/fYESyuw7O4u7wB-tSWlhyg) 5. [Would you like to become an Apache committer](https://mp.weixin.qq.com/s/sFqOz10KTk23IhmmDTy67g) 6. [How automatic executor of ShardingSphere works](https://mp.weixin.qq.com/s/hIKZPJDfGfeduW4frwVN_w) 7. [How to merge the child resultsets](https://mp.weixin.qq.com/s/5__SGXEdvGqkVhpnrW6zug) 8. [The quick explanation of ShardingSphere transaction module](https://mp.weixin.qq.com/s/0LtqRTL8HewUAdZCk8LRLg) 9. [What is the ShardingProxy](https://mp.weixin.qq.com/s/bTX0n9tH4x8eue19b7rdGw) ### How to submit your translation 1. Add your translation to `xxx.en.md` in [blog](https://github.com/apache/shardingsphere/tree/master/docs/blog/content/material). > Notice, all the Chinese articles named `xxx.cn.md` could be found there. 2. Raise a PR for review. If you want to have a try, please comment on this issue[1] with `Article number and your estimated deadline`. Besides, any feedback and comments here are welcomed as well! [1] https://github.com/apache/shardingsphere/issues/6070 Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere E-mail: panj...@apache.org
