Reasons why node recovery may fail:
Wrong file owner
all files in the mysql datadir must be owned by the mysql user
Synching large data files files (big tables)
If you use wsrep_sst_rsync, then you may want to edit your $mysqlbasedir/bin/wsrep_sst_rsync script and look for
timeout = 300
and set it to (time in seconds)
timeout = 3600
This will ensure that rsync has the chance to compare the files instead of timing out after five minutes.
Make sure the my.cnf files are identical, the only thing that must be different is
and, yes, it should be set to an ip/hostname
Also you can set:
wsrep_provider_options='gcache.size=<size of your database>'
This requires 64GB of disk space.
Socket already in use
<error message example to come>.
Reboot the server.
Please sign in to leave a comment.