Module Parameters in 2.5

The parameters for mariadbmon:

Parameter

Description

assume_unique_hostnames

Type: bool, default value: True

auto_failover

Type: bool, default value: False

auto_rejoin

Type: bool, default value: False

backend_connect_attempts

Type: count, default value: 1

backend_connect_timeout

Type: duration, default value: 3s

backend_read_timeout

Type: duration, default value: 3s

backend_write_timeout

Type: duration, default value: 3s

cooperative_monitoring_locks

Type: enum, default value: none

demotion_sql_file

Type: path

detect_replication_lag

Type: bool, default value: False

detect_stale_master

Require that the Primary Server have connectivity with at least one running Replica Server.

detect_stale_slave

Requires that Replica Servers have connectivity with a running Primary Server.

detect_standalone_master

Requires that the Primary Server have at least one Replica Server.

disk_space_check_interval

Type: duration, default value: 0ms

disk_space_threshold

Type: string

enforce_read_only_slaves

Type: bool, default value: False

enforce_simple_topology

Type: bool, default value: False

events

Type: enum_mask, default value: all

failcount

Number of consecutive times MaxScale can fail to reach the Primary Server before it considers it down.

failover_timeout

Type: duration, default value: 90s

handle_events

Type: bool, default value: True

ignore_external_masters

Type: bool, default value: False

journal_max_age

Type: duration, default value: 28800s

maintenance_on_low_disk_space

Type: bool, default value: True

master_conditions

Type: enum_mask, default value: primary_monitor_master

master_failure_timeout

Type: duration, default value: 10s

monitor_interval

Interval of time for performing monitoring checks.

password

Type: password string

promotion_sql_file

Type: path

replication_master_ssl

Type: bool, default value: False

replication_password

Type: password string

replication_user

Type: string

script

Type: string

script_timeout

Type: duration, default value: 90s

servers_no_promotion

Type: serverlist

slave_conditions

Type: enum_mask, default value: none

switchover_on_low_disk_space

Type: bool, default value: False

switchover_timeout

Type: duration, default value: 90s

user

Type: string

verify_master_failure

Type: bool, default value: True

The parameters for readwritesplit:

Parameter

Description

auth_all_servers

Type: bool, default value: False

causal_reads

Configures read causality, reads subsequent to writes issued in manner to reduce replication lag.

causal_reads_timeout

Timeout for synchronization of the Primary Server with a Replica Server during causal reads.

connection_keepalive

Type: duration, default value: 300s

connection_timeout

Type: duration, default value: 0

delayed_retry

Retry queries that fail to route due to connection issues.

delayed_retry_timeout

Timeout for retrying queries that fail to route due to connection issues.

disable_sescmd_history

Type: bool, default value: False

enable_root_user

Type: bool, default value: False

lazy_connect

Type: bool, default value: False

localhost_match_wildcard_host

Type: bool, default value: True

log_auth_warnings

Type: bool, default value: True

master_accept_reads

Route read operations to the Primary Server or whether it only accepts write operations.

master_failure_mode

Type: enum, default value: fail_instantly

master_reconnection

Reconnect to the Primary Server if it changes mid-session.

max_connections

Type: count, default value: 0

max_sescmd_history

Type: count, default value: 50

max_slave_connections

Maximum number of connections the router session can use to connect to Replica Servers.

max_slave_replication_lag

Number of seconds a Replica Server is allowed to fall behind the Primary Server.

net_write_timeout

Type: duration, default value: 0

optimistic_trx

Type: bool, default value: False

password

Type: password string

prune_sescmd_history

Type: bool, default value: False

rank

Type: enum, default value: primary

retain_last_statements

Type: int, default value: -1

retry_failed_reads

Type: bool, default value: True

router_options

Type: string

session_trace

Type: bool, default value: False

session_track_trx_state

Type: bool, default value: False

slave_connections

Type: count, default value: 255

slave_selection_criteria

Criteria the router uses to select Replica Servers in load balancing read operations.

strict_multi_stmt

Routes multi-statement queries to the Primary Server.

strict_sp_calls

Routes CALL statements to the Primary Server.

strip_db_esc

Type: bool, default value: True

transaction_replay

Replays in progress transactions that fail on a different Server.

transaction_replay_attempts

Maximum number of times to attempt to replay failed transactions.

transaction_replay_max_size

Maximum size in bytes permitted for transaction replays.

transaction_replay_retry_on_deadlock

Maximum number of times the router attempts to replay transactions in the event that the transaction fails due to deadlocks.

use_sql_variables_in

Where the router sends session variable queries.

user

Type: string

version_string

Type: string

The parameters for MariaDBClient:

