Configuration Management

This page is part of MariaDB's Documentation.

The parent of this page is: Reference

Topics on this page:

Overview
What is configurable?
- Enterprise Server
- MaxScale
Allowed Values
- Enterprise Server
- MariaDB MaxScale

Overview

The MariaDB SkySQL Configuration Manager allows you to customize the values of many System Variables, which are called Configuration Variables within the Configuration Manager.

The "Configuration Manager" option is found in the SkySQL main menu (left navigation) and is visible after you have launched your first service.

What is configurable?

Available configuration parameters differ by service and topology.

For Distributed Transactions, only the default_time_zone is configurable in the Configuration Manager.

Enterprise Server

The following table lists parameter-availability by topology for Single Node Transactions (SNT), Replicated Transactions (RT), Single Node Analytics (SNA), and Multi-Node Analytics (MNA):

Parameter / Topology	SNT1	RT2	SNA3	MNA4
binlog_commit_wait_count	No	Yes	No	No
binlog_commit_wait_usec	No	Yes	No	No
cracklib_password_check	Yes	Yes	Yes	Yes
default_password_lifetime	Yes	Yes	Yes	Yes
default_time_zone	Yes	Yes	No	No
disconnect_on_expired_password	Yes	Yes	Yes	Yes
div_precision_increment	Yes	Yes	Yes	Yes
eq_range_index_dive_limit	Yes	Yes	Yes	Yes
event_scheduler	Yes	Yes	Yes	Yes
gtid_strict_mode	No	Yes	No	No
idle_readonly_transaction_timeout	Yes	Yes	Yes	Yes
idle_transaction_timeout	Yes	Yes	Yes	Yes
idle_write_transaction_timeout	Yes	Yes	Yes	Yes
innodb_flush_log_at_trx_commit	Yes	Yes	No	Yes
innodb_log_file_size	Yes	Yes	No	Yes
interactive_timeout	Yes	Yes	Yes	Yes
local_infile	Yes	Yes	Yes	Yes
log_warnings	Yes	Yes	Yes	Yes
long_query_time	Yes	Yes	Yes	Yes
lower_case_table_names	Yes	Yes	Yes	Yes
max_allowed_packet	Yes	Yes	Yes	Yes
max_password_errors	Yes	Yes	Yes	Yes
optimizer_search_depth	Yes	Yes	Yes	Yes
performance_schema	Yes	Yes	Yes	Yes
performance_schema_accounts_size	Yes	Yes	Yes	Yes
performance_schema_digests_size	Yes	Yes	Yes	Yes
performance_schema_events_stages_history_long_size	Yes	Yes	Yes	Yes
performance_schema_events_stages_history_size	Yes	Yes	Yes	Yes
performance_schema_events_statements_history_long_size	Yes	Yes	Yes	Yes
performance_schema_events_statements_history_size	Yes	Yes	Yes	Yes
performance_schema_events_waits_history_long_size	Yes	Yes	Yes	Yes
performance_schema_events_waits_history_size	Yes	Yes	Yes	Yes
performance_schema_hosts_size	Yes	Yes	Yes	Yes
performance_schema_max_cond_classes	Yes	Yes	Yes	Yes
performance_schema_max_cond_instances	Yes	Yes	Yes	Yes
performance_schema_max_digest_length	Yes	Yes	Yes	Yes
performance_schema_max_file_classes	Yes	Yes	Yes	Yes
performance_schema_max_file_handles	Yes	Yes	Yes	Yes
performance_schema_max_file_instances	Yes	Yes	Yes	Yes
performance_schema_max_mutex_classes	Yes	Yes	Yes	Yes
performance_schema_max_mutex_instances	Yes	Yes	Yes	Yes
performance_schema_max_rwlock_classes	Yes	Yes	Yes	Yes
performance_schema_max_rwlock_instances	Yes	Yes	Yes	Yes
performance_schema_max_socket_classes	Yes	Yes	Yes	Yes
performance_schema_max_socket_instances	Yes	Yes	Yes	Yes
performance_schema_max_stage_classes	Yes	Yes	Yes	Yes
performance_schema_max_statement_classes	Yes	Yes	Yes	Yes
performance_schema_max_table_handles	Yes	Yes	Yes	Yes
performance_schema_max_table_instances	Yes	Yes	Yes	Yes
performance_schema_max_thread_classes	Yes	Yes	Yes	Yes
performance_schema_max_thread_instances	Yes	Yes	Yes	Yes
performance_schema_session_connect_attrs_size	Yes	Yes	Yes	Yes
performance_schema_users_size	Yes	Yes	Yes	Yes
rpl_semi_sync_master_enabled	No	Yes	No	No
rpl_semi_sync_master_timeout	No	Yes	No	No
rpl_semi_sync_master_wait_no_slave	No	Yes	No	No
rpl_semi_sync_master_wait_point	No	Yes	No	No
rpl_semi_sync_slave_delay_master	No	Yes	No	No
rpl_semi_sync_slave_enabled	No	Yes	No	No
rpl_semi_sync_slave_kill_conn_timeout	No	Yes	No	No
server_audit	Yes	Yes	Yes	Yes
server_audit_logging	Yes	Yes	Yes	Yes
simple_password_check_digits	Yes	Yes	Yes	Yes
simple_password_check_letters_same_case	Yes	Yes	Yes	Yes
simple_password_check_minimal_length	Yes	Yes	Yes	Yes
simple_password_check_other_characters	Yes	Yes	Yes	Yes
slave_compressed_protocol	No	Yes	No	No
slave_parallel_mode	No	Yes	No	No
slave_parallel_threads	No	Yes	No	No
slave_parallel_workers	No	Yes	No	No
slow_query_log	Yes	Yes	Yes	Yes
sql_mode	Yes	Yes	Yes	No
strict_password_validation	Yes	Yes	Yes	Yes
sync_binlog	No	Yes	No	No
sync_master_info	No	Yes	No	No
sync_relay_log	No	Yes	No	No
sync_relay_log_info	No	Yes	No	No
system_versioning_alter_history	Yes	Yes	Yes	Yes
thread_cache_size	Yes	Yes	Yes	Yes
thread_handling	Yes	Yes	Yes	Yes
thread_pool_idle_timeout	Yes	Yes	Yes	Yes
thread_pool_max_threads	Yes	Yes	Yes	Yes
thread_pool_priority	Yes	Yes	Yes	Yes
thread_pool_size	Yes	Yes	Yes	Yes
tx_isolation	Yes	Yes	Yes	Yes
wait_timeout	Yes	Yes	Yes	Yes

