Top reasons node recovery using SST fails
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. -
Wrong configuration?
Make sure the my.cnf files are identical, the only thing that must be different is
wsrep_node_address=...
and, yes, it should be set to an ip/hostname
Also you can set:
wsrep_provider_options='gcache.size=<size of your database>'
e.g:
wsrep_provider_options='gcache.size=64G'
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.
Comments
0 comments