I have a 5 node cluster. When I run backups it locks the entire cluster. I use DDL statements in a stored procedure that is used heavily. What I am trying to achieve is taking one node out of the cluster. Running the backup then adding the node back to the cluster.
How do I remove a node from a cluster?
set wsrep_cluster_address = gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62
Leaving the the node I want to backup out of the update. On the node I want to backup do I set wsrep_cluster_address:
set wsrep_cluster_address = gcomm://
Do I change the cluster name on the node as well?