Enterprise Server with Replica(s)

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

The following Configuration Manager parameters are used to configure MariaDB Enterprise 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