[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. |