[mysqld] basedir = /usr bind-address = 0.0.0.0 binlog_format = ROW datadir = /var/lib/mysql default_storage_engine = InnoDB expire_logs_days = 10 innodb_autoinc_lock_mode = 2 innodb_buffer_pool_size = 6G innodb_file_per_table = 1 innodb_flush_log_at_trx_commit = 0 innodb_ft_enable_stopword = OFF innodb_ft_min_token_size = 2 innodb_locks_unsafe_for_binlog = 1 innodb_log_file_size = 128M key_buffer_size = 16M log-error = /var/log/mysql/error.log max_allowed_packet = 16M max_binlog_size = 100M max_connections = 151 max_heap_table_size = 32M pid-file = /var/run/mysqld/mysqld.pid port = 3306 query_cache_min_res_unit = 2K query_cache_size = 32M query_cache_type = 1 skip-external-locking skip_name_resolve = 1 socket = /var/run/mysqld/mysqld.sock thread_cache_size = 8 thread_stack = 256K tmp_disk_table_size = 8G tmp_table_size = 32M tmpdir = /tmp user = mysql wsrep_cluster_address = gcomm://10.0.50.61:4567,10.0.50.62:4567,10.0.50.63:4567/ wsrep_cluster_name = production wsrep_node_address = 10.0.50.62 wsrep_node_incoming_address = 10.0.50.62 wsrep_on = ON wsrep_provider = /usr/lib/galera/libgalera_smm.so wsrep_provider_options = "gcache.recover=yes; gcache.size = 128M;" wsrep_slave_threads = 8 wsrep_sst_auth = "YYYYY:XXXXXXXXXXXXXXXXXXXXXXXXX" wsrep_sst_method = mariabackup wsrep_sst_receive_address = 10.0.50.62