[mysqld]

# Cluster
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address="gcomm://<ips here>"

wsrep_provider_options="gcache.size=9G; gcache.page_size=300M; gmcast.segment=5; evs.keepalive_period=PT3S; evs.suspect_timeout=PT30S; evs.inactive_timeout=PT1M; evs.install_timeout=PT1M; evs.join_retrans_period=PT0.5S; gcs.max_packet_size=1048576; evs.send_window=512; evs.user_send_window=256"

wsrep_node_address=<ip add>
wsrep_node_name=<hostname>
wsrep_cluster_name="my_wsrep_cluster"

# SST
wsrep_sst_auth=backupuser:Password
wsrep_sst_method=xtrabackup-v2

wsrep_slave_threads=8
datadir=/var/lib/mysql
user=mysql
wsrep_max_ws_rows=1048576
wsrep_max_ws_size=1073741824

binlog_format=row
default_storage_engine=InnoDB
bind-address=0.0.0.0

innodb_stats_auto_recalc = 1
innodb_autoinc_lock_mode=2

max_allowed_packet=64M
max_connections=512
table_open_cache=1000
innodb_buffer_pool_size=8G

query_cache_type=1
query_cache_size=128M
wait_timeout=86400
innodb_log_file_size=2G

innodb_log_buffer_size=32M
innodb_file_per_table=1
innodb_log_files_in_group=2
innodb_flush_method=O_DIRECT

innodb_flush_log_at_trx_commit=0
event_scheduler=ON
binlog-row-event-max-size = 1048576


skip-name-resolve


[sst]
inno-apply-opts="--use-memory=4G"

## SSL parameters
encrypt =
streamfmt = xbstream
tca =
tkey =
tcert =