chef/cookbooks/mysql/templates/default/galera.cnf.erb
[mysqld]
wsrep_on = ON
wsrep_provider = /usr/lib64/galera-3/libgalera_smm.so
wsrep_cluster_address = "<%= @cluster_addresses %>"
# values recommended by mysqltuner.pl
wsrep_provider_options = "gmcast.listen_addr=tcp://<%= @node_address %>:4567;gcs.fc_limit = <%= @wsrep_slave_threads * @gcs_fc_limit_multiplier %>;gcs.fc_factor = <%= @gcs_fc_factor %>;<%= @wsrep_provider_options_custom %>"
wsrep_slave_threads = <%= @wsrep_slave_threads %>
# Maximum number of rows in write set
# "0" (unlimited) is the upstream default, but the default configuration in the
# rpm package overwrites that
wsrep_max_ws_rows=0
# Maximum size of write set
# "2147483647" (2GB) is the upstream default, but the default configuration in
# the rpm package overwrites that
wsrep_max_ws_size=2147483647
# to enable debug level logging, set this to 1
wsrep_debug = 0
binlog_format=ROW
default_storage_engine = InnoDB
innodb_autoinc_lock_mode = 2
innodb_doublewrite = 1
# Disable Query Cache completely
query_cache_size = 0
query_cache_type = 0
expire_logs_days = <%= @expire_logs_days %>
# SST method
wsrep_sst_method = mariabackup
wsrep_sst_auth = <%= @sstuser %>:<%= @sstuser_password %>