hang on restore dump

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

ubuntu 14.04 amd64
percona xtradb 5.6.26-74.0

I have to stop haproxy in front of percona cluster nodes, then restoring dump file would not hang on CLI/mysql client “source dump.sql;”

I already tried using perl mysqltuner, increasing net_buffer_length to 100M, max_allowed_packet = 200M with same problem.

Any suggestions?

2

What actually did you see during this “hang”? A processlist and wsrep status sample would be a good start.