server.cnf

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]

#
# * Galera-related settings
#
[galera]
# Mandatory settings
wsrep_on			= on
wsrep_provider			= /usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name		= mariadb_cluster_1
wsrep_replicate_myisam		= off
#wsrep_cluster_address		=
wsrep_debug			= on
wsrep-sst-method		= mysqldump
binlog_format			= row
default_storage_engine		= InnoDB
bind-address			= 0.0.0.0
log-bin				= on

# Optional setting
wsrep_slave_threads		= 1

# DATA STORAGE #
datadir				= /var/lib/mysql/

# BINARY LOGGING #
log-bin				= /var/lib/mysql/mysql-bin
expire-logs-days		= 2
sync-binlog			= 1
binlog-format			= row

# LOGGING #
log-error			= /var/lib/mysql/mysql-error.log
log-queries-not-using-indexes	= 1
slow-query-log			= 1
slow-query-log-file		= /var/lib/mysql/mysql-slow.log

# INNODB #
innodb				= FORCE
innodb-strict-mode		= 1
innodb-flush-method		= O_DIRECT
innodb-log-files-in-group	= 2
innodb-log-file-size		= 128M
innodb-flush-log-at-trx-commit	= 1
innodb-file-per-table		= 1
innodb-buffer-pool-size		= 128M
innodb_autoinc_lock_mode	= 2
innodb_doublewrite		= 1

# SAFETY #
max-allowed-packet		= 16M
max-connect-errors		= 1000000
skip-name-resolve
sql-mode			= STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
sysdate-is-now			= 1

# CACHES AND LIMITS #
tmp-table-size			= 32M
max-heap-table-size		= 32M
query-cache-type		= 0
query-cache-size		= 0
max-connections			= 500
thread-cache-size		= 50
open-files-limit		= 65535
table-definition-cache		= 4096
table-open-cache		= 4096

# MyISAM
key-buffer-size			= 32M


# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.1]