List:Replication« Previous MessageNext Message »
From:Johan De Meersman Date:September 16 2013 1:08pm
Subject:Re: use rsync to fast sync a SLAVE node after a split-brain
View as plain text  
----- 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
anyway.

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.
Thread
use rsync to fast sync a SLAVE node after a split-brainnik60016 Sep
  • Re: use rsync to fast sync a SLAVE node after a split-brainWalter Heck16 Sep
    • Re: use rsync to fast sync a SLAVE node after a split-brainJohan De Meersman16 Sep
      • RE: use rsync to fast sync a SLAVE node after a split-brainRick James16 Sep
  • Re: use rsync to fast sync a SLAVE node after a split-brainshayne.alone@gmail.com16 Sep