List:Replication« Previous MessageNext Message »
From:Rick James Date:September 16 2013 9:50pm
Subject:RE: use rsync to fast sync a SLAVE node after a split-brain
View as plain text  
XtraBackup handles MyISAM, too.  However, it locks the system during the MyISAM part of the dump.  That is, on an InnoDB-only system, there is virtually no "downtime".

> -----Original Message-----
> From: Johan De Meersman [mailto:vegivamp@stripped]
> Sent: Monday, September 16, 2013 6:09 AM
> To: Walter Heck
> Cc: replication@lists.mysql.com; nik600
> Subject: Re: use rsync to fast sync a SLAVE node after a split-brain
> 
> ----- Original Message -----
> > From: "Walter Heck" <walterheck@olindata.com>
> > 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.
> 
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    http://lists.mysql.com/replication

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