Node Cluster Troubleshooting

If the following error is generated:

# [ERROR] mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibraTjQe' 
(Errcode: 2 "No such file or directory")#0122018-01-31 22:26:05

This is because Galera tried to join the node to the cluster and failed. This can happen because of a permissions problem on Node 1. It cleans up all of the directories on the “joiner” node before it transfers state from the “donor” node. If it does not succeed, it will then fail to start in subsequent attempts since this directory no longer exists. Recreate the directory and then change the owner to mysql with the following commands once the permissions problem is resolved:

# mkdir /var/lib/mysql/tmp
# chown mysql.mysql /var/lib/mysql/tmp/