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
