From: Dimitre Radoulov
Date: October 20 2012 8:22pm
Subject: Re: How to sync SLAVE to a production MASTER
List-Archive: http://lists.mysql.com/replication/2403
Message-Id: <508307F0.9000300@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 10/20/2012 07:18 PM, Marcus Bointon wrote:
[...]
> Use xtrabackup. It solves all your issues: No long lock on the master 
> Low load on the master (though it can be a little slow) Saves exact 
> snapshot file and position making restarting replication easy. Fast 
> restore on the slave Happy with both MyISAM and InnoDB 
[...]

Just to add that MyISAM tables will be locked even with xtrabackup* (and 
with MEB too).
However, as already stated, most likely the backup/lock time will be 
shorter (compared to mysqldump), so it's worth trying.



Regards
Dimitre

[*] See the first footnote here: 
www.percona.com/doc/percona-xtrabackup/intro.html