----- Original Message -----
> From: "Walter Heck" <walterheck@stripped>
> Subject: Re: use rsync to fast sync a SLAVE node after a split-brain
> If you use xtrabackup you can do this non-blocking, giving you a bit
> more time.
Only for InnoDB tables, though, iirc?
I think OP's original procedure is fairly spot-on, and yes, it should be ok to just do a
global read lock instead of shutting down for the second rsync - although InnoDB doesn't
quiesce entirely, so depending on how busy the server is shutting down may be recommended
I'd also restart the master before the slave, though, and you of course need the master's
log position at rsync time to resume the slave :-)
Unhappiness is discouraged and will be corrected with kitten pictures.