List:Replication« Previous MessageNext Message »
From:Dimitre Radoulov Date:October 20 2012 8:22pm
Subject:Re: How to sync SLAVE to a production MASTER
View as plain text  
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

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