1:: Single Node Transactions
2:: Replicated Transactions
3:: Single Node Analytics
4:: Multi-Node Analytics

MaxScale

MariaDB MaxScale is used to deliver Replicated Transactions on SkySQL, and is configurable on GCP.

Section	Parameter / Topology	Replicated Transactions
MariaDBMon	failcount	Yes
MariaDBMon	monitor_interval	Yes
ReadWriteSplit	causal_reads	Yes
ReadWriteSplit	causal_reads_timeout	Yes
ReadWriteSplit	delayed_retry	Yes
ReadWriteSplit	delayed_retry_timeout	Yes
ReadWriteSplit	master_accept_reads	Yes
ReadWriteSplit	master_reconnection	Yes
ReadWriteSplit	max_slave_connections	Yes
ReadWriteSplit	max_slave_replication_lag	Yes
ReadWriteSplit	slave_selection_criteria	Yes
ReadWriteSplit	strict_multi_stmt	Yes
ReadWriteSplit	strict_sp_calls	Yes
ReadWriteSplit	transaction_replay	Yes
ReadWriteSplit	transaction_replay_attempts	Yes
ReadWriteSplit	transaction_replay_max_size	Yes
ReadWriteSplit	transaction_replay_retry_on_deadlock	Yes
ReadWriteSplit	use_sql_variables_in	Yes

Allowed Values

Enterprise Server

