From: Marcus Bointon Date: October 20 2012 5:18pm Subject: Re: How to sync SLAVE to a production MASTER List-Archive: http://lists.mysql.com/replication/2402 Message-Id: <6EC9EB0E-453B-4817-898C-71C1DF6DA8AF@synchromedia.co.uk> MIME-Version: 1.0 (Mac OS X Mail 6.2 \(1499\)) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit On 20 Oct 2012, at 19:10, nik600 wrote: > Or is there another solution? 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 Marcus -- Marcus Bointon Synchromedia Limited: Creators of http://www.smartmessages.net/ UK info@hand CRM solutions marcus@stripped | http://www.synchromedia.co.uk/