Parameter

Description

address

Type: string, default value: "::"

authenticator

Type: string

authenticator_options

Type: string, default value:

connection_init_sql_file

Type: path

port

Type: count

protocol

Type: string

socket

Type: string

sql_mode

Type: string

ssl

Type: enum, default value: false

ssl_ca_cert

Type: path

ssl_cert

Type: path

ssl_cert_verify_depth

Type: count, default value: 9

ssl_cipher

Type: string

ssl_crl

Type: path

ssl_key

Type: path

ssl_verify_peer_certificate

Type: bool, default value: False

ssl_verify_peer_host

Type: bool, default value: False

ssl_version

Type: enum, default value: MAX

The parameters for readconnroute:

Parameter

Description

auth_all_servers

Type: bool, default value: False

connection_keepalive

Type: duration, default value: 300s

connection_timeout

Type: duration, default value: 0

enable_root_user

Type: bool, default value: False

localhost_match_wildcard_host

Type: bool, default value: True

log_auth_warnings

Type: bool, default value: True

max_connections

Type: count, default value: 0

net_write_timeout

Type: duration, default value: 0

password

Type: password string

rank

Type: enum, default value: primary

retain_last_statements

Type: int, default value: -1

router_options

Type: string

session_trace

Type: bool, default value: False

session_track_trx_state

Type: bool, default value: False

strip_db_esc

Type: bool, default value: True

user

Type: string

version_string

Type: string

The parameters for maxscale:

Parameter

Description

admin_auth

Type: bool, default value: True

admin_enabled

Type: bool, default value: True

admin_gui

Type: bool, default value: True

admin_host

Type: string, default value: 127.0.0.1

admin_log_auth_failures

Type: bool, default value: True

admin_pam_readonly_service

Type: string

admin_pam_readwrite_service

Type: string

admin_port

Type: int, default value: 8989

admin_secure_gui

Type: bool, default value: True

admin_ssl_ca_cert

Type: string

admin_ssl_cert

Type: string

admin_ssl_key

Type: string

auth_connect_timeout

Type: duration, default value: 10000

auth_read_timeout

Type: duration, default value: 10000

auth_write_timeout

Type: duration, default value: 10000

debug

Type: string

dump_last_statements

Type: enum, default value: never

load_persisted_configs

Type: bool, default value: True

local_address

Type: string

log_debug

Type: bool, default value: False

log_info

Type: bool, default value: False

log_notice

Type: bool, default value: True

log_throttling

Type: throttling, default value: {'count': 0, 'suppress': 0, 'window': 0}

log_warn_super_user

Type: bool, default value: False

log_warning

Type: bool, default value: True

max_auth_errors_until_block

Type: int, default value: 10

maxlog

Type: bool, default value: True

ms_timestamp

Type: bool, default value: False

passive

Type: bool, default value: False

query_classifier

Type: string, default value: qc_sqlite

query_classifier_args

Type: string

query_classifier_cache_size

Type: size, default value: 0

query_retries

Type: int, default value: 1

query_retry_timeout

Type: duration, default value: 5000

rebalance_period

Type: duration, default value: 0

rebalance_threshold

Type: int, default value: 20

rebalance_window

Type: count, default value: 10

retain_last_statements

Type: count, default value: 0

session_trace

Type: count, default value: 0

skip_permission_checks

Type: bool, default value: False

sql_mode

Type: enum, default value: default

syslog

Type: bool, default value: True

threads

Type: count, default value: 1

users_refresh_interval

Type: duration, default value: 0

users_refresh_time

Type: duration, default value: 30000

writeq_high_water

Type: size, default value: 16777216

writeq_low_water

Type: size, default value: 8192

The parameters for servers:

Parameter

Description

address

Type: string

authenticator

Type: string

disk_space_threshold

Type: disk_space_limits

extra_port

Type: count, default value: 0

monitorpw

Type: string

monitoruser

Type: string

persistmaxtime

Type: duration, default value: 0

persistpoolmax

Type: count, default value: 0

port

Type: count, default value: 3306

priority

Type: count, default value: 0

protocol

Type: string

proxy_protocol

Type: bool, default value: False

rank

Type: enum, default value: primary

socket

Type: string

ssl

Type: bool, default value: False

ssl_ca_cert

Type: path

ssl_cert

Type: path

ssl_cert_verify_depth

Type: count, default value: 9

ssl_cipher

Type: string

ssl_key

Type: path

ssl_verify_peer_certificate

Type: bool, default value: False

ssl_verify_peer_host

Type: bool, default value: False

ssl_version

Type: enum, default value: MAX

type

Type: string, default value: server