# # 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_provider= #wsrep_cluster_address= #binlog_format=row #default_storage_engine=InnoDB #innodb_autoinc_lock_mode=2 #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] datadir = /mnt/data log_error = /mnt/data/mysql.err.log #log_warnings = 10 log_warnings = 3 #max_allowed_packet=32M max_allowed_packet=128M slow_query_log = 1 long_query_time = 5 query_cache_size=0 binlog_format=ROW default_storage_engine=innodb innodb_autoinc_lock_mode=2 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=3G max_connections=2000 max_connect_errors=100000 event_scheduler=on wsrep_on=ON wsrep_provider=/usr/lib64/galera/libgalera_smm.so #wsrep_cluster_address="gcomm://10.134.18.4,10.134.18.5,10.134.19.4" wsrep_cluster_address="gcomm://10.134.18.4,10.134.18.5,10.134.19.4,10.134.18.25" wsrep_cluster_name='tgs_cluster_p' wsrep_node_address='10.134.18.4' wsrep_node_name='azabnl-id03' wsrep_sst_method=rsync wsrep_sst_auth=cluster:51iPJvAkwsC8LCCak3c9LpKUvl75pc ssl-ca=/etc/my.cnf.d/ca-cert.pem ssl-cert=/etc/my.cnf.d/server-p-cert.pem ssl-key=/etc/my.cnf.d/server-p-key.pem plugin-load-add=file_key_management.so file_key_management_encryption_algorithm=AES_CTR file_key_management_filename = /mnt/data/keys.txt # This group is only read by MariaDB-10.0 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.0]