Configuration Variable	Allowed Values	Comments
binlog_commit_wait_count	0, 5, 25, 100, 500, 1000, 5000	Only Replicated Transactions
binlog_commit_wait_usec	0, 10000, 100000, 500000, 1000000	Only Replicated Transactions
cracklib_password_check	OFF, ON, FORCE, FORCE_PLUS_PERMANENT
default_password_lifetime	0, 7, 14, 30, 90, 180, 365
default_time_zone	a valid IANA time zone value	Only Single Node Transactions & Replicated Transactions
disconnect_on_expired_password	OFF, ON
div_precision_increment	0, 4, 38
eq_range_index_dive_limit	0, 200, 2000, 6000, 12000, 20000
event_scheduler	ON, OFF
gtid_strict_mode	OFF, ON	Only Replicated Transactions
idle_readonly_transaction_timeout	0, 300, 600, 3600, 86400, 604800, 31536000
idle_transaction_timeout	0, 300, 600, 3600, 86400, 604800, 31536000
idle_write_transaction_timeout	0, 300, 600, 3600, 86400, 604800, 31536000
innodb_flush_log_at_trx_commit	0, 1, 2	Not Single Node Analytics
innodb_log_file_size	1MB, 512MB, 1GB, 4GB, 8GB, 16GB, 32GB, 64GB, 128GB	Not Single Node Analytics
interactive_timeout	300, 600, 3600, 28800, 86400
local_infile	OFF, ON
log_warnings	1, 2, 3, 4, 9
long_query_time	10ms, 20ms, 30ms, 40ms, 50ms, 60ms, 70ms, 80ms, 90ms, 100ms, 150ms, 200ms, 300ms, 500ms, 1s, 2s, 3s, 4s, 5s, 6s, 7s, 8s, 9s, 10s, 15s, 20s, 30s, 1m, 2m, 3m, 5m, 10m, 15m
lower_case_table_names	0, 1, 2
max_allowed_packet	33554432, 67108864, 268435456, 536870912, 1073741824
max_password_errors	1, 5, 10, 50, 4294967295
optimizer_search_depth	0, 8, 16, 32, 48, 56, 62
performance_schema	OFF, ON
performance_schema_accounts_size	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_digests_size	-1, 0, 10, 50, 100, 200
performance_schema_events_stages_history_long_size	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_events_stages_history_size	-1, 0, 16, 128, 256, 512, 1024
performance_schema_events_statements_history_long_size	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_events_statements_history_size	-1, 0, 16, 128, 256, 512, 1024
performance_schema_events_waits_history_long_size	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_events_waits_history_size	-1, 0, 16, 128, 256, 512, 1024
performance_schema_hosts_size	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_cond_classes	0, 40, 90, 150, 200, 250
performance_schema_max_cond_instances	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_digest_length	0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_file_classes	0, 40, 80, 150, 210, 250
performance_schema_max_file_handles	-1, 0, 16, 128, 1024, 8192, 32768
performance_schema_max_file_instances	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_mutex_classes	0, 40, 90, 150, 210, 250
performance_schema_max_mutex_instances	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_rwlock_classes	0, 50, 90, 150, 200, 250
performance_schema_max_rwlock_instances	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_socket_classes	0, 10, 40, 90, 150, 200, 250
performance_schema_max_socket_instances	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_stage_classes	0, 40, 90, 160, 210, 250
performance_schema_max_statement_classes	Autosized or 0
performance_schema_max_table_handles	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_table_instances	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_max_thread_classes	0, 50, 90, 150, 210, 250
performance_schema_max_thread_instances	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_session_connect_attrs_size	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
performance_schema_users_size	-1, 0, 16, 128, 1024, 8192, 32768, 65536, 1048576
rpl_semi_sync_master_enabled	OFF, ON	Only Replicated Transactions
rpl_semi_sync_master_timeout	1000, 10000, 30000, 60000, 120000, 600000	Only Replicated Transactions
rpl_semi_sync_master_wait_no_slave	OFF, ON	Only Replicated Transactions
rpl_semi_sync_master_wait_point	AFTER_SYNC, AFTER_COMMIT	Only Replicated Transactions
rpl_semi_sync_slave_delay_master	OFF, ON	Only Replicated Transactions
rpl_semi_sync_slave_enabled	OFF, ON	Only Replicated Transactions
rpl_semi_sync_slave_kill_conn_timeout	0, 5, 10, 30, 60	Only Replicated Transactions
server_audit	OFF, ON, FORCE, FORCE_PLUS_PERMANENT
server_audit_logging	ON, OFF
simple_password_check_digits	0, 1, 2, 5, 10
simple_password_check_letters_same_case	0, 1, 2, 5, 10
simple_password_check_minimal_length	0, 1, 8, 12, 16, 20, 32
simple_password_check_other_characters	0, 1, 2, 5, 10
slave_compressed_protocol	ON, OFF	Only Replicated Transactions
slave_parallel_mode	none, minimal, conservative, optimistic, aggressive	Only Replicated Transactions
slave_parallel_threads	0, 2, 4, 8, 16, 32, 64, 128, 256	Only Replicated Transactions
slave_parallel_workers	0, 2, 4, 8, 16, 32, 64, 128, 256	Only Replicated Transactions
slow_query_log	ON, OFF
sql_mode	0 or more of the following: DB2, MSSQL, ORACLE, POSTGRESQL	Not Multi-Node Analytics
strict_password_validation	OFF, ON
sync_binlog	0, 1, 10, 100, 1000, 10000, 100000	Only Replicated Transactions
sync_master_info	0, 1, 10, 100, 1000, 10000, 100000	Only Replicated Transactions
sync_relay_log	0, 1, 10, 100, 1000, 10000, 100000	Only Replicated Transactions
sync_relay_log_info	0, 1, 10, 100, 1000, 10000, 100000	Only Replicated Transactions
system_versioning_alter_history	ERROR, KEEP
thread_cache_size	0, 128, 256, 512, 1024, 2048, 4096
thread_handling	ONE-THREAD-PER-CONNECTION, NO-THREADS, POOL-OF-THREADS
thread_pool_idle_timeout	1, 300, 600, 3600, 86400, 604800, 31536000
thread_pool_max_threads	0, 128, 256, 512, 1024, 2048, 4096
thread_pool_priority	high, low, auto
thread_pool_size	0, 16, 32, 64, 128, 256, 512, 1024, 2048
tx_isolation	READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE
wait_timeout	300, 600, 3600, 28800, 86400

