Hello, I have a mysql galera cluster with 5 nodes. My version is 8. Before installing this structure, I had mysql galera cluster 5.6 version with 3 nodes. I transferred the database from 5.6 to 8 using the dump restore method. There is a deadlock problem in my 5-node gallery cluster. How can I solve this problem? What is the problem causing this?
I list the system’s resources below.
OS : Red Hat Enterprise Linux 8.8 (Ootpa)
Ram : 16GB
vCPU : 10
I am sharing the Mysql configuration.
innodb_log_files_in_group = 2
innodb_autoinc_lock_mode = 2
innodb_log_file_size = 256M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_buffer_pool_size = 4G
innodb_log_buffer_size = 64M
innodb-read-io-threads = 8
innodb-write-io-threads = 8
innodb-buffer-pool-instances = 16
innodb_autoinc_lock_mode = 2
tmp_table_size = 64M
max_heap_table_size = 64M
max_connections = 2000
thread_cache_size = 512
open-files-limit = 65535
table_definition_cache = 7000
table_open_cache = 7000
max_allowed_packet = 5G
wsrep_applier_threads = 16
wsrep_certify_nonPK = 1
wsrep_max_ws_rows = 131072
wsrep_max_ws_size = 1073741824
wsrep_debug = 0
wsrep_retry_autocommit = 5
wsrep_auto_increment_control = 0
auto_increment_increment = 6
auto_increment_offset = 1
wsrep_sync_wait = 0
wsrep_log_conflicts = 1
wsrep_sst_donor_rejects_queries= 0
wsrep_provider_options = “pc.recovery=TRUE;pc.weight=2;gmcast.segment=1;socket.ssl_compression=no;gcache.keep_pages_size=4;gcache.page_size=128M;gcache.size=5024M;evs.send_window=1024;evs.user_send_window=1024; evs.use_aggregate = true; gcs.fc_factor = 1; gcs.fc_limit = 500; gcs.max_packet_size = 2097152;gcs.fc_debug = 0; evs.inactive_check_period = PT10S; evs.inactive_timeout = PT1M; evs.suspect_timeout = PT30S; evs.stats_report_period = PT1M; evs.info_log_mask = 0; evs.install_timeout = PT1M; evs.join_retrans_period = PT2S; evs.keepalive_period = PT3S; evs.max_install_timeouts = 3; evs.use_aggregate = true; evs.version = 0; evs.view_forget_timeout = PT5M; gcache.dir = /var/lib/mysql; gcache.name = /var/lib/mysql/galera.cache; gcs.fc_debug = 0; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.time_wait = PT5S; gmcast.version = 0; pc.checksum = true; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.version = 0; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3”
Can you support?