[MXS-2505] connection_keepalive independent from traffic Created: 2019-05-22  Updated: 2024-01-04  Resolved: 2019-12-13

Status: Closed
Project: MariaDB MaxScale
Component/s: Core, readwritesplit
Affects Version/s: None
Fix Version/s: 6.0.0

Type: New Feature Priority: Major
Reporter: Claudio Nanni Assignee: markus makela
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Problem/Incident
causes MXS-2500 connection keep alive still closing a... Closed
Epic Link: Router Improvements
Sprint: MXS-SPRINT-96

 Description   

Manual says:

connection_keepalive
"The parameter value is the interval in seconds between each keepalive ping. A keepalive ping will be sent to a backend server if the connection is idle and it has not been used within n seconds where n is greater than or equal to the value of connection_keepalive. The keepalive pings are only sent when the client executes a query."

https://mariadb.com/kb/en/mariadb-maxscale-23-readwritesplit/#connection_keepalive

I think that the The keepalive pings are only sent when the client executes a query is counter intuitive.
In my opinion connection_keepalive should work especially when no queries are executed.



 Comments   
Comment by markus makela [ 2019-12-13 ]

Made the connection_keepalive parameter a common service parameter (all routers can use it) and added support for idle session keepalive (no queries are needed to keep all connections alive).

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