MariaDB Server With Replicas

For cloud databases with the Mariadb Server With Replica(s) topology, Configuration Manager can be used to configure MariaDB Server behavior and MariaDB MaxScale behavior.

The following Configuration Manager parameters are used to configure MariaDB Server behavior:

Name	Default Value
auto_increment_increment	1
autocommit	ON
binlog_cache_size	32768
binlog_commit_wait_count	0
binlog_commit_wait_usec	100000
connect_timeout	5
cracklib_password_check	OFF
default_password_lifetime	0
default_time_zone	system
disconnect_on_expired_password	OFF
div_precision_increment	4
eq_range_index_dive_limit	200
event_scheduler	OFF
expire_logs_days	4
explicit_defaults_for_timestamp	OFF
gtid_strict_mode	ON
host_cache_size	248
idle_readonly_transaction_timeout	0
idle_transaction_timeout	0
idle_write_transaction_timeout	0
innodb_autoextend_increment	64
innodb_autoinc_lock_mode	2
innodb_buffer_pool_size	AUTO_GENERATED
innodb_change_buffering	none
innodb_flush_log_at_trx_commit	1
innodb_log_buffer_size	16777216
innodb_log_file_size	1073741824
innodb_strict_mode	ON
interactive_timeout	3600
join_buffer_size	262144
local_infile	ON
log_output	FILE
log_slow_filter	admin, filesort, filesort_on_disk, filesort_priority_queue, full_join, full_scan, query_cache, query_cache_miss, tmp_table, tmp_table_on_disk
log_slow_rate_limit	1
log_slow_verbosity
log_warnings	2
long_query_time	10.0
lower_case_table_names	0
max_allowed_packet	33554432
max_connections	AUTO_GENERATED
max_heap_table_size	16777216
max_password_errors	4294967295
net_buffer_length	16384
net_write_timeout	60
open_files_limit	0
optimizer_search_depth	62
optimizer_switch	AUTO_GENERATED
performance_schema	OFF
performance_schema_accounts_size	-1
performance_schema_digests_size	-1
performance_schema_events_stages_history_long_size	-1
performance_schema_events_stages_history_size	-1
performance_schema_events_statements_history_long_size	-1
performance_schema_events_statements_history_size	-1
performance_schema_events_waits_history_long_size	-1
performance_schema_events_waits_history_size	-1
performance_schema_hosts_size	-1
performance_schema_max_cond_classes	90
performance_schema_max_cond_instances	-1
performance_schema_max_digest_length	1024
performance_schema_max_file_classes	80
performance_schema_max_file_handles	32768
performance_schema_max_file_instances	-1
performance_schema_max_mutex_classes	200
performance_schema_max_mutex_instances	-1
performance_schema_max_rwlock_classes	50
performance_schema_max_rwlock_instances	-1
performance_schema_max_socket_classes	10
performance_schema_max_socket_instances	10
performance_schema_max_stage_classes	160
performance_schema_max_table_handles	-1
performance_schema_max_table_instances	-1
performance_schema_max_thread_classes	50
performance_schema_max_thread_instances	-1
performance_schema_session_connect_attrs_size	-1
performance_schema_users_size	-1
proxy_protocol_networks	10.0.0.0/8
read_buffer_size	131072
read_only	OFF
read_rnd_buffer_size	262144
rpl_semi_sync_master_enabled	ON
rpl_semi_sync_master_timeout	10000
rpl_semi_sync_master_wait_no_slave	ON
rpl_semi_sync_master_wait_point	AFTER_COMMIT
rpl_semi_sync_slave_delay_master	OFF
rpl_semi_sync_slave_enabled	ON
rpl_semi_sync_slave_kill_conn_timeout	5
server_audit	ON
server_audit_file_rotate_size	1000000
server_audit_logging	OFF
session_track_system_variables	autocommit, character_set_client, character_set_connection, character_set_results, time_zone
simple_password_check_digits	1
simple_password_check_letters_same_case	1
simple_password_check_minimal_length	8
simple_password_check_other_characters	1
slave_compressed_protocol	OFF
slave_parallel_mode	optimistic
slave_parallel_threads	AUTO_GENERATED
slave_parallel_workers	0
slow_query_log	OFF
sort_buffer_size	2097152
sql_mode	ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
strict_password_validation	ON
sync_binlog	1
sync_master_info	1
sync_relay_log	0
sync_relay_log_info	0
system_versioning_alter_history	ERROR
table_open_cache	AUTO_GENERATED
thread_cache_size	256
thread_handling	one-thread-per-connection
thread_pool_idle_timeout	60
thread_pool_max_threads	65536
thread_pool_priority	auto
thread_stack	299008
tmp_table_size	AUTO_GENERATED
transaction_isolation	REPEATABLE-READ
wait_timeout	600