[mysqld] # # Basic settings # datadir = /var/lib/mysql user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 bind-address = 0.0.0.0 # # Fine tuning # max_connections = 100 connect_timeout = 5 wait_timeout = 600 max_allowed_packet = 16M thread_cache_size = 128 sort_buffer_size = 4M bulk_insert_buffer_size = 16M tmp_table_size = 32M max_heap_table_size = 32M max_connect_errors = 100000 # # Error logging # log_warnings = 2 log_error = /var/log/mysql/error.log # # Slow query log # slow_query_log_file = /var/log/mysql/slow-query.log long_query_time = 10 log_slow_verbosity = query_plan # # InnoDB # default_storage_engine = InnoDB innodb_log_file_size = 128M innodb_buffer_pool_size = 8G innodb_log_buffer_size = 8M innodb_file_per_table = 1 innodb_open_files = 400 innodb_io_capacity = 400 innodb_flush_method = O_DIRECT innodb_file_format = BARRACUDA innodb_autoinc_lock_mode= 2 # # Binary log # binlog_format = ROW expire_logs_days = 10 max_binlog_size = 100M # # Galera cluster # wsrep_provider = /usr/lib/libgalera_smm.so wsrep_cluster_address = gcomm://1.1.1.1,2.2.2.2 wsrep_node_address = 1.1.1.1 wsrep_sst_method = xtrabackup-v2 wsrep_cluster_name = *******_cluster wsrep_sst_auth = "sstuser:*********" wsrep_provider_options = "gcache.size=10G" [mysqldump] quick quote-names max_allowed_packet = 16M [sst] #inno-apply-opts = "--use-memory=16GB" streamfmt = xbstream [xtrabackup] compress compact parallel = 8 compress-threads = 8 rebuild-threads = 8