mysqldump import = deadlock?

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

I have a default install of Percona XtraDB Server version: 5.5.24-log Percona XtraDB Cluster (GPL), wsrep_23.6.r341.

The environment is 4 node, OEL 5.5 VM with 6GB (4GB allocated to MySQL).

These are the my.cnf variables pertaining to galera:

wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=gcomm://
wsrep_slave_threads=8
wsrep_sst_method=rsync
wsrep_cluster_name=percona_cluster
binlog_format=ROW
default_storage_engine=InnoDB

Anytime I try to import a mysqldump import, no matter the size - from 12MB to 8GB so far, I get a deadlock error and the import stops.

Am I missing something easy here?

2

Hello,

That should not be a problem, but some remarks:

  • check the size of your transaction logs (innodb_log_file_size)
  • do you import in one single transaction ?
  • you should try to have odd number of nodes (for quorum), but that’s is of course not the problem.

What I would try is:
perform the import with only one node active and then join the other nodes and let them do their SST.

regards,