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
