Thanks Juan. I saw some blog posts that said shardingsphere is about a 20~30% performance penalty compared with direct connections. Could you tell me about internals or why jdbc shows more good performance?
On Tue, Oct 4, 2022 at 8:16 PM Juan Pan <panj...@apache.org> wrote: > Jdbc is 30-40% higher than proxy based on different scenarios [1]. > However, since `proxy + mysql` is similar with other distributed database > architecture, > that means proxy has the similar performance with other sharding databases > and is ready for production env (from the feedback of our community [2, 3]). > > > [1] > https://shardingsphere.apache.org/document/current/en/test-manual/performance-test/benchmarksql-proxy-sharding-test/ > [2] https://shardingsphere.apache.org/blog/en/material/ > [3] https://www.mysql.com/customers/view/?id=1461 > > ------------------------------------------------------------------------------ > Trista Pan > Twitter & Github: tristaZero > > > > > On 10/4/2022 19:05，Edward J. Yoon<edwardy...@apache.org> wrote： > Just curious about whether there's some performance difference between jdbc > vs. proxy. > > On Tue, Oct 4, 2022 at 8:01 PM Edward J. Yoon <edwardy...@apache.org> > wrote: > > Currently there are 4 set consists of single master and single slave, and > one integrated db based on multi source replication. % 4 modular sharding > is used at application level. So, I'm looking for the elastic scalability, > easy-to-use/maintenance, and the high performance middleware like > shardingsphere. > > On Tue, Oct 4, 2022 at 7:50 PM Juan Pan <panj...@apache.org> wrote: > > Hello Edward J. Yoon, > > > adopting shardingshpere for the order database that requires to cover > heavy read and write. > > > Does that mean you want ShardingSphere to do the read-write-splitting > function? > > > sharded mysql cluster with division method > > > You already sharded your mysql database cluster? Do you plan to let > ShardingSphere help you manage all the mysql shards? > > > ShardingSphere currently offers two clients: ShardingSphere-JDBC (for > Java APP) and ShardingSphere-Proxy. > In your case, I recommend deploying ShardingSphere-Proxy[1] to help you > with read-write-splitting or sharding management. > Then, for your Python workload, simply connect to ShardingSphere-Proxy > using the MySQLdb library. > > Best wishes, > Trista > > > [1] > > https://shardingsphere.apache.org/document/current/en/quick-start/shardingsphere-proxy-quick-start/ > > > ------------------------------------------------------------------------------ > Trista Pan > Twitter & Github: tristaZero > > > > > On 10/4/2022 18:29，Edward J. Yoon<edwardy...@apache.org> wrote： > Hello, I am edwardyoon, currently working at Delivery Hero. From there, I > am considering adopting shardingshpere for the order database that > requires > to cover heavy read and write. Our system is consists of django and > sharded > mysql cluster with division method at this moment. I’d like to know > whether > there is a reliable django library that can be used for real production. > > Thanks. > > -- > Best Regards, Edward J. Yoon > > > > -- > Best Regards, Edward J. Yoon > > > > -- > Best Regards, Edward J. Yoon > -- Best Regards, Edward J. Yoon
