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.
[*] See the first footnote here: