[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/tmp/mariadb.pid
#tmpdir=/var/tmp
log_warnings=1
slow_query_log = 1
slow_query_log_file = /var/log/mariadb/slowquery.log
log_slow_verbosity = query_plan,explain

bind-address = 0.0.0.0
skip-name-resolve
skip-external-locking
performance_schema=ON
userstat = 1


binlog_cache_size = 1M
bulk_insert_buffer_size = 256M
connect_timeout=5
group_concat_max_len=256M
interactive_timeout = 5
#join_buffer_size = 2M
key_buffer_size = 1M
key_cache_block_size=4096
long_query_time = 300
max_allowed_packet = 64M
#max_connect_errors = 30
max_connections = 10
max_heap_table_size=64M
max_length_for_sort_data=8388608
max_sort_length=8388608
max_tmp_tables=8192
open_files_limit=16384
net_buffer_length=1048576
query_cache_type = 0
#query_cache_limit = 256M
#query_cache_min_res_unit = 1K
query_cache_size = 0
#optimizer_switch="index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on"
read_buffer_size = 4M
read_rnd_buffer_size = 2M
sort_buffer_size = 64M
#table_cache = 8192
table_open_cache=8192
table_definition_cache=4096
thread_cache_size=100
#thread_concurrency = 24
#thread_handling=pool-of-threads
thread_stack = 256K
tmp_table_size=64M
wait_timeout = 180

join_buffer_size=2097152

#auto_increment_increment=1
#auto_increment_offset=1
default-storage-engine         = InnoDB
transaction-isolation = READ-COMMITTED

binlog_format=ROW
innodb_autoinc_lock_mode=2

innodb_adaptive_hash_index=on
#innodb_adaptive_hash_index_partitions=16
#innodb_table_locks=0
#innodb_additional_mem_pool_size=64M
innodb_buffer_pool_instances=2
innodb_buffer_pool_size=2G
#innodb_change_buffering=all
#innodb_checksums=OFF
innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend
innodb_data_home_dir = /var/lib/mysql
innodb_doublewrite=0
#innodb_fast_shutdown = 0
innodb_file_per_table=1
#innodb_file_format=Antelope

sql_mode=NO_ENGINE_SUBSTITUTION
#innodb_file_format=Barracuda
innodb-default-row-format=DYNAMIC
#innodb_strict_mode=0

innodb_strict_mode=off

#innodb_flush_method=O_DIRECT

innodb_flush_neighbors=0
innodb_page_size=64K
innodb_io_capacity=1000
innodb_io_capacity_max=1000
#innodb_lock_wait_timeout=60
innodb_log_buffer_size = 2G
innodb_log_file_size=1G
#innodb_lru_scan_depth=1280
innodb_open_files=16384
#innodb_online_alter_log_max_size=1G
#innodb_print_all_deadlocks = 1
#innodb_purge_threads=4
#innodb_random_read_ahead = ON
#innodb_read_ahead_threshold = 32
innodb_read_io_threads=2

#innodb_sort_buffer_size = 67108864
#innodb_stats_on_metadata=1
#innodb_support_xa=off
#innodb_thread_concurrency=32
innodb_write_io_threads=2

innodb_flush_log_at_trx_commit=0
innodb_flush_log_at_timeout=50
innodb_fast_shutdown=0
#innodb_force_recovery=6


wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
wsrep_cluster_address="gcomm://172.31.9.229,172.31.2.72"
wsrep_cluster_name='test_105'
wsrep_node_address='172.31.9.229'
wsrep_node_name='TEST2'
wsrep_sst_method=mariabackup
wsrep_sst_auth=XXXX:XXXX
wsrep_sst_receive_address=172.31.9.229
wsrep_on=on
wsrep_log_conflicts=ON
wsrep_retry_autocommit=4
wsrep_slave_threads=20
sync_binlog=0
#server_id=1
wsrep_slave_UK_checks=ON


wsrep_provider_options="base_dir = /var/lib/mysql/; base_host = 172.31.9.229; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT3S; evs.debug_log_mask = 0x1; evs.delay_margin = PT5S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT1S; evs.inactive_timeout = PT1M; evs.info_log_mask = 0; evs.install_timeout = PT1M; evs.join_retrans_period = PT3S; evs.keepalive_period = PT3S; evs.max_install_timeouts = 3; evs.send_window = 1024; evs.stats_report_period = PT1M; evs.suspect_timeout = PT15S; evs.use_aggregate = true; evs.user_send_window = 512; evs.version = 1; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 4; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 4G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 10000; gcs.fc_master_slave = no; gcs.max_packet_size = 100000; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 1; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 172.31.9.229; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 10; socket.checksum = 2; socket.recv_buf_size = 2097152;"


[sst]
inno-apply-opts="--use-memory=10G"
inno-backup-opts="--parallel=4"
streamfmt=xbstream
transferfmt=socat
time=1

[mariabackup]
use-memory=4G