CVE-2022-45347: Apache ShardingSphere-Proxy: ShardingSphere-Proxy MySQL authentication bypass

2022-12-22 Thread Weijie Wu
Description: ShardingSphere-Proxy with MySQL protocol didn't cleanup session completely after client authentication failed, which allows an attacker to execute normal commands by constructing a special MySQL client. This vulnerability has been fixed in ShardingSphere 5.3.0. References: https

Re: 关于sharding proxy的相关功能疑问

2022-11-04 Thread zhangli...@apache.org
Hello my friend, Could you translate it to English? -- Sincerely, Liang Zhang (John) Apache ShardingSphere 黄桂荣 于2022年11月5日周六 12:08写道: > 你们好!在测试和调研sharding proxy中间件的功能 ,有如下疑问,请针对我的问题给我一个回复好吗? > > > 1 通过 Sharding Proxy 中间件 去备份 MySQL 怎么保证 全局一致性备份(假设我的业务做了数据分片,分片刚好是

关于sharding proxy的相关功能疑问

2022-11-04 Thread 黄桂荣
你们好!在测试和调研sharding proxy中间件的功能 ,有如下疑问,请针对我的问题给我一个回复好吗? 1 通过 Sharding Proxy 中间件 去备份 MySQL 怎么保证 全局一致性备份(假设我的业务做了数据分片,分片刚好是跨数据库集群)? 2 把sharding proxy做为后端程序连接数据库的中间件,后端数据库高可用怎么做到故障切换后,中间件怎么去感知主节点的切换 ? 3 后端数据库如何 做到横向扩展,就比如说我原本业务数据在一个数据库集群中,随着时间和业务量的增长,数据量大,随之而来的就是要对数据库进行横向扩展,那么中间件怎么做到认识新数据节点和旧的数据节点中

Re: [VOTE Result] Donate ShardingSphere-Proxy Helm Chart

2022-04-06 Thread Liang Zhang
The vote thread is [1] [1] https://lists.apache.org/thread/6xr95mlt88x1c2ckv4py2nnz26796jdt On 2022/04/01 03:41:46 "zhangli...@apache.org" wrote: > Vote passed. > > We got 7 votes, the details of result: > > 2 +1 from PMC members > 4 +1 from Committers > 1 +1 from Community contributor > > >

[VOTE Result] Donate ShardingSphere-Proxy Helm Chart

2022-03-31 Thread zhangli...@apache.org
Vote passed. We got 7 votes, the details of result: 2 +1 from PMC members 4 +1 from Committers 1 +1 from Community contributor -- Sincerely, Liang Zhang (John) Apache ShardingSphere

Re:[VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-31 Thread Juan Pan
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 commu

Re: [VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-30 Thread Hongsheng Zhong
+1 On 2022/03/29 03:24:05 "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/ShardingS

Re: [VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-29 Thread Panagiotis Parthenis
+ 1 On Tue, 29 Mar 2022 at 10:04, 陈出新 wrote: > + 1 > > > 2022年3月29日 上午11:24,zhangli...@apache.org 写道: > > > > Hi community, > > > > Please vote about donate ShardingSphere-Proxy Helm Chart to > ShardingSphere > > community. > > > > T

Re: [VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-29 Thread 陈出新
+ 1 > 2022年3月29日 上午11:24,zhangli...@apache.org 写道: > > 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+H

Re: [VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-29 Thread Longtao Jiang
+1 —— Longtao Jiang (jianglong...@apache.org) Apache ShardingSphere Committer GitHub@RaigorJiang On 2022/03/29 03:24:05 "zhangli...@apache.org" wrote: > Hi community, > > Please vote about donate ShardingSphere-Proxy Helm Chart to Shardin

Re: [VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-29 Thread Zhengqiang Duan
b@TeslaCN > > zhangli...@apache.org 于2022年3月29日周二 11:24写道: > > > > Hi community, > > > > Please vote about donate ShardingSphere-Proxy Helm Chart to > ShardingSphere > > community. > > > > The proposal is: > > > https://cwiki.apache.org/co

Re: [VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-29 Thread 吴伟杰
+1 --- Weijie Wu 吴伟杰 Apache ShardingSphere Committer GitHub@TeslaCN zhangli...@apache.org 于2022年3月29日周二 11:24写道: > > Hi community, > > Please vote about donate ShardingSphere-Proxy Helm Chart to ShardingSphere > community. &

Re: [VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-28 Thread Guocheng Tang
+1 On Mar 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

[VOTE] Donate ShardingSphere-Proxy Helm Chart

2022-03-28 Thread zhangli...@apache.org
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

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-28 Thread zhangli...@apache.org
> > totalo 于2022年3月26日周六 22:45写道: > > > > +1 > > > > > > On Mar 25, 2022 20:21,zhangli...@apache.org > wrote: > > > > > > Hi community, I want to discuss about donate ShardingSphere-Proxy Helm > Chart to ShardingSphere communi

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-26 Thread 吴伟杰
+1 --- Weijie Wu 吴伟杰 Apache ShardingSphere Committer GitHub@TeslaCN totalo 于2022年3月26日周六 22:45写道: > > +1 > > > On Mar 25, 2022 20:21,zhangli...@apache.org wrote: > > > Hi community, I want to discuss about donate Shardin

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-26 Thread totalo
+1 On Mar 25, 2022 20:21,zhangli...@apache.org wrote: Hi community, I want to discuss 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

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-26 Thread Guocheng Tang
+1 On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote: > Hi community, > > I want to discuss about donate ShardingSphere-Proxy Helm Chart to > ShardingSphere community. > > The proposal is: > https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingS

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-25 Thread Chuxinchen
+ 1 > 在 2022年3月25日,20:21,zhangli...@apache.org 写道: > > Hi community, > > I want to discuss about donate ShardingSphere-Proxy Helm Chart to > ShardingSphere community. > > The proposal is: > https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingSpher

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-25 Thread Zhengqiang Duan
+1 —— Zhengqaing Duan (duanzhengqi...@apache.org) Apache ShardingSphere Committer GitHub@strongduanmu zhangli...@apache.org 于2022年3月25日周五 20:21写道: > Hi community, > > I want to discuss about donate ShardingSphere-Proxy Helm Chart to > ShardingSphe

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-25 Thread Hongsheng Zhong
+1 On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote: > Hi community, > > I want to discuss about donate ShardingSphere-Proxy Helm Chart to > ShardingSphere community. > > The proposal is: > https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingS

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-25 Thread Lu Jingshang
+1 On 2022/03/25 12:26:06 Longtao Jiang wrote: > +1 > > On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote: > > Hi community, > > > > I want to discuss about donate ShardingSphere-Proxy Helm Chart to > > ShardingSphere community. > >

Re: [DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-25 Thread Longtao Jiang
+1 On 2022/03/25 12:21:17 "zhangli...@apache.org" wrote: > Hi community, > > I want to discuss about donate ShardingSphere-Proxy Helm Chart to > ShardingSphere community. > > The proposal is: > https://cwiki.apache.org/confluence/display/SHARDINGSPHERE/ShardingS

[DISCUSS] Donate ShardingSphere-Proxy Helm Chart

2022-03-25 Thread zhangli...@apache.org
Hi community, I want to discuss 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

Re: ShardingSphere-Proxy Helm Chart Donation Proposal

2022-03-25 Thread zhangli...@apache.org
The format is bad. I will paste the proposal to wiki later. -- Sincerely, Liang Zhang (John) Apache ShardingSphere 李卓 于2022年3月25日周五 19:57写道: > Background ShardingSphere is a Top-Level open source distributed database > middleware. However, currently ShardingSphere cannot be

ShardingSphere-Proxy Helm Chart Donation Proposal

2022-03-25 Thread 李卓
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

shardingsphere proxy ????????????????

2021-08-13 Thread ????
shardingsphere proxy ??

????????????????????Sharding-Proxy??????????????

2020-07-12 Thread Juan Pan
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)

??????????????Sharding-Proxy??????????????

2020-07-10 Thread ????
??log??mysql8.0.20,mysql-connector-java-8.0.20.jar

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-11 Thread Zhang Yonglun
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

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-11 Thread Kai Yu
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 co

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Zhang Yonglun
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 machin

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Kai Yu
.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

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Zhang Yonglun
于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 16dat

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Zhang Yonglun
> > 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 data

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Kai Yu
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

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Kai Yu
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

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Zhang Yonglun
e 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 >

About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Kai Yu
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

Re:Optimize datasource config in sharding-jdbc and sharding-proxy??

2020-05-21 Thread Juan Pan
Hi, I can feel the pain at the tedious work of DataSource configuration. Thanks for your effort in this issue. Considering configuration format, currently, I have no satisfying solution, here[1] is just some of my daft idea for discussion, which is inspired by `defaultDatabaseStrategy`

Optimize datasource config in sharding-jdbc and sharding-proxy??

2020-05-21 Thread Myth
Hi All community friends: now,There are a lot of the same datasource config when we use sharding,master-slave datasource. In springboot project we can configruation like this : -

Re: [Refactoring] New architecture of runtime context for Sharding Proxy and JDBC

2020-05-17 Thread zhangli...@apache.org
(John) Apache ShardingSphere & Dubbo Juan Pan 于2020年5月14日周四 下午12:09写道: > Hi fellows, > > > There is a significant change for release 5.x need to be public to our > community. > To get a consistent and straightforward orchestration function for both of > Sharding Prox

[Refactoring] New architecture of runtime context for Sharding Proxy and JDBC

2020-05-13 Thread Juan Pan
Hi fellows, There is a significant change for release 5.x need to be public to our community. To get a consistent and straightforward orchestration function for both of Sharding Proxy and Sharding JDBC, we extracted the joint members from them, which will be passed down to `shardingsphere

Re:Re: 客户端访问sharding proxy时,需要先use

2020-04-27 Thread KimmKing
--- > >Liang Zhang (John) >Apache ShardingSphere & Dubbo > > >rainbpfjin(金沛锋) 于2020年4月27日周一 下午8:27写道: > >> 你好,在测试ShardingSphere的sharding proxy时,使用客户端访问时,总需要先使用use 到数据库,才能执行查询。 >> >> >> >>

Re: 客户端访问sharding proxy时,需要先use

2020-04-27 Thread zhangli...@apache.org
Welcome to Apache ShardingSphere community, communication for English only, could you translate the email? -- Liang Zhang (John) Apache ShardingSphere & Dubbo rainbpfjin(金沛锋) 于2020年4月27日周一 下午8:27写道: > 你好,在测试ShardingSphere的sharding proxy时,使用客户端访问时,总需要先使用use 到数据库,才能执行查询。 > > > >

客户端访问sharding proxy时,需要先use

2020-04-27 Thread 金沛锋
你好,在测试ShardingSphere的sharding proxy时,使用客户端访问时,总需要先使用use 到数据库,才能执行查询。 [cid:image001.png@01D61CBD.B89FB7C0]

Re: Talking about remove branch proxy-with-netty-backend

2020-03-10 Thread zhangli...@apache.org
Done. -- Liang Zhang (John) Apache ShardingSphere & Dubbo Hongtao Gao 于2020年3月10日周二 下午2:59写道: > go for it  > > zhangli...@apache.org 于2020年3月10日周二 下午1:41写道: > > > The branch proxy-with-netty-backend is a too old branch which is > > establishi

Re: Talking about remove branch proxy-with-netty-backend

2020-03-10 Thread Hongtao Gao
go for it  zhangli...@apache.org 于2020年3月10日周二 下午1:41写道: > The branch proxy-with-netty-backend is a too old branch which is > establishing before we enter incubator. > This branch is for using netty to connect MySQL. The feature is not > completed and it seems no further

Re:Talking about remove branch proxy-with-netty-backend

2020-03-10 Thread KimmKing
+1 to remove it now After orchestration tasks,I will pick this feature enhancement. Or any buddy is interested in it, we could discuss details after it closed and make a plan to launch a new one. At 2020-03-10 13:41:23, "zhangli...@apache.org" wrote: >The branch proxy-with-

Re: Talking about remove branch proxy-with-netty-backend

2020-03-09 Thread Sheng Wu
Good for me, Remove please. Sheng Wu 吴晟 Twitter, wusheng1108 zhangli...@apache.org 于2020年3月10日周二 下午1:41写道: > The branch proxy-with-netty-backend is a too old branch which is > establishing before we enter incubator. > This branch is for using netty to connect MySQL. Th

Talking about remove branch proxy-with-netty-backend

2020-03-09 Thread zhangli...@apache.org
The branch proxy-with-netty-backend is a too old branch which is establishing before we enter incubator. This branch is for using netty to connect MySQL. The feature is not completed and it seems no further update plan by the author. It is difficult to merge master now for code conflict reason. I

Re:Re: Re: use sharding-proxy, query is slow

2020-01-20 Thread KimmKing
Hi, Daniel, IMO, SQL like your case will be routed to any one database, then the performance with sharding-proxy is almost equals with direct jdbc. I guess 4 point maybe cause this issue: 1. system load and instances, just like yonglun talk about. 2. network issues, such as DNS etc. 3. router

Re: Re: use sharding-proxy, query is slow

2020-01-19 Thread Zhang Yonglun
ng...@apache.org> > Date: 2020-01-20 12:24 > To: dev<mailto:dev@shardingsphere.apache.org> > Subject: Re: Re: use sharding-proxy, query is slow > The hostname xxx you omitted is what I want to see. Just tell me how many > hosts or how may MySQL instance there are. &

Re: Re: use sharding-proxy, query is slow

2020-01-19 Thread Zhang Yonglun
月20日周一 下午12:14写道: > Hi: >thx for you reply. > > 1. What's the cost when mysql client query database1 directly without > sharding-proxy? (use member_id as where condition) > it cost 8 seconds > the cost means the SQL query time spent, i use the command like " mys

Re: use sharding-proxy, query is slow

2020-01-19 Thread Zhang Yonglun
1. What's the cost when mysql client query database1 directly without sharding-proxy? (use member_id as where condition) 2. Is 'member_id' the primary key? 3. Please show me the config-sharding.yaml and server.yaml. -- Zhang Yonglun Apache ShardingSphere Daniel Yu 于2020年1月20日周一 上午11:17写道

use sharding-proxy, query is slow

2020-01-19 Thread Daniel Yu
from member where member_id = 'abc' " on database 1 ,it cost 8s, when i used proxy query on 16 databases by the same sql , it cost 60s , as far as I know the proxy used threadpool to Parallel execution the query , but the query is slow , why?

Re:Sharding-Proxy-mysql8.0.18-BUG

2019-12-12 Thread Juan Pan
Hi English communication is prerequisite. Could you use 4.0.0-RC3 to test? Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) email: panj...@apache.org On 12/12/2019 16:05,文光临 wrote: 您好! Sharding-Proxy 连接 mysql8.0.18 报错,读取元数据出错。 报错信息如下(

Re: Sharding-Proxy-mysql8.0.18-BUG

2019-12-12 Thread zhangli...@apache.org
Please use English, thank you. -- Liang Zhang (John) Apache ShardingSphere & Dubbo 文光临 于2019年12月12日周四 下午5:56写道: > 您好! > Sharding-Proxy 连接 mysql8.0.18 报错,读取元数据出错。 > 报错信息如下(配置和报错日志 在附件。多谢了) > >[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.Ass

Sharding-Proxy-mysql8.0.18-BUG

2019-12-12 Thread 文光临
您好! Sharding-Proxy 连接 mysql8.0.18 报错,读取元数据出错。 报错信息如下(配置和报错日志 在附件。多谢了) [INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 30 [INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING

Re: Sharding-Proxy for mgr/pxc

2019-11-24 Thread Zero Dai
Thanks for your response, I recently set up a highly available MySQL database cluster on K8s. I chose MGR as the cluster solution. At the proxy layer, I chose ProxySQL, because as far as I know, Sharding-Proxy does not currently support dynamics. Master-slave clustering scheme. Zhang Yonglun 于

Re: Sharding-Proxy for mgr/pxc

2019-11-22 Thread Zhang Yonglun
日周六 下午1:14写道: > Does Sharding-Proxy support the mgr or pxc cluster? >

Sharding-Proxy for mgr/pxc

2019-11-22 Thread Zero Dai
Does Sharding-Proxy support the mgr or pxc cluster?

Re: (Resend)issues for Proxy with Postgres

2019-11-18 Thread Raigor Jiang
Raigor 于2019年11月19日周二 上午10:51写道: Hi, everyone, I found some issues with Sharding-Proxy when using postgres and collected as follows: First, I prepared an environment like: https://github.com/apache/incubator-shardingsphere/issues/3419, my postgres version is 12.0, and use the latest Proxy s

Re: (Resend)issues for Proxy with Postgres

2019-11-18 Thread Zhang Yonglun
new issues on GitHub for 2 and 3. Zhang Yonglun Apache ShardingSphere Jiang Raigor 于2019年11月19日周二 上午10:51写道: > Hi, everyone, > > I found some issues with Sharding-Proxy when using postgres and collected > as follows: > > First, I prepared an environment like: > > h

Re: Sharding-Proxy for mgr/pxc

2019-11-18 Thread Zhang Yonglun
Not yet. Can I ask what's your MGR solution for now? Middleware or VIP? Zhang Yonglun Apache ShardingSphere Zero Dai 于2019年11月19日周二 下午1:11写道: > Does Sharding-Proxy support the mgr or pxc cluster? >

Re: (Resend)issues for Proxy with Postgres

2019-11-18 Thread 王海涛 王
Hi! The same error when using preparedStatement to connect proxy! 获取 Outlook for Android<https://aka.ms/ghei36> From: Jiang Raigor Sent: Tuesday, November 19, 2019 9:12:37 AM To: dev@shardingsphere.apache.org Subject: (Resend)issues for Proxy with Po

(Resend)issues for Proxy with Postgres

2019-11-18 Thread Jiang Raigor
Hi, everyone, I found some issues with Sharding-Proxy when using postgres and collected as follows: First, I prepared an environment like: https://github.com/apache/incubator-shardingsphere/issues/3419, my postgres version is 12.0, and use the latest Proxy source code. (commit 962a9656

(Resend) Issues for Proxy with Postgres

2019-11-18 Thread raigor_dev
Sorry, due to the reason of the mailbox, the content of the previously mail is lost, now resend. Hi, everyone, I found some issues with Sharding-Proxy when using postgres and collected as follows: First, I prepared an environment like: https://github.com

issues for Proxy with Postgres

2019-11-17 Thread raigor . jiang

回复:请教一个sharding-proxy的配置问题

2019-11-04 Thread Juan Pan
/community/en/contribute/subscribe/ Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere 在2019年11月1日 11:02,edwardhuang<15372048...@163.com> 写道: hello,sharding-proxy怎么实现 比如分表规则: 日期(mmdd+userid%8 这个策略,能否给一个案例,这个在实际生产中非常常见,万分感谢 edward huang

Re: proxy

2019-11-03 Thread Juan Pan
Please treat proxy as a regular DB to use it. Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 11/03/2019 09:34, 张宇波 wrote: Dear How do I use springboot2 to connect to proxy

??????proxy

2019-11-03 Thread ??????
---- ??:"??"

Re: proxy

2019-11-02 Thread zhangli...@apache.org
Hello, same question we can discuss in one thread, thank you. -- Liang Zhang (John) Apache ShardingSphere & Dubbo 张宇波 于2019年11月3日周日 上午9:27写道: > Dear > > > How do I use springboot2 to connect to proxy

Re: How to apply sharding on all tables globally by using proxy

2019-07-22 Thread Eric
Hi Sion, Thank you very much for your prompt feedback. Please consider it as a future feature. It can be very useful when there are a lot of tables or similar to some auto sharding applications. Regards, Eric Poon On Mon, Jul 22, 2019 at 9:20 AM Sion Yang wrote: > Hi Eric Poon, > > >

Re:How to apply sharding on all tables globally by using proxy

2019-07-21 Thread Sion Yang
Hi Eric Poon, ShardingSphere requires users to configure which tables need to be shard currently. If there are no sharding-rule for sharding tables, ShardingSphere will use default-datasource to execute it. So it should not work with dynamic table names for now. -- Yi Yang(Sion) Apache

How to apply sharding on all tables globally by using proxy

2019-07-19 Thread Eric
Hi, I am trying to apply sharding on all tables on the same key column exists on all tables. The objective is evenly distribute the records on several database instances. For example, even no. records on one server. After trying around several hours, seems it's not possible to define database

Broadcast create tables through ShardingSphere Proxy on all sharded databases

2019-07-18 Thread Eric
Hi, I am trying out the ShardingSphere features. I have two questions on admin related tasks. I tried different configurations but in vain. Very appreciate for anyone could help. 1) How to configure the yaml files such that I can create tables on all sharded databases through proxy

[GitHub] [incubator-shardingsphere] cherrylzhao opened a new issue #2303: sharding-proxy does not support COM_STMT_RESET command of mySQL

2019-04-29 Thread GitBox
cherrylzhao opened a new issue #2303: sharding-proxy does not support COM_STMT_RESET command of mySQL URL: https://github.com/apache/incubator-shardingsphere/issues/2303 when I try to send prepare statement with python mysql connector. it block it at `COM_STMT_RESET command can

[GitHub] [incubator-shardingsphere] tianyijushi commented on issue #2301: sharding-proxy doesn't has some tables in the config default datasource, why?

2019-04-29 Thread GitBox
tianyijushi commented on issue #2301: sharding-proxy doesn't has some tables in the config default datasource,why? URL: https://github.com/apache/incubator-shardingsphere/issues/2301#issuecomment-487536159 sharding-proxy-3.0.0

[GitHub] [incubator-shardingsphere] tianyijushi commented on issue #2301: sharding-proxy doesn't has some tables in the config default datasource, why?

2019-04-29 Thread GitBox
tianyijushi commented on issue #2301: sharding-proxy doesn't has some tables in the config default datasource,why? URL: https://github.com/apache/incubator-shardingsphere/issues/2301#issuecomment-487537151 @cherrylzhao sharding-proxy-3.0.0

[GitHub] [incubator-shardingsphere] cherrylzhao commented on issue #2301: sharding-proxy doesn't has some tables in the config default datasource, why?

2019-04-29 Thread GitBox
cherrylzhao commented on issue #2301: sharding-proxy doesn't has some tables in the config default datasource,why? URL: https://github.com/apache/incubator-shardingsphere/issues/2301#issuecomment-487531131 hi,please let me know the proxy version you used

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487523678  I'll have a shot

[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487522914 This error may happens in 3.1.0. Can you try 4.0.0-RC1

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487522617 ![image](https://user-images.githubusercontent.com/37434384/56888991-e83e7200-6aa7-11e9-8fec

[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487515178 or master-slave rule which master and slave share the same datasource

[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512597 `insert into info_title values(1521846697390,'搜索结果:\'swatch 、\'');` This SQL can't

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487513893 or I can make a sharding rule like %1

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512245 i did a little test. It seems that all the error sql contains **\'** character

[GitHub] [incubator-shardingsphere] Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512245 i did a little test. It seems that all the error sql contains **\\'** character

[GitHub] [incubator-shardingsphere] Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487512245 i did a little test. It seems that all the error sql contains **\'** character

[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487504024 @Zatomsmasher This is a parsing problem. Are there any more SQLs that can't execute? We may fix

[GitHub] [incubator-shardingsphere] tianyijushi opened a new issue #2301: sharding-proxy doesn't has some tables in the config default datasource, why?

2019-04-29 Thread GitBox
tianyijushi opened a new issue #2301: sharding-proxy doesn't has some tables in the config default datasource,why? URL: https://github.com/apache/incubator-shardingsphere/issues/2301 ## Question i has three databases,the config-sharding.yaml like that : schemaName: sharding_db

[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487502274 @Zatomsmasher I got it . These two SQLs are not identical

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487502249 @tuohai666 CREATE TABLE `info_title` ( `id` bigint(20) NOT NULL, `name` varchar

[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487501774 @Zatomsmasher Please describe table

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487501023 @tuohai666 MySQL Community Server 5.5.52 ![Uploading image.png

[GitHub] [incubator-shardingsphere] Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher edited a comment on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487501023 @tuohai666 MySQL Community Server 5.5.52 ![image](https://user

[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
tuohai666 commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487492861 @Zatomsmasher I have tried the SQL in raw database and got a error message: ``` insert

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487488976 @tuohai666 1.same error 2.worked well 3. insert into info_title values

[GitHub] [incubator-shardingsphere] Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system

2019-04-29 Thread GitBox
Zatomsmasher commented on issue #2277: ERROR when tried to import sql file into a sharding-proxy system URL: https://github.com/apache/incubator-shardingsphere/issues/2277#issuecomment-487489206 @tuohai666 sry for the delay

  1   2   3   >