[client-server] # # include all files from the config directory # !includedir /etc/my.cnf.d [mysqld_safe] log-error=/mysqldb/mysql.log pid-file=/mysqldb/mysql.pid [mariadb] aria-encrypt-tables encrypt-binlog encrypt-tmp-disk-tables encrypt-tmp-files loose-innodb-encrypt-log loose-innodb-encrypt-tables [galera] # Mandatory settings wsrep_on=ON wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_cluster_name="zabbix4cluster" wsrep_cluster_address="gcomm://10.144.16.30,10.144.17.31,10.152.18.30" binlog_format=row default_storage_engine=InnoDB innodb_autoinc_lock_mode=4 # Galera Synchronization Configuration wsrep_sst_method=rsync # Galera Node Configuration wsrep_node_address="10.152.18.30" wsrep_node_name="hdc-lnx-vs-0030" # # Allow server to accept connections on all interfaces. # bind-address=0.0.0.0 [mariadb] aria-encrypt-tables encrypt-binlog encrypt-tmp-disk-tables encrypt-tmp-files loose-innodb-encrypt-log loose-innodb-encrypt-tables [mysqld] innodb_file_per_table innodb_buffer_pool_size=200G innodb_buffer_pool_instances=16 innodb_flush_method=O_DIRECT innodb_log_file_size=1024M innodb_flush_log_at_trx_commit=0 innodb_io_capacity=12000 [server] datadir=/mysqldb socket=/var/lib/mysql/mysql.sock tmpdir=/mysqldb/tmp max_connections=65535 wait_timeout=10800 net_read_timeout=3600 expire_logs_days=1 query_cache_size=0 query_cache_type=0 [mariadb] log-error=/mysqldb/mariadb.log pid-file=/mysqldb/mariadb.pid