Zombie Node

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

I have a 6 node cluster that was running well ,
Unfortunately the other day one of the servers had a lockup , still pingable but not reachable ,
Until I killed the node the entire cluster was locked and was unable to make any queries ,
Version I am using is Percona-XtraDB-Cluster 56-5.6.22-25.8.978
once the Node was disabled the services retuned to normal

Has anybody experienced this before and a possible solution to stop it happening again .

Regards

Darren

2

By ‘unable to make any queries’ do you mean SELECTs too?
If one node is locked in a cluster, which means it’s still a valid member, has communication to other nodes working, but for some reason it is unable to apply writes, a Flow Control mechanism will fire up, which eventually will pause writes on all other nodes. This is in order to prevent too much replication lag in a cluster. See more details here:
[url]https://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/[/url]