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
