We don't know how to reproduce it and have no specific log files. All nodes have the same configuration, except for the ip address.
[mysqld]
wsrep_slave_threads = 8 innodb_autoinc_lock_mode = 2
# WSREP # wsrep_provider = /usr/lib64/galera3/libgalera_smm.so wsrep_cluster_address = "gcomm://10.1.1.14,10.1.1.15,10.1.1.11" wsrep_cluster_name = 'PXC Cluster' wsrep_node_address = 10.1.1.14 wsrep_node_incoming_address = 10.1.1.14 wsrep_node_name = 'db1' wsrep_sst_method = xtrabackup-v2 wsrep_sst_auth = "sstuser:pass" wsrep_sst_receive_address = 10.1.1.14 wsrep_retry_autocommit = 1 wsrep_sync_wait = 0
# General # datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock bind_address = 10.1.1.14 default_storage_engine = InnoDB lower_case_table_names = 1 ssl = false
# MyISAM # key_buffer_size = 16M myisam_recover = FORCE,BACKUP
# SAFETY # max_allowed_packet = 64M max_connect_errors = 1000000 skip_name_resolve sysdate_is_now = 1 innodb = FORCE thread_stack = 262144 back_log = 2048 performance_schema = OFF skip_show_database
# Binary Logging # #log_bin = /var/lib/mysql-binlog/mysql-bin #log_bin_index = /var/lib/mysql-binlog/mysql-bin expire_logs_days = 14 sync_binlog = 1 binlog_format = row
# Logging # slow_query_log = ON log_queries_not_using_indexes = ON long_query_time = 0.5 log_error = /var/lib/mysql/mysql.log
# CACHES AND LIMITS # tmp_table_size = 64M max_heap_table_size = 64M join_buffer_size = 8M query_cache_type = 1 query_cache_size = 512M query_cache_limit = 8M query_cache_min_res_unit = 1024 max_connections = 1000 thread_cache_size = 500 open-files-limit = 65535 table_definition_cache = 7000 table_open_cache = 7000
# InnoDB Related # innodb_autoinc_lock_mode = 2 innodb_buffer_pool_instances = 20 innodb_buffer_pool_size = 20G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_format = Barracuda innodb_file_per_table = 1 innodb_flush_log_at_trx_commit = 0 innodb_flush_method = O_DIRECT innodb_locks_unsafe_for_binlog = 1 innodb_log_file_size = 128M innodb_log_files_in_group = 2 innodb_read_io_threads = 32 innodb_write_io_threads = 32 innodb_thread_concurrency = 16
[mysqld_safe] pid-file = /run/mysqld/mysql.pid syslog
We don't know how to reproduce it and have no specific log files.
All nodes have the same configuration, except for the ip address.
[mysqld]
wsrep_slave_threads = 8 autoinc_ lock_mode = 2
innodb_
# WSREP # galera3/ libgalera_ smm.so address = "gcomm: //10.1. 1.14,10. 1.1.15, 10.1.1. 11" incoming_ address = 10.1.1.14 receive_ address = 10.1.1.14 autocommit = 1
wsrep_provider = /usr/lib64/
wsrep_cluster_
wsrep_cluster_name = 'PXC Cluster'
wsrep_node_address = 10.1.1.14
wsrep_node_
wsrep_node_name = 'db1'
wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = "sstuser:pass"
wsrep_sst_
wsrep_retry_
wsrep_sync_wait = 0
# General # mysql/mysql. sock storage_ engine = InnoDB table_names = 1
datadir = /var/lib/mysql
socket = /var/lib/
bind_address = 10.1.1.14
default_
lower_case_
ssl = false
# MyISAM #
key_buffer_size = 16M
myisam_recover = FORCE,BACKUP
# SAFETY #
max_allowed_packet = 64M
max_connect_errors = 1000000
skip_name_resolve
sysdate_is_now = 1
innodb = FORCE
thread_stack = 262144
back_log = 2048
performance_schema = OFF
skip_show_database
# Binary Logging # mysql-binlog/ mysql-bin mysql-binlog/ mysql-bin
#log_bin = /var/lib/
#log_bin_index = /var/lib/
expire_logs_days = 14
sync_binlog = 1
binlog_format = row
# Logging # not_using_ indexes = ON mysql/mysql. log
slow_query_log = ON
log_queries_
long_query_time = 0.5
log_error = /var/lib/
# CACHES AND LIMITS # min_res_ unit = 1024 n_cache = 7000
tmp_table_size = 64M
max_heap_table_size = 64M
join_buffer_size = 8M
query_cache_type = 1
query_cache_size = 512M
query_cache_limit = 8M
query_cache_
max_connections = 1000
thread_cache_size = 500
open-files-limit = 65535
table_definitio
table_open_cache = 7000
# InnoDB Related # autoinc_ lock_mode = 2 buffer_ pool_instances = 20 buffer_ pool_size = 20G data_file_ path = ibdata1: 10M:autoextend file_per_ table = 1 flush_log_ at_trx_ commit = 0 locks_unsafe_ for_binlog = 1 log_file_ size = 128M log_files_ in_group = 2 read_io_ threads = 32 write_io_ threads = 32 thread_ concurrency = 16
innodb_
innodb_
innodb_
innodb_
innodb_file_format = Barracuda
innodb_
innodb_
innodb_flush_method = O_DIRECT
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
[mysqld_safe] mysql.pid
pid-file = /run/mysqld/
syslog