List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:October 20 2012 5:18pm
Subject:Re: How to sync SLAVE to a production MASTER
View as plain text  
On 20 Oct 2012, at 19:10, nik600 <nik600@stripped> 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/



Thread
How to sync SLAVE to a production MASTERnik60020 Oct
  • Re: How to sync SLAVE to a production MASTERMarcus Bointon20 Oct
    • Re: How to sync SLAVE to a production MASTERDimitre Radoulov20 Oct
  • Re: How to sync SLAVE to a production MASTERManuel Arostegui21 Oct
    • RE: How to sync SLAVE to a production MASTERRick James23 Oct