[mysqld] datadir=/mysql/data/mysql socket=/mysql/data/mysql/mysql.sock open_files_limit = 8192 max_connections = 500 user=mysql binlog_format=ROW default_storage_engine=innodb innodb_autoinc_lock_mode=2 innodb_flush_log_at_trx_commit=0 wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_provider_options="gcache.size=1024M; gcache.page_size=1024M; gcs.fc_limit=1000000" wsrep_cluster_name="zabbixdb_cluster" wsrep_cluster_address="gcomm://10.10.10.10,10.10.10.20" wsrep_sst_method=rsync wsrep_on=ON wsrep_node_name=host1 wsrep_slave_threads=8 innodb_additional_mem_pool_size = 16M innodb_autoextend_increment = 256 innodb_buffer_pool_instances = 12 innodb_buffer_pool_size = 12G innodb_change_buffer_max_size = 50 innodb_concurrency_tickets = 5000 innodb_data_file_path = ibdata1:1G:autoextend innodb_file_per_table = 1 innodb_flush_method = O_DIRECT innodb_log_file_size = 512M innodb_log_files_in_group = 4 innodb_old_blocks_time = 1000 innodb_open_files = 2048 innodb_stats_on_metadata = OFF large-pages binlog-row-event-max-size = 8192 character_set_server = utf8 collation_server = utf8_bin expire_logs_days = 1 join_buffer_size = 262144 max_allowed_packet = 32M max_connect_errors = 10000 max_heap_table_size = 134217728 query_cache_type = 0 query_cache_size = 0 slow-query-log = ON table_open_cache = 2048 thread_cache_size = 64 tmp_table_size = 134217728 wait_timeout = 86400 # # This group is read both both by the client and the server # use it for options that affect everything # [client-server] # # include all files from the config directory # !includedir /etc/my.cnf.d