#
# 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-4/libgalera_smm.so
wsrep_cluster_address="gcomm://myhost.mydomain,myhost2.frd.shsdir.nl,myhost3.frd.shsdir.nl"
wsrep_cluster_name=cl01
wsrep_node_address="myhost.mydomain:4567"
wsrep_node_name=myhost
wsrep_sst_method=mariabackup
wsrep_sst_auth=repluser:secret
wsrep_provider_options="socket.ssl_key=/etc/pki/mariadb/myhost.mydomain.key;socket.ssl_cert=/etc/pki/mariadb/myhost.mydomain.crt;socket.ssl_ca=/etc/pki/ca-trust/source/anchors/fedservdb-ca.crt;socket.ssl_cipher=AES256-SHA;gmcast.segment=1;gcache.size=1G;cert.log_conflicts=YES"
wsrep_retry_autocommit = 2
wsrep_slave_threads = 4
wsrep_log_conflicts=ON

#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0

# 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]
socket = /tmp/mariadb.sock
ssl-ca = /etc/pki/ca-trust/source/anchors/fedservdb-ca.crt
ssl-key = /etc/pki/mariadb/myhost.mydomain.key
ssl-cert = /etc/pki/mariadb/myhost.mydomain.crt
binlog_format=ROW
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
query_cache_size=0
query_cache_type=0
bind-address=0.0.0.0
log_warnings=2
datadir=/apps/database/mariadb
max_connections = 2000
skip-external-locking
skip-name-resolve
max_allowed_packet = 256M
table_cache = 4096
read_buffer_size = 4M
thread_cache_size = 8
query_cache_size = 96M
query_cache_limit = 2M
query_cache_type = 1
thread_cache_size = 8
sort_buffer_size = 16M
wait_timeout=28800
query_prealloc_size=32K
read_buffer_size=20M
read_rnd_buffer_size=8M
join_buffer_size=16M

# * InnoDB settings
innodb_log_file_size=100M
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_data_file_path = ibdata1:32M:autoextend
innodb_log_buffer_size = 4M
innodb_flush_method = O_DIRECT
innodb_open_files = 600
innodb_flush_log_at_trx_commit = 2
innodb_doublewrite = 0

# Character set UTF-8
init_connect = 'SET collation_connection = utf8_unicode_ci'
init_connect = 'SET NAMES utf8'

sql_mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# this is the config used by the normal mysql service
[mysqld_safe]
syslog

[sst]
encrypt = 4
ssl-ca = /etc/pki/ca-trust/source/anchors/my-ca.crt
ssl-cert = /etc/pki/mariadb/myhost.mydomain.crt
ssl-key = /etc/pki/mariadb/myhost.mydomain.key

# This group is only read by MariaDB-10.8 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.8]