Module Parameters for MariaDB MaxScale 22.08
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Reference for MariaDB MaxScale 22.08
Topics on this page:
Overview
MariaDB MaxScale 22.08 supports many module parameters.
Reference material is available for MariaDB MaxScale 22.08.
MariaDB MaxScale 22.08 Module Parameters
The Module Parameters supported by MariaDB MaxScale 22.08 are listed below.
To see Module Parameters supported in other versions, see "Module Parameters by MariaDB MaxScale Version".
MariaDB Monitor (mariadbmon)
The parameters for mariadbmon:
Parameter | Description |
---|---|
Type: bool, default value: True | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: count, default value: 1 | |
Type: duration, default value: 3000ms | |
Type: duration, default value: 3000ms | |
Type: duration, default value: 3000ms | |
Type: enum, default value: none | |
Type: string | |
Type: string, default value: /cmapi/0.4.0 | |
Type: count, default value: 8640 | |
Type: path | |
Type: duration, default value: 0ms | |
Type: string | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: enum_ | |
Number of consecutive times MaxScale can fail to reach the Primary Server before it considers it down | |
Type: duration, default value: 90000ms | |
Type: bool, default value: True | |
Type: duration, default value: 28800000ms | |
Type: bool, default value: True | |
Type: enum_ | |
Type: duration, default value: 10000ms | |
Interval of time for performing monitoring checks | |
Type: password | |
Type: path | |
Type: count, default value: 4444 | |
Type: bool, default value: False | |
Type: password, default value: ***** | |
Type: string | |
Type: string | |
Type: int, default value: -1 | |
Type: duration, default value: 90000ms | |
Type: serverlist | |
Type: serverlist | |
Type: enum_ | |
Type: bool, default value: True | |
Type: path | |
Type: count, default value: 22 | |
Type: duration, default value: 10000ms | |
Type: string | |
Type: bool, default value: False | |
Type: duration, default value: 90000ms | |
Type: string | |
Type: bool, default value: True |
Read/Write Split Router (readwritesplit)
The parameters for readwritesplit:
Parameter | Description |
---|---|
Type: bool, default value: False | |
Configures read causality, reads subsequent to writes issued in manner to reduce replication lag | |
Timeout for synchronization of the Primary Server with a Replica Server during causal reads | |
Type: duration, default value: 300000ms | |
Type: duration, default value: 0ms | |
Retry queries that fail to route due to connection issues | |
Timeout for retrying queries that fail to route due to connection issues | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: duration, default value: -1ms | |
Type: bool, default value: False | |
Type: bool, default value: True | |
Type: bool, default value: True | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: enum, default value: fail_ | |
Reconnect to the Primary Server if it changes mid-session | |
Type: count, default value: 0 | |
Type: count, default value: 50 | |
Maximum number of connections the router session can use to connect to Replica Servers | |
Number of seconds a Replica Server is allowed to fall behind the Primary Server | |
Type: duration, default value: 60000ms | |
Type: duration, default value: 0ms | |
Type: bool, default value: False | |
Type: password | |
Type: bool, default value: True | |
Type: enum, default value: primary | |
Type: int, default value: -1 | |
Type: bool, default value: True | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: count, default value: 255 | |
Criteria the router uses to select Replica Servers in load balancing read operations | |
Routes multi-statement queries to the Primary Server | |
Routes statements to the Primary Server | |
Type: bool, default value: True | |
Replays in progress transactions that fail on a different Server | |
Maximum number of times to attempt to replay failed transactions | |
Type: enum, default value: full | |
Maximum size in bytes permitted for transaction replays | |
Maximum number of times the router attempts to replay transactions in the event that the transaction fails due to deadlocks | |
Type: bool, default value: False | |
Type: duration, default value: 0ms | |
Where the router sends session variable queries | |
Type: string | |
Type: path | |
Type: enum, default value: add_ | |
Type: string |
MariaDB Protocol
The parameters for MariaDBProtocol:
Parameter | Description |
---|---|
Type: string, default value: :: | |
Type: string | |
Type: string | |
Type: path | |
Type: count, default value: 0 | |
Type: module | |
Type: service | |
Type: string | |
Type: enum, default value: default | |
Type: bool, default value: False | |
Type: path | |
Type: path | |
Type: path | |
Type: count, default value: 9 | |
Type: string | |
Type: string | |
Type: path | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: enum, default value: MAX | |
Type: path |
Read Connection Router (readconnroute)
The parameters for readconnroute:
Parameter | Description |
---|---|
Type: bool, default value: False | |
Type: duration, default value: 300000ms | |
Type: duration, default value: 0ms | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: duration, default value: -1ms | |
Type: bool, default value: True | |
Type: bool, default value: True | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Route read operations to the Primary Server or whether it only accepts write operations | |
Type: count, default value: 0 | |
Type: duration, default value: 0ms | |
Type: count, default value: 50 | |
Type: duration, default value: 60000ms | |
Type: duration, default value: 0ms | |
Type: password | |
Type: bool, default value: True | |
Type: enum, default value: primary | |
Type: int, default value: -1 | |
Type: enum_ | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: True | |
Type: string | |
Type: path | |
Type: enum, default value: add_ | |
Type: string |
MaxScale
The parameters for maxscale:
Parameter | Description |
---|---|
Type: bool, default value: True | |
Type: bool, default value: True | |
Type: bool, default value: True | |
Type: string, default value: 127.0.0.1 | |
Type: enum, default value: auto | |
Type: string | |
Type: bool, default value: True | |
Type: string | |
Type: string | |
Type: string | |
Type: int, default value: 8989 | |
Type: bool, default value: True | |
Type: path | |
Type: path | |
Type: path | |
Type: path | |
Type: enum, default value: MAX | |
Type: string | |
Type: duration, default value: 10000ms | |
Type: duration, default value: 10000ms | |
Type: duration, default value: 10000ms | |
Type: stringlist, default value: [] | |
Type: string | |
Type: duration, default value: 5000ms | |
Type: password, default value: ***** | |
Type: duration, default value: 10000ms | |
Type: string | |
Type: string | |
Type: enum, default value: never | |
Type: enum, default value: none | |
Type: bool, default value: True | |
Type: string | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: True | |
Type: throttling, default value: {'count': 10, 'suppress': 10000, 'window': 1000} | |
Type: bool, default value: False | |
Type: bool, default value: True | |
Type: int, default value: 10 | |
Type: size, default value: 0 | |
Type: bool, default value: True | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: bool, default value: True | |
Type: string, default value: qc_ | |
Type: string | |
Type: size, default value is 15% of available memory | |
Type: int, default value: 1 | |
Type: duration, default value: 5000ms | |
Type: duration, default value: 0ms | |
Type: int, default value: 20 | |
Type: count, default value: 10 | |
Type: count, default value: 0 | |
Type: count, default value: 0 | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: enum, default value: default | |
Type: bool, default value: False | |
Type: count, default value is based on cpu count | |
Type: duration, default value: 0ms | |
Type: duration, default value: 30000ms | |
Type: size, default value: 65536 | |
Type: size, default value: 1024 |
Server Objects
The parameters for server objects:
Parameter | Description |
---|---|
Type: string | |
Type: string | |
Type: disk_ | |
Type: count, default value: 0 | |
Type: count, default value: 0 | |
Type: string | |
Type: string | |
Type: duration, default value: 0ms | |
Type: count, default value: 0 | |
Type: count, default value: 3306 | |
Type: int, default value: 0 | |
Type: string | |
Type: bool, default value: False | |
Type: enum, default value: primary | |
Type: string | |
Type: bool, default value: False | |
Type: path | |
Type: path | |
Type: path | |
Type: count, default value: 9 | |
Type: string | |
Type: path | |
Type: bool, default value: False | |
Type: bool, default value: False | |
Type: enum, default value: MAX | |
Type: string, default value: server |