[MXS-1548] Shared connection Created: 2017-11-29  Updated: 2022-06-05  Resolved: 2019-05-30

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbbackend
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: dapeng huang Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None


 Description   

In many environment, the latency between client and db is too high, to get better performance client need spawn more connections to cope with latency,but this may lead to contention problems.

Put a proxy (mxs) between client and db, let proxy more closer to db(latency between proxy and db should be much more lower than latency between client and proxy), let multiple client connections share the same backend connection in order to reduce the contention;

if can keep session state (session variables, temproary table, transaction ...) consistant will be better;



 Comments   
Comment by markus makela [ 2017-11-29 ]

This is known as connection pooling. The current recommended solution is to use a client side connection pool as that works well with MaxScale.

Generated at Thu Feb 08 04:07:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.