makssent commented on issue #37569: URL: https://github.com/apache/shardingsphere/issues/37569#issuecomment-3696899399
I want to slightly adjust the overall picture. As I understand it, there are two types of connections: **frontend** and **backend**. Frontend connections describe how the client connects to the Proxy: for example, with `threads = 200`, 200 connections to the Proxy are created. Then the Proxy internally looks at the configuration where the limits for backend connections are defined. If `maxPoolSize = 200` and `minPoolSize = 200` are set there, the Proxy creates 200 connections to each node. As a result, the load is actually parallelized with 200 connections per node, whereas in the single setup the same 200 connections work against only one database, which makes single roughly two times slower than the cluster. P.S. If `minPoolSize` is not set, the Proxy may create fewer connections (for example, around 100) and still work fine, but to clearly observe a performance gain, the number of backend connections needs to be comparable to the number of connections in the single setup multipl -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
