For stateful database connections between applications and ShardingSphere, it is always hard to scale the proxy to handle more long connections. If we scale the proxy horizontally, we cannot move the current long connection causing heavy load to move to new instances. The complexity and cost brought by this solution are way higher than letting it go. If we scale the proxy vertically, we can increase the CPU threshold and resolve overhead caused by computing. However, this idea cannot move to memory, since currently JVM is not capable of adjusting heap memory size in runtime.
For stateful database connections between applications and ShardingSphere, it is always hard to scale the proxy to handle more long connections. If we scale the proxy horizontally, we cannot move the current long connection causing heavy load to move to new instances. The complexity and cost brought by this solution are way higher than letting it go. If we scale the proxy vertically, we can increase the CPU threshold and resolve overhead caused by computing. However, this idea cannot move to memory, since currently JVM is not capable of adjusting heap memory size in runtime.