[mysql]

# CLIENT #
port                           = 3306
socket                         = /var/run/mysqld/mysqld.sock

[mysqld]

# GALERA #
wsrep_on                       = ON
wsrep_provider                 = /usr/lib/galera/libgalera_smm.so
wsrep_provider_options         = "gcache.size=4G"
wsrep_cluster_address          = gcomm://XXXXXXXXXXX
wsrep_cluster_name             = prd-dbs-cluster01
wsrep_node_address             = XXXXXXXXX
wsrep_sst_method               = mariabackup
wsrep_sst_auth                 = XXXXXXXXX
wsrep_sst_receive_address      = XXXXXXXXX
wsrep_retry_autocommit         = 5
wsrep_max_ws_size              = 4G
wsrep_max_ws_rows              = 1M
wsrep_slave_threads            = 16 #consider using twice the number of CPU cores
#wsrep_gtid_mode=ON
#wsrep_gtid_domain_id=100
#log_slave_updates=1
#gtid_domain_id=101
#log_bin                 = /data/mysql/mariadb-bin
#log_bin_index           = /data/mysql/mariadb-bin.index
#expire_logs_days        = 10
#max_binlog_size         = 100M


# GALERA Mandatory setting
default-storage-engine         = InnoDB
query-cache-size               = 0
binlog_format                  = ROW
innodb_autoinc_lock_mode       = 2
#innodb_doublewrite            = 1  #this is the default and it should stay this way

# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
socket                         = /var/run/mysqld/mysqld.sock
pid-file                       = /var/run/mysqld/mysqld.pid
bind-address                   = 0.0.0.0

# MyISAM #
key-buffer-size                = 32M
myisam-recover                 = FORCE,BACKUP

# SAFETY #
max-allowed-packet             = 128M
max-connect-errors             = 1000000
skip-name-resolve

# DATA STORAGE #
datadir                        = /data/mysql/
tmpdir                         = /data/tmp/

# CACHES AND LIMITS #
tmp-table-size                 = 32M
#max-heap-table-size            = 32M
max_heap_table_size            = 1G
query-cache-type               = 0
max-connections                = 500
connect_timeout                = 5
wait_timeout                   = 600
thread-cache-size              = 50
open-files-limit               = 65535
table-definition-cache         = 4096
table-open-cache               = 10240

# INNODB #
#innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 512M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 10G

# LOGGING #
log-error                      = /var/log/mysql/mysql-error.log
#log-queries-not-using-indexes  = 0
#slow-query-log                 = 1
#long_query_time                = 1
min_examined_row_limit         = 1000
#slow-query-log-file            = /var/log/mysql/mysql-slow.log

innodb_monitor_enable=all
performance_schema=ON

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"