[MXS-3398] Auto-adjust MaxScale parameters according to server settings Created: 2021-02-04  Updated: 2022-05-24  Resolved: 2022-05-23

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: None
Fix Version/s: 22.08.0

Type: New Feature Priority: Major
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-155, MXS-SPRINT-156, MXS-SPRINT-157

 Description   

Some MaxScale parameters depend upon server parameters in such a way that if a MaxScale parameter is configured without any regard to the server parameters(s) on which it depends, then MaxScale may not function properly.

For instance, the persistmaxtime specifies how long a connection can stay in the pool before it is discarded. However, it makes no sense with the value of persistmaxtime being larger than wait_timeout of the server. The former should always be smaller than the latter.

MaxScale should sniff the server parameters and, if necessary, adjust any MaxScale parameters that are in conflict with the server ones. For some cases it should be possible to specify that the MaxScale parameter is directly derived from a particular server parameter.

The sniffing should be performed at regular intervals, so that any changes made at runtime to the server parameters are automatically taken into account.


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