Browse the comprehensive list of MariaDB MaxScale configuration parameters. This reference details valid values, default settings, and dynamic capabilities for servers, services, and monitors.
Global Settings
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Values: GET, PUT, POST
Type: string
Mandatory: No
Dynamic: Yes
Default: /var/log/maxscale/admin_audit.csv
Type:
Mandatory: No
Dynamic: No
Default: true
Type:
Mandatory: No
Dynamic: No
Default: true
Type:
Mandatory: No
Dynamic: No
Default: true
Type: string
Mandatory: No
Dynamic: No
Default: "127.0.0.1"
Type:
Mandatory: No
Dynamic: No
Values: auto, HS256, HS384
Type: string
Mandatory: No
Dynamic: No
Default: maxscale
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: No
Default: 24h
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: number
Mandatory: No
Dynamic: No
Default: 8989
Type: string
Mandatory: No
Dynamic: No
Default: %
Type:
Mandatory: No
Dynamic: No
Default: true
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type: string
Mandatory: No
Dynamic: No
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: No
Values: MAX, TLSv1.0, TLSv1.1
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type: string list
Values: all or list of auto tunable parameters, separated by ,
Default: No
Mandatory: No
Type: path
Mandatory: No
Dynamic: No
Default: /var/cache/maxscale
Type: monitor
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: No
Default: mysql
Type:
Mandatory: No
Dynamic: Yes
Default: 5s
Type: password
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: path
Mandatory: No
Dynamic: No
Default: OS Dependent
Type:
Default: true
Dynamic: No
Type: path
Mandatory: No
Dynamic: No
Default: /var/lib/maxscale
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Values: on_close, on_error, never
Type: path
Mandatory: No
Dynamic: No
Default: /usr/bin
Type: integer
Default: 128
Dynamic: Yes
Type:
Dynamic: Yes
Values: none, file, kmip, vault
Type: path
Mandatory: No
Dynamic: No
Default: /var/lib/maxscale/
Type: path
Mandatory: No
Dynamic: No
Default: OS Dependent
Type:
Mandatory: No
Dynamic: No
Default: true
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: number, ,
Mandatory: No
Dynamic: Yes
Default: 10, 1000ms, 10000ms
Type:
Mandatory: No
Dynamic: No
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: path
Mandatory: No
Dynamic: No
Default: /var/log/maxscale
Type: number
Mandatory: No
Dynamic: Yes
Default: 10
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: path
Mandatory: No
Dynamic: No
Default: /etc/maxscale.modules.d/
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Default: true
Dynamic: No
Type: path
Mandatory: No
Dynamic: No
Default: /var/lib/maxscale/maxscale.cnf.d/
Type: path
Mandatory: No
Dynamic: No
Default: /run/maxscale
Type:
Mandatory: No
Dynamic: Yes
Default: System Dependent
Type: number
Mandatory: No
Dynamic: No
Default: 1
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type:
Mandatory: No
Dynamic: Yes
Default: 0s
Type: number
Mandatory: No
Dynamic: Yes
Default: 20
Type: number
Mandatory: No
Dynamic: Yes
Default: 10
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type: path
Mandatory: No
Dynamic: No
Default: /usr/share/maxscale
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: No
Values: default, oracle
Type:
Mandatory: No
Dynamic: No
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: number or auto
Mandatory: No
Dynamic: No
Default: auto
Type: positive integer
Default: 256
Dynamic: No
Type: path
Mandatory: No
Dynamic: No
Type:
Mandatory: No
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: 0s
Type:
Mandatory: No
Dynamic: Yes
Default: 30s
Type:
Mandatory: No
Dynamic: Yes
Default: 65536
Type:
Mandatory: No
Dynamic: Yes
Default: 1024
Listener
Type: string
Mandatory: No
Dynamic: No
Default: "::"
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type: stringlist
Default: character_set_client=auto,character_set_connection=auto,character_set_results=auto,max_allowed_packet=auto,system_time_zone=auto,time_zone=auto,tx_isolation=auto,maxscale=auto
Dynamic: Yes
Mandatory: No
Type: number
Mandatory: Yes, if socket is not provided.
Dynamic: No
Default: 0
Type: protocol
Mandatory: No
Dynamic: No
Default: mariadb
Type: service
Mandatory: Yes
Dynamic: No
Type: string
Mandatory: Yes, if port is not provided.
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Values: default, oracle
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Server
Type: string
Mandatory: Yes, if socket is not provided.
Dynamic: Yes
Default: ""
Type: Custom
Mandatory: No
Dynamic: No
Default: None
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: 0s
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type: number
Mandatory: No
Dynamic: Yes
Default: 3306
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type: string
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Values: primary, secondary
Type: string
Default: None
Dynamic: Yes
Type: string
Mandatory: Yes, if address is not provided.
Dynamic: Yes
Default: ""
Service
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: monitor
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: 300s
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: filter list
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: -1s
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type: number
Mandatory: No
Dynamic: Yes
Default: 50
Type:
Mandatory: No
Dynamic: Yes
Default: 60s
Type:
Mandatory No
Dynamic: Yes
Default: 0s
Type: string
Mandatory: Yes
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: number
Mandatory: No
Dynamic: Yes
Default: -1
Type: router
Mandatory: Yes
Dynamic: No
Type: server list
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: target list
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: Yes
Dynamic: Yes
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: No
Values: add_when_load_ok, file_only_always
Type: string
Mandatory: No
Dynamic: No
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: 0s
Settings for File-based Key Manager
Type: path
Mandatory: Yes
Dynamic: Yes
Settings for HashiCorp Vault Key Manager
Type: path
Default: ""
Dynamic: Yes
Type: string
Default: localhost
Dynamic: Yes
Type: string
Default: secret
Dynamic: Yes
Type: integer
Default: 8200
Dynamic: Yes
Type:
Default: 30s
Dynamic: Yes
Type:
Default: true
Dynamic: Yes
Type: password
Mandatory: Yes
Dynamic: Yes
Settings for KMIP Key Manager
Type: path
Default: ""
Dynamic: Yes
Type: path
Mandatory: Yes
Dynamic: Yes
Type: string
Mandatory: Yes
Dynamic: Yes
Type: path
Mandatory: Yes
Dynamic: Yes
Type: integer
Mandatory: Yes
Dynamic: Yes
Settings for TLS/SSL Encryption
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type: number
Mandatory: No
Dynamic: Yes
Default: 9
Type: string
Mandatory: No
Dynamic: Yes
Default: ""
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: No
Values: MAX, TLSv1.0, TLSv1.1
Settings
Type: number
Mandatory: No
Dynamic: No
Default: 0
Type:
Mandatory: No
Dynamic: No
Default: true
Type:
Mandatory: No
Dynamic: No
Default: false
Settings
Type: path
Mandatory: No
Dynamic: No
Default: Kerberos Default
Type: string
Mandatory: No
Dynamic: No
Default: mariadb/localhost.localdomain
Settings
Type:
Mandatory: No
Dynamic: No
Default: false
Settings
Type:
Mandatory: No
Dynamic: No
Values: none, mariadb
Type: path
Mandatory: No
Dynamic: No
Default: None
Type:
Mandatory: No
Dynamic: No
Values: password, password_2FA, suid
Type:
Mandatory: No
Dynamic: No
Default: false
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: None
Settings
Type: count
Mandatory: No
Dynamic: Yes
Default: 0
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: No
Values: ignorecase, case, extended
Type:
Mandatory: No
Dynamic: Yes
Default: 60s
Settings
Type:
Mandatory: No
Dynamic: No
Values: never, read_only_transactions, all_transactions
Type:
Mandatory: No
Dynamic: No
Values: shared, thread_specific
Type:
Mandatory: No
Dynamic: No
Default: true
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type:
Mandatory: No
Dynamic: No
Default: true
Type:
Mandatory: No
Dynamic: No
Default: 0s (no limit)
Type:
Mandatory: No
Dynamic: No
Values: never, current
Type: count
Mandatory: No
Dynamic: No
Default: 0 (no limit)
Type: count
Mandatory: No
Dynamic: No
Default: 0 (no limit)
Type:
Mandatory: No
Dynamic: No
Default: 0 (no limit)
Type:
Mandatory: No
Dynamic: No
Default: 0 (no limit)
Type: path
Mandatory: No
Dynamic: Yes
Default: "" (no rules)
Type:
Mandatory: No
Dynamic: Yes
Values: assume_cacheable, verify_cacheable
Type:
Mandatory: No
Dynamic: No
Default: 0s (no limit)
Type: string
Mandatory: No
Dynamic: No
Default: storage_inmemory
Type: string
Mandatory: No
Dynamic: No
Default:
Type:
Mandatory: No
Dynamic: No
Default: 5s
Type:
Mandatory: No
Dynamic: No
Values: mixed, isolated
storage_memcached
Type:
Mandatory: No
Dynamic: No
Default: 1Mi
Type: The Memcached server address specified as host[:port]
Mandatory: Yes
Dynamic: No
storage_redis
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: The Redis server address specified as host[:port]
Mandatory: Yes
Dynamic: No
Type:
Mandatory: No
Dynamic: No
Default: false
Type: Path to existing readable file.
Mandatory: No
Dynamic: No
Default: ""
Type: Path to existing readable file.
Mandatory: No
Dynamic: No
Default: ""
Type: Path to existing readable file.
Mandatory: No
Dynamic: No
Default: ""
Type: string
Mandatory: No
Dynamic: No
Default: ""
Settings
Type: string
Mandatory: Yes
Dynamic: Yes
Settings
Type: string
Mandatory: No
Dynamic: Yes
Default: s3.amazonaws.com
Type: string
Mandatory: No
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: integer
Mandatory: No
Dynamic: Yes
Default: 0
Type: integer
Mandatory: No
Dynamic: Yes
Default: 0
Type: string
Mandatory: No
Dynamic: Yes
Default: us-east-1
Type: string
Mandatory: No
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: false
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Values: ignore, abort
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: path
Mandatory: Yes
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Values: never, always
Settings
Type: number
Mandatory: No
Dynamic: Yes
Default: 0
Type:
Mandatory: No
Dynamic: Yes
Values: empty, error, ok
Type: number
Mandatory: No
Dynamic: Yes
Default: (no limit)
Type:
Mandatory: No
Dynamic: Yes
Default: 64Ki
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Values: ignorecase, case, extended
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: string
Mandatory: No
Dynamic: Yes
Default: milliseconds
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: Yes
Dynamic: No
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Values: service, session, date
Type:
Mandatory: No
Dynamic: Yes
Values: session, unified, stdout
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: " "
Type:
Mandatory: No
Dynamic: Yes
Values: case, ignorecase, extended
Type: string
Mandatory: No
Dynamic: Yes
Default: ","
Type: string
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: string
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Settings
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: Yes
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Values: ignorecase, case, extended
Type: string
Mandatory: Yes
Dynamic: Yes
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: string
Mandatory: No
Dynamic: Yes
Default: Native
Type: string
Mandatory: Yes
Dynamic: Yes
Default: No default value
Settings per template in the template file
Type:
Default: From maxscale.cnf
Type:
Default: false
Type:
Default: true
Type: string
Values: Native, ECMAScript, Posix, EPosix, Awk, Grep, EGrep
Type:
Default: false
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Values: ignorecase, case, extended
Type: service
Mandatory: No
Dynamic: Yes
Default: none
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: target
Mandatory: No
Dynamic: Yes
Default: none
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: 2s
Type: number
Mandatory: Yes
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: 250ms
Type:
Mandatory: Yes
Dynamic: Yes
Settings
Type: number
Mandatory: No
Dynamic: Yes
Default: 10
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: Yes
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: No
Values: ignorecase, case, extended
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Settings
Type: path
Default: /var/lib/maxscale/wcar/
Mandatory: No
Dynamic: No
Type:
Default: 0s
Mandatory: No
Dynamic: No
Type:
Default: 0
Mandatory: No
Dynamic: No
Type:
Default: false
Mandatory: No
Dynamic: No
Settings
Type:
Default: false
Dynamic: Yes
Type:
Default: false
Dynamic: Yes
Type:
Default: false
Dynamic: Yes
Type:
Default: false
Dynamic: Yes
Type:
Default: false
Dynamic: Yes
Type:
Default: false
Dynamic: Yes
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Values: none, majority_of_all, majority_of_running
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: number
Mandatory: No
Dynamic: Yes
Default: 5
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Values: none, connecting_slave, connected_slave
Type: number
Mandatory: No
Dynamic: Yes
Default: -1
Type:
Mandatory: No
Dynamic: Yes
Values: none, linked_master, running_master
Settings for Backup operations
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: path
Mandatory: No
Dynamic: Yes
Default: None
Type: number
Mandatory: No
Dynamic: Yes
Default: 4444
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: path
Mandatory: No
Dynamic: Yes
Default: None
Type: number
Mandatory: No
Dynamic: Yes
Default: 22
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Settings for Cluster manipulation operations
Type:
Mandatory: No
Dynamic: Yes
Values: true, on, yes
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: 90s
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: 90s
Type:
Mandatory: No
Dynamic: Yes
Default: true
Settings for Primary server write test
Type:
Default: log
Values: log, failover
Type:
Dynamic: Yes
Default: 0s
Type: string
Dynamic: Yes
Default: mxs.maxscale_write_test
Settings
Type: number
Mandatory: No
Dynamic: Yes
Default: 1
Type:
Mandatory: No
Dynamic: Yes
Default: 3s
Type:
Mandatory: No
Dynamic: Yes
Default: 3s
Type:
Mandatory: No
Dynamic: Yes
Default: 3s
Type:
Mandatory: No
Dynamic: Yes
Default: 0s
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Values: master_down, master_up, slave_down
Type:
Mandatory: No
Dynamic: Yes
Default: 28800s
Type: string
Mandatory: Yes
Dynamic: No
Type:
Mandatory: No
Dynamic: Yes
Default: 2s
Type: string
Mandatory: Yes
Dynamic: Yes
Type: string
Mandatory: No
Dynamic: Yes
Default: None
Type:
Mandatory: No
Dynamic: Yes
Default: 90s
Type: string
Mandatory: Yes
Dynamic: Yes
Type: string
Mandatory: Yes
Dynamic: Yes
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: true
Settings
Type: string
Mandatory: No
Default: "NoSQL"
Type: string
Mandatory: No
Default: ""
Type: string
Mandatory: No
Default: ""
Type:
Mandatory: No
Default: false
Type:
Mandatory: No
Default: false
Type: string
Mandatory: Yes, if authentication_shared is true.
Type:
Mandatory: No
Default: false
Type:
Mandatory: No
Default: true
Type:
Mandatory: No
Default: true
Type:
Mandatory: No
Default: 60s
Type:
Mandatory: No
Values: none, in, out, back
Type: string
Mandatory: No
Default: "%"
Type: count
Mandatory: No
Range: [35, 2048]
*Default: 35
Type: string
Mandatory: No
Default: ''
Type:
Mandatory: No
Default: false
Type:
Mandatory: No
Values: return_error, return_empty
Default: return_error
Type:
Mandatory: No
Values: atomic, default
Default: default
Type: string
Mandatory: No
Default: ""
Type: string
Mandatory: No
Default: ""
Settings
Type: string
Mandatory: Yes
Default: No
Dynamic: No
Type:
Mandatory: No
Dynamic: No
Values: none, zstandard
Type: path
Mandatory: No
Dynamic: No
Default: /var/lib/maxscale/binlogs
Type:
Mandatory: No
Dynamic: No
Default: false
Type:
Mandatory: No
Dynamic: No
Values: AES_CBC, AES_CTR, AES_GCM
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type:
Dynamic: No
Values: purge, archive
Default: purge
Type:
Mandatory: No
Dynamic: No
Default: 0s
Type: number
Mandatory: No
Dynamic: No
Default: 2
Type:
Mandatory: No
Dynamic: No
Default: 10s
Type: count
Mandatory: No
Dynamic: No
Default: 2
Type:
Mandatory: No
Default: false
Dynamic: Yes
Type:
Mandatory: No
Dynamic: No
Default: false
Type: count
Mandatory: No
Dynamic: No
Default: 1234
Settings
Type:
Mandatory: No
Dynamic: Yes
Values: none, other, `both'
Type: non-negative integer
Mandatory: No
Dynamic: Yes
Default: 2
Type:
Mandatory: No
Dynamic: Yes
Default: 15m
Type: server
Mandatory: Yes
Dynamic: No
Type: non-negative integer
Mandatory: No
Dynamic: Yes
Default: 10
Type:
Mandatory: No
Dynamic: Yes
Values: close, ignore
Type: count
Mandatory: No
Dynamic: Yes
Min: 1
Type:
Mandatory: No
Dynamic: No
Default: 15m
Type:
Mandatory: No
Dynamic: Yes
Values: always, on_discrepancy, never
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: non-negative integer
Mandatory: No
Dynamic: Yes
Default: 5
Type: non-negative integer
Mandatory: No
Dynamic: Yes
Default: 5
Type: count
Mandatory: No
Dynamic: Yes
Min: 100
Type: service
Mandatory: Yes
Dynamic: No
Settings
Type: string
Mandatory: Yes
Dynamic: No
Type:
Mandatory: No
Dynamic: No
Default: false
Type:
Mandatory: No
Dynamic: No
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: ""
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: No
Values: PLAIN, SCRAM-SHA-256, SCRAM-SHA-512
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type: string
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: No
Default: false
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type: path
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: No
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: number
Mandatory: No
Dynamic: No
Default: 1234
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type: string
Mandatory: Yes
Dynamic: No
Settings
Type: count
Mandatory: No
Dynamic: Yes
Default: 100
Type: string
Mandatory: Yes
Dynamic: Yes
Type: string
Default: InnoDB
Mandatory: No
Dynamic: Yes
Type:
Mandatory: No
Dynamic: Yes
Values: PLAIN, SCRAM-SHA-256, SCRAM-SHA-512
Type: string
Mandatory: No
Dynamic: Yes
Default: ""
Type: string
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type: path
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Values: topic, key
Type:
Mandatory: No
Dynamic: Yes
Default: 5000ms
Type: stringlist
Mandatory: Yes
Dynamic: Yes
Settings
Type:
Mandatory: Yes
Dynamic: Yes
Values: log, file, kafka
Type: string
Default: No default value
Mandatory: No
Dynamic: Yes
Type: string
Default: No default value
Mandatory: No
Dynamic: Yes
Type: string
Default: No default value
Mandatory: No
Dynamic: Yes
Type: target
Mandatory: Yes
Dynamic: Yes
Type:
Default: ignore
Mandatory: No
Dynamic: Yes
Type:
Default: always
Mandatory: No
Dynamic: Yes
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: 0s
Type:
Mandatory: No
Dynamic: Yes
Values: master, slave, synced
Settings
Type:
Mandatory: No
Dynamic: Yes
Values: none, local, global
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: 10s
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Values: fail_instantly, fail_on_write, error_on_write
Type:
Mandatory: No
Dynamic: Yes
Default: true (>= MaxScale 24.02), false(<= MaxScale 23.08)
Type:
Mandatory: No
Dynamic: Yes
Default: 0s
Type: integer
Mandatory: No
Dynamic: Yes
Default: 255
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type: integer
Mandatory: No
Dynamic: Yes
Default: 255
Type:
Mandatory: No
Dynamic: Yes
Values: least_current_operations, adaptive_routing, least_behind_master
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: true (>= MaxScale 24.02), false (<= MaxScale 23.08)
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: integer
Mandatory: No
Dynamic: Yes
Default: 5
Type:
Mandatory: No
Dynamic: Yes
Values: full, result_only, no_insert_id
Type:
Mandatory: No
Dynamic: Yes
Default: 1 MiB
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: true
Type:
Mandatory: No
Dynamic: Yes
Default: 30s (>= MaxScale 24.02), 0s (<= MaxScale 23.08)
Type:
Mandatory: No
Dynamic: Yes
Values: master, all
Settings
Type:
Mandatory: No
Dynamic: Yes
Default: false
Type: stringlist
Mandatory: No
Dynamic: Yes
Default: ""
Type:
Mandatory: No
Dynamic: No
Default: ""
Type:
Mandatory: No
Dynamic: Yes
Default: 150s
Type:
Mandatory: No
Dynamic: No
Default: false
Type:
Mandatory: No
Dynamic: Yes
Default: 300s
Settings
Type: target
Mandatory: Yes
Dynamic: No
This page is licensed: CC BY-SA / Gnu FDL
PATCHDELETEHEADOPTIONSCONNECTTRACEDefault: No exclusions
HS512RS256RS384RS512PS256PS384PS512ES256ES384ES512ED25519ED448Default: auto
TLSv1.2TLSv1.3TLSv10TLSv11TLSv12TLSv13Default: MAX
Dynamic: No
Default: never
Default: none
Default: default
Default: default
Default: primary
Auto tune: Yes
Default: add_when_load_ok
Auto tune: Yes
TLSv1.2TLSv1.3TLSv10TLSv11TLSv12TLSv13Default: MAX
Default: none
Default: password
Default: ignorecase
Default: all_transactions
Default: thread_specific
Default: never
Default: assume_cacheable
Default: mixed
Default: abort
Default: never
Default: empty
Default: ignorecase
userreply_timetotal_reply_timequerydefault_dbnum_rowsreply_sizetransactiontransaction_timenum_warningserror_msgDefault: date, user, query
Default: session
Default: case
Default: ignorecase
Native, ECMAScript, Posix, EPosix, Awk, Grep, EGrepDefault: From maxscale.cnf
Default: ignorecase
Default: case
Default: none
running_slaveprimary_monitor_masterdisk_space_okDefault: primary_monitor_master, disk_space_ok
writable_masterprimary_monitor_masterDefault: none
1falseoffno0safeDefault: false
slave_upserver_downserver_uplost_masterlost_slavenew_masternew_slaveDefault: All events
Default: none
Default: none
Default: AES_GCM
Default: both
Default: ignore
Default: 99
Default: on_discrepancy
Default: PLAIN
Default: PLAIN
Default: topic
Values: ignore, close
Values: always, on_conflict
runningDefault: running
fastfast_globaluniversalfast_universalDefault: none
Default: fail_on_write (MaxScale 23.08: fail_instantly)
least_router_connectionsleast_global_connectionsDefault: least_current_operations
Default: full
Default: all