MariaDB MaxScale

Section	Parameter	Allowed Values
MariaDBMon	detect_stale_master	Default, TRUE
MariaDBMon	detect_stale_slave	Default, TRUE, FALSE
MariaDBMon	detect_standalone_master	Default, TRUE, FALSE
MariaDBMon	failcount	Default, 1, 5, 10
MariaDBMon	monitor_interval	500, 1000, 2000, 5000, 10000, 15000, 30000, 60000
ReadWriteSplit	causal_reads	Default, TRUE, FALSE
ReadWriteSplit	causal_reads_timeout	Default, 5, 10, 30, 60
ReadWriteSplit	delayed_retry	Default, TRUE, FALSE
ReadWriteSplit	delayed_retry_timeout	Default, 5, 10, 30, 60
ReadWriteSplit	master_accept_reads	Default, TRUE, FALSE
ReadWriteSplit	master_reconnection	Default, TRUE, FALSE
ReadWriteSplit	max_slave_connections	Default, 10%, 25%, 33%, 50%
ReadWriteSplit	max_slave_replication_lag	Default, 10 30 60 120 600 1800 3600
ReadWriteSplit	slave_selection_criteria	Default, LEAST_GLOBAL_CONNECTIONS, LEAST_ROUTER_CONNECTIONS, LEAST_BEHIND_MASTER, LEAST_CURRENT_OPERATIONS, ADAPTIVE_ROUTING
ReadWriteSplit	strict_multi_stmt	Default, TRUE, FALSE
ReadWriteSplit	strict_sp_calls	Default, TRUE, FALSE
ReadWriteSplit	transaction_replay	Default, TRUE, FALSE
ReadWriteSplit	transaction_replay_attempts	Default, 1, 5, 10
ReadWriteSplit	transaction_replay_max_size	Default, 1M, 16M, 32M, 64M
ReadWriteSplit	transaction_replay_retry_on_deadlock	Default, TRUE, FALSE
ReadWriteSplit	use_sql_variables_in	Default, MASTER, ALL