Re: [VOTE] Release Apache ShardingSphere 4.1.0 Round 2
The vote to release Apache ShardingSphere 4.1.0 has passed. 4 PMC member +1 binding votes: Liang Zhang Jun Zhao Yi Yang Juan Pan 2 community +1 non-binding vote: Jinwei Qin Haoran Meng Thank you everyone for taking the time to review the release and help us. -- Zhang Yonglun Apache ShardingSphere Zhang Yonglun 于2020年4月27日周一 下午3:53写道: > Hello ShardingSphere Community, > > This is a call for vote to release Apache ShardingSphere version 4.1.0 > round 2. > > Release notes: > https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md > > The release candidates: > https://dist.apache.org/repos/dist/dev/shardingsphere/4.1.0/ > > Maven 2 staging repository: > > https://repository.apache.org/content/repositories/orgapacheshardingsphere-1049/org/apache/shardingsphere/ > > Git tag for the release: > https://github.com/apache/shardingsphere/releases/tag/4.1.0 > > Release Commit ID: > > https://github.com/apache/shardingsphere/commit/7725abc520421f78f7586a8dc07e451978f64c9c > > 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: > zhangyonglun > > 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. > > -- > > Zhang Yonglun > Apache ShardingSphere >
[ANNOUNCE] Apache ShardingSphere 4.1.0 available
Hi all, Apache ShardingSphere Team is glad to announce the new release of Apache ShardingSphere 4.1.0. ShardingSphere is an open-source ecosystem consisted of a set of distributed database middleware solutions, including 2 independent products, Sharding-JDBC & Sharding-Proxy. They both provide functions of data sharding, distributed transaction and database orchestration, 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 -- Zhang Yonglun Apache ShardingSphere
Re: Re: Fwd: Fwd: Apache ShardingSphere项目社区申请加入『开源软件供应链点亮计划2020』
I would like to be one of the mentors. -- Zhang Yonglun Apache ShardingSphere KimmKing 于2020年5月13日周三 下午1:48写道: > That sound great. I am joining too. > > > > > > 在 2020-05-07 11:30:18,"蒋晓峰" 写道: > >Sound great, I’d like to join to be a mentor! > > > >On Thu, May 7, 2020 at 10:24 AM Juan Pan wrote: > > > >> Sound great, I’d like to join to be a mentor! > >> > >> > >> Juan Pan (Trista) > >> > >> Senior DBA & PPMC of Apache ShardingSphere(Incubating) > >> E-mail: panj...@apache.org > >> > >> > >> > >> > >> 在2020年05月6日 20:32,zhangli...@apache.org 写道: > >> Hi PMC members and committers, > >> > >> ShardingSphere has applied the Institute of SoftwareChinese Academy of > >> Sciences > >> Summer of Code 2020. This is a China locate event like GSoC, but for > >> Chinese college students and in Chinese. > >> > >> They have replied to accept our application. After that, we will need > >> mentors and tasks suitable for college students, > >> especially for Computer Science and Software Engineer master candidates. > >> > >> Anyone especially committer, who wants to be the official mentor, please > >> let me know. > >> > >> If you have willing to do this, please reply to this. > >> > >> Brief > >> > >> ShardingSphere community request our PMC member/committer to join the > >> mentor team voluntarily. This program could have several mentors from > the > >> community. > >> > >> The mentors should be > >> > >> 1. Be familiar with the project. > >> 2. Be a committer or PMC member > >> 3. Have some available time to mentor students in 3 months. Several > hours > >> per week > >> Every mentor could propose 3(max) tasks with details, which could be > >> suitable for the colleague and master candidate. > >> 4. PMC should evaluate and assist the mentors to do their works, if some > >> ones need them. > >> 5. Have time to evaluate the results. > >> > >> [1] https://isrc.iscas.ac.cn/summer2020/#/ > >> > >> -- > >> > >> Liang Zhang (John) > >> Apache ShardingSphere & Dubbo > >> > >> > >> -- Forwarded message - > >> 发件人: 暑期2020 组委会 > >> Date: 2020年5月6日周三 下午4:02 > >> Subject: 回复: Fwd: Apache ShardingSphere项目社区申请加入『开源软件供应链点亮计划2020』 > >> To: 张亮 > >> Cc: zhangli...@apache.org > >> > >> > >> 张亮老师, > >> > >> 您好,感谢您对“开源软件所供应链点亮计划-暑期2020”活动的关注,欢迎 ShardingSphere项目社区参与“暑期2020”活动。 > >> > >> “暑期2020“活动详情及常见问题见活动官网:https://isrc.iscas.ac.cn/summer2020/#/qa > >> > >> 在参与活动过程中如有问题,请随时联系。 > >> > >> 谢谢! > >> > >> > >> > >> “开源软件供应链点亮计划-暑期2020“工作组 > >> > >> > >> > >> *发件人: *张亮 > >> *发送时间: *2020年5月4日 9:55 > >> *收件人: *summer2020 > >> *主题: *Fw:Fwd: Apache ShardingSphere项目社区申请加入『开源软件供应链点亮计划2020』 > >> > >> > >> > >> > >> > >> > >> > >> 转发邮件信息 > >> 发件人:"zhangli...@apache.org" > >> 发送日期:2020-05-04 09:52:31 > >> 收件人:terrym...@163.com > >> 主题:Fwd: Apache ShardingSphere项目社区申请加入『开源软件供应链点亮计划2020』 > >> > >> > >> > >> > >> -- > >> > >> > >> > >> Liang Zhang (John) > >> Apache ShardingSphere & Dubbo > >> > >> > >> > >> -- Forwarded message - > >> 发件人: *zhangli...@apache.org * < > >> zhangli...@apache.org> > >> Date: 2020年5月3日周日 下午11:14 > >> Subject: Apache ShardingSphere项目社区申请加入『开源软件供应链点亮计划2020』 > >> To: > >> > >> > >> > >> 开源软件供应链点亮计划2020,组委会 > >> > >> 你好,我是Apache ShardingSphere项目VP和PMC成员。我代表社区,申请加入『开源软件供应链点亮计划2020』 > >> 申请通过后,此邮件会发送给项目管理委员会,并邀请更多的导师加入。 > >> > >> > >> > >> -- > >> > >> English Version > >> Hi, I am the VP and PMC member of Apache ShardingSphere. I am on behalf > of > >> the > >> community to request joining the event `开源软件供应链点亮计划2020`. > >> If we passed this, I will forward this application to the whole PMC > team, > >> and request more mentors besides myself. > >> > >> -- > >> > >> > >> > >> # 项目基本信息和联系方式 > >> > >> > >> > >> 1. 社区名称:Apache ShardingSphere > >> 2. 社区官方网址:https://shardingsphere.apache.org/ > >> 3. 社区Logo文件: > >> https://shardingsphere.apache.org/document/current/img/logo_v2.png > >> 4. 社区简短描述(30 字以内):Apache软件基金会顶级项目,分布式数据库中间件 > >> 5. 社区成段描述: > >> > >> Apache ShardingSphere 是一套开源的分布式数据库中间件解决方案组成的生态圈,它由Sharding-JDBC、 > >> Sharding-Proxy和Sharding-Sidecar(规划中)这3 > >> 款相互独立,却又能够混合部署配合使用的产品组成。它们均提供标准化的数据分片、分布式事务和数据库治理功能,可适用于如Java > >> 同构、异构语言、云原生等各种多样化的应用场景。 > >> > >> ShardingSphere > >> > >> > 定位为关系型数据库中间件,旨在充分合理地在分布式的场景下利用关系型数据库的计算和存储能力,而并非实现一个全新的关系型数据库。它通过关注不变,进而抓住事物本质。关系型数据库当今依然占有巨大市场,是各个公司核心业务的基石,未来也难于撼动,我们目前阶段更加关注在原有基础上的增量,而非颠覆。 > >> > >> > >> 6. 社区邮件列表(用于帮助学生了解社区,一般为开发者邮箱列表): d...@shardingsphere.org.apache > >> 7. 社区官方公共联系邮箱:d...@shardingsphere.org.apache > >> 8. 社区 “暑期2020” 项目列表页面链接(可选,可在页面准备好后再告知): > >> https://shardingsphere.apache.org/index_zh.html > >> 9. 技术标签:分布式、数据库、中间件 > >> 10. 专注领域:Java后端、关系型数据库 > >> > >> > >> > >> > >> > >> 项目官网:https://shardingsphere.apache.org/ > >> GitHub:https://github.com/apache/shardingsphere > >> 联系邮箱:zhangli...@apache.org > >> 联系人:张亮 > >> > >> > >> > >> -- > >> > >> > >> > >> Liang Zhang (John) > >> Apache ShardingSphere & Dubbo > >> >
Re: [DISCUSS]About a hotfix release version 4.1.1
+1. I will carry two other PRs to 4.1.1 for Sharding-Proxy fixed in 5.0.0. #3555, fix postgresql proxy return redundant command complete packet https://github.com/apache/shardingsphere/pull/5178 #3556, affect rows is always zero when using sharding-proxy postgresq https://github.com/apache/shardingsphere/pull/5194 -- Zhang Yonglun Apache ShardingSphere KimmKing 于2020年5月14日周四 下午2:46写道: > Hi, community. > After the latest version 4.1.0 release, there is a bug[1] found > during loading Oracle tables metadata and cause sharding-jdbc/proxy can't > bootstrap. > And it had fixed in master by a community contributor now [2]. > So, we should consider about a hotfix release version 4.1.1, fix it > to backport 4.x, and make sure Oracle env users can be use this coming > version. > > > Any suggestion/idea is welcome. > > > [1].https://github.com/apache/shardingsphere/issues/5581 > [2].https://github.com/apache/shardingsphere/pull/5436 > >
Re: [DISCUSS] 4.1.0 release plan
Thanks Liang. I'll sync up the comments to the release notes. -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年3月17日周二 下午5:43写道: > The tasks we need to discuss: > > > - Support scaling for shardingsphere > > This is alpha version, we need to discuss do binary release or just for > source release. > > > - Optimization for Sharing Parser with ANTLR Visitor for MySQL > > It is for all databases dialect, not for MySQL only. > > > - Parsing SubQuery > > Not finished yet, we need to talk about excluding this feature. > > > - Upgrade to Java 8 > > OK. > > > - Redesign class domain of parser module > > - Create database protocol module > > - Create new module for shardingsphere-sql-parse-binder > > We are not publishing them as independent modules, maybe user do not care > about these features. > > > - Refactor orchestration center interface > > - Improve integrate SQL parser test engine > > OK. > > > - Decouple UI and ShardingSphere > > Not finish yet, it is better to finish this feature before release. > > -- > > Liang Zhang (John) > Apache ShardingSphere & Dubbo > > > Zhang Yonglun 于2020年3月17日周二 下午2:05写道: > > > That was already finished. Thanks. > > > > -- > > > > Zhang Yonglun > > Apache ShardingSphere > > > > > > sushixiang 于2020年3月17日周二 下午1:15写道: > > > > > Sounds great. > > > > > > > > > And I want to know 'Upgrade to Java 8' has already be finished yet? If > > > not, I want to join. > > > > > > > > > > > > > > > --Original-- > > > From:"Zhang Yonglun" > > Date:Tue, Mar 17, 2020 12:30 PM > > > To:"dev" > > > > > Subject:[DISCUSS] 4.1.0 release plan > > > > > > > > > > > > Hi ShardingSphere community, > > > > > > I'm preparing a new release of ShardingSphere 4.x. The new release > > include > > > a couple significant updates, so the version will be 4.1.0. > > > > > > The target tag is > > > https://github.com/apache/incubator-shardingsphere/tree/dev-5.x which > > > include many bug fixes, enhancement and refactor. > > > > > > All updatas can be found in > > > > > > > > > https://github.com/apache/incubator-shardingsphere/issues?q=is%3Aissue+milestone%3A5.0.0+ > > > . > > > > > > After reviewing those issues, the major items in our next release note > > > would be: > > > > > > - Support scaling for shardingsphere > > > - Optimization for Sharing Parser with ANTLR Visitor for MySQL > > > - Parsing SubQuery > > > - Upgrade to Java 8 > > > - Redesign class domain of parser module > > > - Create database protocol module > > > - Create new module for shardingsphere-sql-parse-binder > > > - Refactor orchestration center interface > > > - Improve integrate SQL parser test engine > > > - Decouple UI and ShardingSphere > > > > > > Note: This release note is just a draft, anyone would add on to it. > > > > > > Currently, we are being preparing our next release, i appreciate it if > > you > > > could pick up more items for next release note, or give your > suggestions > > > about this release. > > > > > > Welcome to our release discussion. > > > -- > > > > > > Zhang Yonglun > > > Apache ShardingSphere > > >
[DISCUSS] 4.1.0 release plan
Hi ShardingSphere community, I'm preparing a new release of ShardingSphere 4.x. The new release include a couple significant updates, so the version will be 4.1.0. The target tag is https://github.com/apache/incubator-shardingsphere/tree/dev-5.x which include many bug fixes, enhancement and refactor. All updatas can be found in https://github.com/apache/incubator-shardingsphere/issues?q=is%3Aissue+milestone%3A5.0.0+ . After reviewing those issues, the major items in our next release note would be: - Support scaling for shardingsphere - Optimization for Sharing Parser with ANTLR Visitor for MySQL - Parsing SubQuery - Upgrade to Java 8 - Redesign class domain of parser module - Create database protocol module - Create new module for shardingsphere-sql-parse-binder - Refactor orchestration center interface - Improve integrate SQL parser test engine - Decouple UI and ShardingSphere Note: This release note is just a draft, anyone would add on to it. Currently, we are being preparing our next release, i appreciate it if you could pick up more items for next release note, or give your suggestions about this release. Welcome to our release discussion. -- Zhang Yonglun Apache ShardingSphere
Re: [DISCUSS] 4.1.0 release plan
That was already finished. Thanks. -- Zhang Yonglun Apache ShardingSphere sushixiang 于2020年3月17日周二 下午1:15写道: > Sounds great. > > > And I want to know 'Upgrade to Java 8' has already be finished yet? If > not, I want to join. > > > > > --Original------ > From:"Zhang Yonglun" Date:Tue, Mar 17, 2020 12:30 PM > To:"dev" > Subject:[DISCUSS] 4.1.0 release plan > > > > Hi ShardingSphere community, > > I'm preparing a new release of ShardingSphere 4.x. The new release include > a couple significant updates, so the version will be 4.1.0. > > The target tag is > https://github.com/apache/incubator-shardingsphere/tree/dev-5.x which > include many bug fixes, enhancement and refactor. > > All updatas can be found in > > https://github.com/apache/incubator-shardingsphere/issues?q=is%3Aissue+milestone%3A5.0.0+ > . > > After reviewing those issues, the major items in our next release note > would be: > > - Support scaling for shardingsphere > - Optimization for Sharing Parser with ANTLR Visitor for MySQL > - Parsing SubQuery > - Upgrade to Java 8 > - Redesign class domain of parser module > - Create database protocol module > - Create new module for shardingsphere-sql-parse-binder > - Refactor orchestration center interface > - Improve integrate SQL parser test engine > - Decouple UI and ShardingSphere > > Note: This release note is just a draft, anyone would add on to it. > > Currently, we are being preparing our next release, i appreciate it if you > could pick up more items for next release note, or give your suggestions > about this release. > > Welcome to our release discussion. > -- > > Zhang Yonglun > Apache ShardingSphere
Re: [VOTE] Release Apache ShardingSphere UI 4.1.0
The vote to release Apache ShardingSphere UI 4.1.0 has passed. 3 PMC member +1 binding votes: Liang Zhang Juan Pan Jun Zhao Thank you everyone for taking the time to review the release and help us. -- Zhang Yonglun Apache ShardingSphere zhaojun 于2020年5月9日周六 下午6:12写道: > +1, binding > > > I checked: > [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. > > Regards, > cherrylzhao > --- > Email:zhao...@apache.org > Jun Zhao(cherrylzhao) Apache ShardingSphere > > > Juan Pan 于2020年5月9日周六 上午10:32写道: > > > +1, binding > > > > > > Here is 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 & PPMC of Apache ShardingSphere(Incubating) > > E-mail: panj...@apache.org > > > > > > > > > > On 04/27/2020 11:11,Zhang Yonglun wrote: > > Please install ShardingSphere source code ( > > > > > https://dist.apache.org/repos/dist/dev/shardingsphere/4.1.0/apache-shardingsphere-4.1.0-src.zip > > ) > > before verification. > > > > -- > > > > Zhang Yonglun > > Apache ShardingSphere > > > > > > Zhang Yonglun 于2020年4月26日周日 下午6:29写道: > > > > Hello ShardingSphere Community, > > > > This is a call for vote to release Apache ShardingSphere UI version 4.1.0 > > > > Release notes: > > > > > > > https://github.com/apache/shardingsphere/blob/master/shardingsphere-ui/RELEASE-NOTES.md > > > > The release candidates: > > > > > > > https://dist.apache.org/repos/dist/dev/shardingsphere/shardingsphere-ui-4.1.0/ > > > > Git tag for the release: > > > > > > > https://github.com/apache/shardingsphere/releases/tag/shardingsphere-ui-4.1.0 > > > > Release Commit ID: > > > > > > > https://github.com/apache/shardingsphere/commit/dc24fa288dc38f4c439812dd3ae26feba2ce8963 > > > > 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/ > > > > 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. > > > > -- > > > > Zhang Yonglun > > Apache ShardingSphere > > > > >
[RESULT][VOTE] Release Apache ShardingSphere UI 4.1.0
We’ve received 3 +1 binding votes and 0 +1 non-binding vote: +1 binding, Liang Zhang +1 binding, Juan Pan +1 binding, Jun Zhao Thank you everyone for taking the time to review the release and help us. I will process to publish the release and send ANNOUNCE. -- Zhang Yonglun Apache ShardingSphere
[ANNOUNCE] Apache ShardingSphere UI 4.1.0 available
Hi all, Apache ShardingSphere Team is glad to announce the new release of Apache ShardingSphere UI 4.1.0. ShardingSphere is an open-source ecosystem consisted of a set of distributed database middleware solutions, including 2 independent products, Sharding-JDBC & Sharding-Proxy. They both provide functions of data sharding, distributed transaction and database orchestration, 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/shardingsphere-ui/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 -- Zhang Yonglun Apache ShardingSphere
Re: [Vote] ElasticJob donation
+1 binding -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年5月24日周日 下午9:56写道: > Hi ShardingSphere community, > > After we discuss fully about donate ElasticJob as a subproject of Apache > ShardingSphere in thread[1], I would like to start vote. > > Voting will start now (May. 24th date) and will remain open for at least 72 > hours, Request all PMC members to give their vote. > [ ] +1 Agree with donate ElasticJob as a subproject of Apache > ShardingSphere. > [ ] +0 No opinion. > [ ] -1 Do not agree because > > [1] > > https://lists.apache.org/thread.html/rd6171e2065be6bcfbeb7aba7e5c876eeed04db585c6ab78fc03a581c%40%3Cdev.shardingsphere.apache.org%3E > > -- > > Liang Zhang (John) > Apache ShardingSphere & Dubbo >
Re: SO slow to insert 5K record one time using Sharding-JDBC
It is the parsing module cost so much time. You can update the Sharding-JDBC to 4.1.0 or above to solve the problem. Please refer to the release notes of 4.1.0: https://github.com/apache/shardingsphere/releases/tag/4.1.0 -- Zhang Yonglun Apache ShardingSphere Terry Zhang 于2020年8月4日周二 下午6:37写道: > Hi, ShardingSphere community, > > > > We are using Sharding-Sphere 4.0.RC2 in our project for a long time. > Recently, we are encountering a serious issue struggling us. When we try to > insert 5K records one time into one table, it takes about 40 seconds. > However, when the execution time is about 0.11 second according to MySQL > Audit log. > > > > To figure our the root reason, we try to disable ShardingSphere and use > native JDBC instead, the result is very positive. It is so quick to execute > the same SQL. It is about 0.2s. > > > > Based on above findings, we think ShardingJDBC may cause it happen. > > > > To solve it, we are finding the possible solution. Here is our solution, > as not all of MySQL tables need to use sharding feature. we have those > non-sharding tables keep to use the native JDBC, not use ShardingJDBC. To > implement it, we try to find the way to implement it according to the > official document, unfortunately, we don’t find the best way. > > > > How to implement our solution? Alternatively, any other solution to > resolve it? > > > > To help to understand it easily ,here is some information for the > reference. > > > > The format of SQL DML like this-- > > INSERT INTO tbl_orders (id,f2,f3,) VALUES (1,xx,xx,...), > (2,xx,xx,...), (3,xx,xx,...), ...,(5000,xx,xx,...). > > Please note, the table tbl_orders is a non-sharding table. > > > > -- Java > > Java 1.8 > > > > MySQL--- > > MySQL 5.7 > > > > --OS -- > > CentOS 7.2 > > > > > > > > Terry
Re: [VOTE] Release Apache ShardingSphere ElasticJob-3.0.0-alpha
+1 binding. I have checked the following 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. -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年8月5日周三 上午1:39写道: > 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: [DISCUSS] Rename ShardingSphere GitHub/GitBox repo
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: Discuss ElasticJob lite 3.0.0-alpha release
Is the elastic-job-lite-console module included in this release? If so the License issue( https://github.com/apache/shardingsphere-elasticjob-lite/issues/759) of front-end should be resolved before start releasing. -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年7月7日周二 下午12:54写道: > Hi All, > > I want to discuss about ElasticJob lite 3.0.0-alpha release. > We have already develop ElasticJob for a month. > I am glad to see our community are active and excellent. > > Now we can discuss the release scope of the 1st apache release. > I prefer to name the 1st version as ElasticJob lite 3.0.0-alpha, which to > let users test it. > > The scope include: > > 1. New Job API for simplify configuration; > 2. New Job for customize job type dynamically; > 3. New spring namespace; > 4. One-off Bootstrap supported; > 5. Decouple Job executor and core module; > 6. Decouple event tracing module and core module; > 7. More database type supported of event tracing; > 8. Adjust snapshot service from Job level to Register center level. > 9. Upgrade Java version to JDK 8 and update some dependencies version. > 10. Fixes some bugs. > > Any thing else for the new release? > > -- > > Sincerely, > Liang Zhang (John) > Apache ShardingSphere >
Re: [DISCUSS] Archive elasticjob-cloud
Any comments? -- Zhang Yonglun Apache ShardingSphere Zhang Yonglun 于2020年7月15日周三 上午10:59写道: > 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 >
[DISCUSS] Archive elasticjob-cloud
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
Re: [DISCUSS] Rename ShardingSphere GitHub/GitBox repo
Hi Zonglei, We have already merged docs and examples to the two main repos. As to whether we can merge cloud to lite, it depends. -- Zhang Yonglun Apache ShardingSphere Zonglei Dong <598363...@qq.com> 于2020年6月17日周三 上午11:38写道: > +1, Great! > > > There is another problem, can we merge those four repos to one repo, or in > the future? > > > > > --原始邮件------ > 发件人:"Zhang Yonglun" 发送时间:2020年6月17日(星期三) 上午10:59 > 收件人:"dev" > 主题:[DISCUSS] Rename ShardingSphere GitHub/GitBox repo > > > > 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
[DISCUSS] Rename ShardingSphere GitHub/GitBox repo
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
Re: Could someone move the notification mail from dev?
Hi Sheng, Don't worry, I'm going to send a ticket to infra. -- Zhang Yonglun Apache ShardingSphere Sheng Wu 于2020年6月10日周三 上午11:20写道: > Anyone would take care of this? > The dev mail list turns crazy to me, already. > > Sheng Wu 吴晟 > Twitter, wusheng1108 > > > Sheng Wu 于2020年6月8日周一 上午11:36写道: > > > Hi > > > > As new repos have been added, there are many notification mails in the > > mail list again. Could some one remove them? > > > > Sheng Wu 吴晟 > > Twitter, wusheng1108 > > >
Re: Could someone move the notification mail from dev?
Done. Become better now. Yes, the Infra told me the same way. Thanks for reminding me. -- Zhang Yonglun Apache ShardingSphere Sheng Wu 于2020年6月10日周三 上午11:49写道: > You could do by yourself. > > https://github.com/apache/skywalking-rocketbot-ui/blob/master/.asf.yaml#L33 > > Do you want this way? > > Sheng Wu 吴晟 > Twitter, wusheng1108 > > > Zhang Yonglun 于2020年6月10日周三 上午11:27写道: > > > Hi Sheng, > > > > Don't worry, I'm going to send a ticket to infra. > > > > -- > > > > Zhang Yonglun > > Apache ShardingSphere > > > > > > Sheng Wu 于2020年6月10日周三 上午11:20写道: > > > > > Anyone would take care of this? > > > The dev mail list turns crazy to me, already. > > > > > > Sheng Wu 吴晟 > > > Twitter, wusheng1108 > > > > > > > > > Sheng Wu 于2020年6月8日周一 上午11:36写道: > > > > > > > Hi > > > > > > > > As new repos have been added, there are many notification mails in > the > > > > mail list again. Could some one remove them? > > > > > > > > Sheng Wu 吴晟 > > > > Twitter, wusheng1108 > > > > > > > > > >
Re: About count query in sharding-proxy 4.0.0-RC2
In server.yaml, followling props effect the concurrency, you can have a try. max.connections.size.per.query: 64 acceptor.size: 64 executor.size: 64 -- Zhang Yonglun Apache ShardingSphere Kai Yu 于2020年6月3日周三 下午3:16写道: > Hi ALL : > we have a project used 16 databases (db0 ...db15),we used > sharding-proxy 4.0.0-RC2 , > and config the sharding.xml like this: > schemaName: ty-basic-member > dataSources: > db0: > url: jdbc:mysql://xxx:3306/db0?useSSL=false > username: root > password: root > connectionTimeoutMilliseconds: 3 > idleTimeoutMilliseconds: 6 > maxLifetimeMilliseconds: 180 > maxPoolSize: 65 > ... > db15: > url: jdbc:mysql://xxx:3306/db15?useSSL=false > username: root > password: root > connectionTimeoutMilliseconds: 3 > idleTimeoutMilliseconds: 6 > maxLifetimeMilliseconds: 180 > maxPoolSize: 65 > > shardingRule: > tables: > member: > actualDataNodes: > dwj|13.member,dwj|12.member,dwj|11.member,dwj|10.member,dwj|5.member,dwj|6.member,dwj|7.member,dwj|15.member,dwj|8.member,dwj|14.member,dwj|9.member,dwj|0.member,dwj|0.member,dwj|1.member,dwj|2.member,dwj|3.member,dwj|4.member > databaseStrategy: > complex: > algorithmClassName: > com.toonyoo.app.sharding.proxy.ProxyDBShardingAlgorithm > shardingColumns: merchant_id,member_id > logicTable: member > > there is a table named member, it has 3kw rows, then we test the query > like this : > case 1 > we connect to the sharding-proxy application (like ip:3307 ) on server > , execute count sql: > MySQL [ty-basic-member]> select count(*) from member where merchant_id = > 'dwj'; > +--+ > | count(*) | > +--+ > | 34202355 | > +--+ > 1 row in set (37.59 sec) > > case 2 >we connect to db0 on server , executecount sql: > MySQL [db0]> select count(*) from member where merchant_id = 'dwj'; > +--+ > | count(*) | > +--+ > | 2217826 | > +--+ > 1 row in set (5.49 sec) > > > we found the count query cost 37s with 16 database , > we think the proxy component deal the 16database's query may cost 5s like > count query on db0 ,looks like Parallel ,we dont know why. > > Can you provide some technical details underlying principle for us to > understand? > thanks >
Re: [VOTE] Release Apache ShardingSphere 4.1.1
binding +1, I checked [X] Download links are valid. [X] Checksums and GPG 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. -- Zhang Yonglun Apache ShardingSphere KimmKing 于2020年6月5日周五 上午7:06写道: > Hello ShardingSphere Community, > > This is a call for vote to release Apache ShardingSphere version 4.1.1 > > Release notes: > https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md > > The release candidates: > https://dist.apache.org/repos/dist/dev/shardingsphere/4.1.1/ > > Maven 2 staging repository: > > https://repository.apache.org/content/repositories/orgapacheshardingsphere-1051/org/apache/shardingsphere/ > > Git tag for the release: > https://github.com/apache/shardingsphere/tree/4.1.1/ > > Release Commit ID: > > https://github.com/apache/shardingsphere/commit/96375f420074a8a4cba5307f1a308f3a87b3c7bf > > 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: > kimmking > > 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. > >
Re: Consider to remove the incubator release?
Agree. Incubator releases are no longer recommended public use. According to https://infra.apache.org/mirrors , I will delete the whole directory https://dist.apache.org/repos/dist/release/incubator/shardingsphere/ . Any comments? -- Zhang Yonglun Apache ShardingSphere Sheng Wu 于2020年6月10日周三 下午10:25写道: > Hi ShardingSphere > > As we have released new versions after graduation, the incubator releases > seem to be able to remove from the mirror system. > What do you think? NOTICE, All incubator releases are still available in > the archive. > https://archive.apache.org/dist/incubator/shardingsphere/ > > Sheng Wu 吴晟 > Twitter, wusheng1108 >
Re: [VOTE] Release Apache ShardingSphere UI 4.1.1
+1. I checked: [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. -- Zhang Yonglun Apache ShardingSphere KimmKing 于2020年6月9日周二 上午3:30写道: > Hello ShardingSphere Community, > > > > > This is a call for vote to release Apache ShardingSphere UI version 4.1.1. > > > > > Release notes: > > > https://github.com/apache/shardingsphere/blob/master/shardingsphere-ui/RELEASE-NOTES.md > > > > > The release candidates: > > > https://dist.apache.org/repos/dist/dev/shardingsphere/shardingsphere-ui-4.1.1/ > > > > > Git tag for the release: > > https://github.com/apache/shardingsphere/tree/shardingsphere-ui-4.1.1/ > > > > > Release Commit ID: > > > https://github.com/apache/shardingsphere/commit/87a34228da5a787d925e89ab1942d6f5cda4fa8b > > > > > 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: > > kimmking > > > > > 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.
Re: Consider to remove the incubator release?
Deleted. We can still find these releases in the archive repository https://archive.apache.org/dist/incubator/shardingsphere/ . -- Zhang Yonglun Apache ShardingSphere Zhang Yonglun 于2020年6月11日周四 下午12:04写道: > Agree. Incubator releases are no longer recommended public use. > > According to https://infra.apache.org/mirrors , I will delete the whole > directory > https://dist.apache.org/repos/dist/release/incubator/shardingsphere/ . > > Any comments? > > -- > > Zhang Yonglun > Apache ShardingSphere > > > Sheng Wu 于2020年6月10日周三 下午10:25写道: > >> Hi ShardingSphere >> >> As we have released new versions after graduation, the incubator releases >> seem to be able to remove from the mirror system. >> What do you think? NOTICE, All incubator releases are still available in >> the archive. >> https://archive.apache.org/dist/incubator/shardingsphere/ >> >> Sheng Wu 吴晟 >> Twitter, wusheng1108 >> >
Re: About count query in sharding-proxy 4.0.0-RC2
4.0.0-RC2 is too old. Can you change ther Proxy version to 4.1.1 just released? You can download from https://shardingsphere.apache.org/document/current/en/downloads/ . -- Zhang Yonglun Apache ShardingSphere Kai Yu 于2020年6月11日周四 下午4:19写道: > Hi: >We test again, the cost use Proxy to route to only one database : > > “select count(*) from member where merchant_id = 'dwj'” > > the cost is : > 4.32 sec > > its looks like the same cost of count query to one server( db0 or db1) > ,like this. > > so , the same question > query cost 25s with 16databases, why? > ________ > 发件人: Zhang Yonglun > 发送时间: 2020年6月4日 17:27 > 收件人: dev > 主题: Re: About count query in sharding-proxy 4.0.0-RC2 > > Get it. What about the cost use Proxy to route to only one database? > Actually merging just consume little time. > > -- > > Zhang Yonglun > Apache ShardingSphere > > > Kai Yu 于2020年6月4日周四 下午4:56写道: > > > hi: > >thx for your replay, > >our machine'environment is aliyun RDS 4C8G > > The 16 machines have same environment, it means one RDS one database,We > > have 16 RDS. > > Every databases have one table named 'member', the table have almost two > > million rows, it means 16databases total have > > thirty million rows . > > > > we connect to every server(from db0 to db15) , execute count sql is > > “select count(*) from member where merchant_id = 'dwj'” > > the cost is : > > > db0 (4.97 sec) > > > db1 (4.83 sec) > > > db2 (5.23 sec) > > > db3 (4.94 sec) > > > db4 (5.12 sec) > > > db5 (5.86 sec) > > > db6 (5.31 sec) > > > db7 (5.03 sec) > > > db8 (5.37 sec) > > > db9 (5.66 sec) > > > db9 (5.75 sec) > > > db10 (5.49 sec) > > > db11 (5.11 sec) > > > db12 (4.98 sec) > > > db13 (5.72 sec) > > > db14 (5.33 sec) > > > db15 (5.15 sec) > > ________ > > 发件人: Zhang Yonglun > > 发送时间: 2020年6月4日 14:03 > > 收件人: dev > > 主题: Re: About count query in sharding-proxy 4.0.0-RC2 > > > > If so, I suggest you connect all 16 databases and record the time cost > for > > each. > > Also, please show your hardware environment. > > > > -- > > > > Zhang Yonglun > > Apache ShardingSphere > > > > > > Kai Yu 于2020年6月3日周三 下午5:23写道: > > > > > Hi: > > >before i send last email ,i didn't add this props, > > > after I add props in server.yml , by the config like this: > > > max.connections.size.per.query: 64 > > > acceptor.size: 64 > > > executor.size: 64 > > > the count query sql cost 25s > > > > > > I changed props ,increase to 128 or 256 ,the count query sql cost still > > > between 24-26s > > > > > > > > > Is this situation normal ? > > > > > > Is there a way to continue improve this ? thanks > > > > > > 发件人: Kai Yu > > > 发送时间: 2020年6月3日 15:16 > > > 收件人: dev@shardingsphere.apache.org > > > 主题: About count query in sharding-proxy 4.0.0-RC2 > > > > > > Hi ALL : > > > we have a project used 16 databases (db0 ...db15),we used > > > sharding-proxy 4.0.0-RC2 , > > > and config the sharding.xml like this: > > > schemaName: ty-basic-member > > > dataSources: > > > db0: > > > url: jdbc:mysql://xxx:3306/db0?useSSL=false > > > username: root > > > password: root > > > connectionTimeoutMilliseconds: 3 > > > idleTimeoutMilliseconds: 6 > > > maxLifetimeMilliseconds: 180 > > > maxPoolSize: 65 > > > ... > > > db15: > > > url: jdbc:mysql://xxx:3306/db15?useSSL=false > > > username: root > > > password: root > > > connectionTimeoutMilliseconds: 3 > > > idleTimeoutMilliseconds: 6 > > > maxLifetimeMilliseconds: 180 > > > maxPoolSize: 65 > > > > > > shardingRule: > > > tables: > > > member: > > > actualDataNodes: > > > > > > dwj|13.member,dwj|12.member,dwj|11.member,dwj|10.member,dwj|5.member,dwj|6.member,dwj|7.member,dwj|15.member,dwj|8.member,dwj|14.member,dwj|9.member,dwj|0.member,dwj|0.member,dwj|1.member,dwj|2.member,dwj|3.member,dwj|4.member > > > databaseStrategy: > > > complex: > > > algorithmClassName: > > > com.toonyoo.app.sharding.
Re: About count query in sharding-proxy 4.0.0-RC2
Please refer to the docement of Execute Engine: https://shardingsphere.apache.org/document/current/en/features/sharding/principle/execute/ and Merge Engine: https://shardingsphere.apache.org/document/current/en/features/sharding/principle/merge/ -- Zhang Yonglun Apache ShardingSphere Kai Yu 于2020年6月3日周三 下午6:05写道: > hi > we think the count query from 16databases , in the end ,it seems every > database result to sum by sharding-proxy in memory ,we think it so fast. > for example , db0 count query cost 5s, by the sharding-proxy count > query cost 25s with 16databases, to deal with the count result need 20s > (25s-5s)? >we really want to know what the proxy do after the count query ? why > cost another 20s+? > thanks > > 发件人: Kai Yu > 发送时间: 2020年6月3日 17:23 > 收件人: dev@shardingsphere.apache.org > 主题: 回复: About count query in sharding-proxy 4.0.0-RC2 > > Hi: >before i send last email ,i didn't add this props, > after I add props in server.yml , by the config like this: > max.connections.size.per.query: 64 > acceptor.size: 64 > executor.size: 64 > the count query sql cost 25s > > I changed props ,increase to 128 or 256 ,the count query sql cost still > between 24-26s > > > Is this situation normal ? > > Is there a way to continue improve this ? thanks > > 发件人: Kai Yu > 发送时间: 2020年6月3日 15:16 > 收件人: dev@shardingsphere.apache.org > 主题: About count query in sharding-proxy 4.0.0-RC2 > > Hi ALL : > we have a project used 16 databases (db0 ...db15),we used > sharding-proxy 4.0.0-RC2 , > and config the sharding.xml like this: > schemaName: ty-basic-member > dataSources: > db0: > url: jdbc:mysql://xxx:3306/db0?useSSL=false > username: root > password: root > connectionTimeoutMilliseconds: 3 > idleTimeoutMilliseconds: 6 > maxLifetimeMilliseconds: 180 > maxPoolSize: 65 > ... > db15: > url: jdbc:mysql://xxx:3306/db15?useSSL=false > username: root > password: root > connectionTimeoutMilliseconds: 3 > idleTimeoutMilliseconds: 6 > maxLifetimeMilliseconds: 180 > maxPoolSize: 65 > > shardingRule: > tables: > member: > actualDataNodes: > dwj|13.member,dwj|12.member,dwj|11.member,dwj|10.member,dwj|5.member,dwj|6.member,dwj|7.member,dwj|15.member,dwj|8.member,dwj|14.member,dwj|9.member,dwj|0.member,dwj|0.member,dwj|1.member,dwj|2.member,dwj|3.member,dwj|4.member > databaseStrategy: > complex: > algorithmClassName: > com.toonyoo.app.sharding.proxy.ProxyDBShardingAlgorithm > shardingColumns: merchant_id,member_id > logicTable: member > > there is a table named member, it has 3kw rows, then we test the query > like this : > case 1 > we connect to the sharding-proxy application (like ip:3307 ) on server > , execute count sql: > MySQL [ty-basic-member]> select count(*) from member where merchant_id = > 'dwj'; > +--+ > | count(*) | > +--+ > | 34202355 | > +--+ > 1 row in set (37.59 sec) > > case 2 >we connect to db0 on server , executecount sql: > MySQL [db0]> select count(*) from member where merchant_id = 'dwj'; > +--+ > | count(*) | > +--+ > | 2217826 | > +--+ > 1 row in set (5.49 sec) > > > we found the count query cost 37s with 16 database , > we think the proxy component deal the 16database's query may cost 5s like > count query on db0 ,looks like Parallel ,we dont know why. > > Can you provide some technical details underlying principle for us to > understand? > thanks >
Re: About count query in sharding-proxy 4.0.0-RC2
If so, I suggest you connect all 16 databases and record the time cost for each. Also, please show your hardware environment. -- Zhang Yonglun Apache ShardingSphere Kai Yu 于2020年6月3日周三 下午5:23写道: > Hi: >before i send last email ,i didn't add this props, > after I add props in server.yml , by the config like this: > max.connections.size.per.query: 64 > acceptor.size: 64 > executor.size: 64 > the count query sql cost 25s > > I changed props ,increase to 128 or 256 ,the count query sql cost still > between 24-26s > > > Is this situation normal ? > > Is there a way to continue improve this ? thanks > > 发件人: Kai Yu > 发送时间: 2020年6月3日 15:16 > 收件人: dev@shardingsphere.apache.org > 主题: About count query in sharding-proxy 4.0.0-RC2 > > Hi ALL : > we have a project used 16 databases (db0 ...db15),we used > sharding-proxy 4.0.0-RC2 , > and config the sharding.xml like this: > schemaName: ty-basic-member > dataSources: > db0: > url: jdbc:mysql://xxx:3306/db0?useSSL=false > username: root > password: root > connectionTimeoutMilliseconds: 3 > idleTimeoutMilliseconds: 6 > maxLifetimeMilliseconds: 180 > maxPoolSize: 65 > ... > db15: > url: jdbc:mysql://xxx:3306/db15?useSSL=false > username: root > password: root > connectionTimeoutMilliseconds: 3 > idleTimeoutMilliseconds: 6 > maxLifetimeMilliseconds: 180 > maxPoolSize: 65 > > shardingRule: > tables: > member: > actualDataNodes: > dwj|13.member,dwj|12.member,dwj|11.member,dwj|10.member,dwj|5.member,dwj|6.member,dwj|7.member,dwj|15.member,dwj|8.member,dwj|14.member,dwj|9.member,dwj|0.member,dwj|0.member,dwj|1.member,dwj|2.member,dwj|3.member,dwj|4.member > databaseStrategy: > complex: > algorithmClassName: > com.toonyoo.app.sharding.proxy.ProxyDBShardingAlgorithm > shardingColumns: merchant_id,member_id > logicTable: member > > there is a table named member, it has 3kw rows, then we test the query > like this : > case 1 > we connect to the sharding-proxy application (like ip:3307 ) on server > , execute count sql: > MySQL [ty-basic-member]> select count(*) from member where merchant_id = > 'dwj'; > +--+ > | count(*) | > +--+ > | 34202355 | > +--+ > 1 row in set (37.59 sec) > > case 2 >we connect to db0 on server , executecount sql: > MySQL [db0]> select count(*) from member where merchant_id = 'dwj'; > +--+ > | count(*) | > +--+ > | 2217826 | > +--+ > 1 row in set (5.49 sec) > > > we found the count query cost 37s with 16 database , > we think the proxy component deal the 16database's query may cost 5s like > count query on db0 ,looks like Parallel ,we dont know why. > > Can you provide some technical details underlying principle for us to > understand? > thanks >
Re: About count query in sharding-proxy 4.0.0-RC2
Get it. What about the cost use Proxy to route to only one database? Actually merging just consume little time. -- Zhang Yonglun Apache ShardingSphere Kai Yu 于2020年6月4日周四 下午4:56写道: > hi: >thx for your replay, >our machine'environment is aliyun RDS 4C8G > The 16 machines have same environment, it means one RDS one database,We > have 16 RDS. > Every databases have one table named 'member', the table have almost two > million rows, it means 16databases total have > thirty million rows . > > we connect to every server(from db0 to db15) , execute count sql is > “select count(*) from member where merchant_id = 'dwj'” > the cost is : > > db0 (4.97 sec) > > db1 (4.83 sec) > > db2 (5.23 sec) > > db3 (4.94 sec) > > db4 (5.12 sec) > > db5 (5.86 sec) > > db6 (5.31 sec) > > db7 (5.03 sec) > > db8 (5.37 sec) > > db9 (5.66 sec) > > db9 (5.75 sec) > > db10 (5.49 sec) > > db11 (5.11 sec) > > db12 (4.98 sec) > > db13 (5.72 sec) > > db14 (5.33 sec) > > db15 (5.15 sec) > > 发件人: Zhang Yonglun > 发送时间: 2020年6月4日 14:03 > 收件人: dev > 主题: Re: About count query in sharding-proxy 4.0.0-RC2 > > If so, I suggest you connect all 16 databases and record the time cost for > each. > Also, please show your hardware environment. > > -- > > Zhang Yonglun > Apache ShardingSphere > > > Kai Yu 于2020年6月3日周三 下午5:23写道: > > > Hi: > >before i send last email ,i didn't add this props, > > after I add props in server.yml , by the config like this: > > max.connections.size.per.query: 64 > > acceptor.size: 64 > > executor.size: 64 > > the count query sql cost 25s > > > > I changed props ,increase to 128 or 256 ,the count query sql cost still > > between 24-26s > > > > > > Is this situation normal ? > > > > Is there a way to continue improve this ? thanks > > > > 发件人: Kai Yu > > 发送时间: 2020年6月3日 15:16 > > 收件人: dev@shardingsphere.apache.org > > 主题: About count query in sharding-proxy 4.0.0-RC2 > > > > Hi ALL : > > we have a project used 16 databases (db0 ...db15),we used > > sharding-proxy 4.0.0-RC2 , > > and config the sharding.xml like this: > > schemaName: ty-basic-member > > dataSources: > > db0: > > url: jdbc:mysql://xxx:3306/db0?useSSL=false > > username: root > > password: root > > connectionTimeoutMilliseconds: 3 > > idleTimeoutMilliseconds: 6 > > maxLifetimeMilliseconds: 180 > > maxPoolSize: 65 > > ... > > db15: > > url: jdbc:mysql://xxx:3306/db15?useSSL=false > > username: root > > password: root > > connectionTimeoutMilliseconds: 3 > > idleTimeoutMilliseconds: 6 > > maxLifetimeMilliseconds: 180 > > maxPoolSize: 65 > > > > shardingRule: > > tables: > > member: > > actualDataNodes: > > > dwj|13.member,dwj|12.member,dwj|11.member,dwj|10.member,dwj|5.member,dwj|6.member,dwj|7.member,dwj|15.member,dwj|8.member,dwj|14.member,dwj|9.member,dwj|0.member,dwj|0.member,dwj|1.member,dwj|2.member,dwj|3.member,dwj|4.member > > databaseStrategy: > > complex: > > algorithmClassName: > > com.toonyoo.app.sharding.proxy.ProxyDBShardingAlgorithm > > shardingColumns: merchant_id,member_id > > logicTable: member > > > > there is a table named member, it has 3kw rows, then we test the query > > like this : > > case 1 > > we connect to the sharding-proxy application (like ip:3307 ) on > server > > , execute count sql: > > MySQL [ty-basic-member]> select count(*) from member where merchant_id = > > 'dwj'; > > +--+ > > | count(*) | > > +--+ > > | 34202355 | > > +--+ > > 1 row in set (37.59 sec) > > > > case 2 > >we connect to db0 on server , executecount sql: > > MySQL [db0]> select count(*) from member where merchant_id = 'dwj'; > > +--+ > > | count(*) | > > +--+ > > | 2217826 | > > +--+ > > 1 row in set (5.49 sec) > > > > > > we found the count query cost 37s with 16 database , > > we think the proxy component deal the 16database's query may cost 5s > like > > count query on db0 ,looks like Parallel ,we dont know why. > > > > Can you provide some technical details underlying principle for us to > > understand? > > thanks > > >
Re: [VOTE] Release Apache ElasticJob UI 3.0.0-alpha
+1 binding. I have checked the following 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. -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年8月11日周二 下午4:33写道: > 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: [VOTE] Release Apache ShardingSphere ElasticJob-3.0.0-RC1
+1 binding I checked: [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. -- Zhang Yonglun Apache ShardingSphere Juan Pan 于2020年12月24日周四 下午9:37写道: > My +1 binding, checking items are the following, > > > > > [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. > > > > > > --- > Email:panj...@apache.org > Juan Pan(Trista) Apache ShardingSphere > > > On 12/19/2020 11:37,吴伟杰 wrote: > Hello ShardingSphere Community, > > This is a call for vote to release Apache ShardingSphere > ElasticJob-3.0.0-RC1 > > 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-RC1/ > > Maven 2 staging repository: > > https://repository.apache.org/content/repositories/orgapacheshardingsphere-1059/org/apache/shardingsphere/elasticjob/ > > Git tag for the release: > https://github.com/apache/shardingsphere-elasticjob/tree/3.0.0-RC1/ > > Release Commit ID: > > https://github.com/apache/shardingsphere-elasticjob/commit/e3607ee692001692128cf23efe66ee39dc1c277a > > 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: > wuweijie > > 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, > Weijie Wu (TeslaCN) > Apache ShardingSphere >
Re: [VOTE] Release Apache ShardingSphere UI 5.0.0-alpha [Round 2]
+1 I have checked: [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. -- Zhang Yonglun Apache ShardingSphere Haoran Meng 于2020年11月17日周二 下午7:48写道: > +1 > > I checked: > > [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 于2020年11月17日周二 上午9:58写道: > > > 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 > > > > > > > > > > -- > Haoran Meng > menghaora...@gmail.com >
Re: [VOTE] Release Apache ShardingSphere ElasticJob-3.0.0-beta [Round 4]
+1 binding [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. -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年10月31日周六 下午10:58写道: > 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 >
Re: [VOTE] Release Apache ShardingSphere 5.0.0-alpha
+1 binding [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. -- Zhang Yonglun Apache ShardingSphere Juan Pan 于2020年11月3日周二 下午12:29写道: > 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: [VOTE] Release Apache ShardingSphere ElasticJob UI 3.0.0-beta
+1 binding [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. -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年10月26日周一 下午1:23写道: > 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 UI 3.0.0-RC1
+1 binding I checked: [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. -- Zhang Yonglun Apache ShardingSphere zhangli...@apache.org 于2020年12月29日周二 下午12:32写道: > +1 > I checked: > > [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. > > I find some minor problem, we can fix them at next release. > > 1. mvnw's file permission is not correct in mac os, we need to change the > assembly file to fix it. > 2. We are missing licenses of `jsr305-3.0.2`, > `geronimo-jms_1.1_spec-1.1.1`, `geronimo-jpa_2.2_spec-1.1`, > `geronimo-jta_1.1_spec-1.1.1` in > `apache-shardingsphere-elasticjob-3.0.0-RC1-lite-ui-bin.tar.gz`. I checked > them, the licenses of them are all compatible with Apache 2.0. > > -- > > Sincerely, > Liang Zhang (John) > Apache ShardingSphere > > > > Hongtao Gao 于2020年12月28日周一 上午8:15写道: > > > +1 (binding) > > > > I had checked the below items: > > 1. asc,*sha512 files are correct. > > 2. Build from source code successfully. > > 3. Source and binary packages contain LICENSE and NOTICE files. > > 4. Checks source files license headers. > > > > Good luck > > > > > > 吴伟杰 于2020年12月27日周日 下午12:14写道: > > > > > Hello ShardingSphere Community, > > > > > > This is a call for vote to release Apache ShardingSphere ElasticJob UI > > > version 3.0.0-RC1 > > > > > > 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-RC1/ > > > > > > Git tag for the release: > > > https://github.com/apache/shardingsphere-elasticjob-ui/tree/3.0.0-RC1/ > > > > > > Release Commit ID: > > > > > > > > > https://github.com/apache/shardingsphere-elasticjob-ui/commit/d46c9bc9ebc500506badefbc9aaa24e89c72f395 > > > > > > 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: > > > wuweijie > > > > > > 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, > > > Weijie Wu (TeslaCN) > > > Apache ShardingSphere > > > > > >
Re: [VOTE] Release Apache ShardingSphere 5.0.0-beta
+1 binding Please note that the year in the NOTICE file is still 2020, you may want to update it after this release. I have checked: [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. -- Zhang Yonglun Apache ShenYu (Incubating) Apache ShardingSphere Zhang Yonglun 于2021年6月15日周二 上午11:47写道: > Kindly reminder, please list what you have checked before vote. > > -- > > Zhang Yonglun > Apache ShenYu (Incubating) > Apache ShardingSphere > > > Juan Pan 于2021年6月13日周日 下午1:21写道: > >> 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 >> >>
Re: [VOTE] Release Apache ShardingSphere 5.0.0-beta
Kindly reminder, please list what you have checked before vote. -- Zhang Yonglun Apache ShenYu (Incubating) Apache ShardingSphere Juan Pan 于2021年6月13日周日 下午1:21写道: > 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 > >
Re: [ANNOUNCE] New committer: Thanoshan MV
Welcome on board! -- Zhang Yonglun Apache ShenYu (Incubating) Apache ShardingSphere Juan Pan 于2021年11月17日周三 上午10:10写道: > 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 > >
Re: [VOTE] Release Apache ShardingSphere ElasticJob UI 3.0.0
+1, I checked: [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. -- Zhang Yonglun Apache ShenYu (Incubating) Apache ShardingSphere 吴伟杰 于2021年7月15日周四 上午11:04写道: > 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: [VOTE] Release Apache ShardingSphere 5.1.0 [round 4]
Hi, +1 I checked: - signatures and hashes are fine - LICENSE and NOTICE are fine - All source have ASF headers - No unexpected binary files - Can compile from source -- Zhang Yonglun Apache ShenYu (Incubating) Apache ShardingSphere Haoran Meng 于2022年2月9日周三 19:03写道: > > 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