#[root@mdb1 my.cnf.d]# cat /etc/my.cnf.d/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] log_warnings = 4 log_error=/var/lib/mysql/error.log # # * Galera-related settings # #[galera] # 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.3 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.3] [galera] #galera settings binlog_format=row wsrep_on=ON wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_cluster_address="gcomm://10.0.1.13,10.0.1.14,10.0.1.15" #wsrep_cluster_address="gcomm://" wsrep_cluster_name="n4tdb01_wsrep_cluster" wsrep_node_address='10.0.1.13' wsrep_node_name='mdb1' wsrep_slave_threads=32 #wsrep_provider_options="gcs.fc_limit=480;gcs.fc_factor=0.8" wsrep_provider_options="gcache.size=1G" wsrep_certification_rules='optimized' wsrep_retry_autocommit=5 wsrep_sst_auth=sstuser:ciccio wsrep_sst_method=mariabackup innodb_autoinc_lock_mode=2 [sst] compressor='pigz -p 8' decompressor='pigz -dc -p 8' inno-backup-opts="--parallel=8"