Re: Slow Slave Replication Catchup

[Marcus Bointon]

On 19 Jan 2012, at 09:49, Richard Bensley wrote:

> Not only are they great backup tools, I also use xtrabackup to quickly
> duplicate slaves.

Absolutely - I'd even go as far as saying that xtrabackup should be the first choice for
setting up new slaves as it makes it so ridiculously easy.

Because xtrabackup doesn't block at all, you don't have to stop your slave, so you won't
accumulate lag. The other big thing about xtrabackup is that its backups can be quite
slow, but its restores are really fast (only slightly longer than copying the files).
mysqldump is usually the reverse, which is not what you want when you're in a mad panic
trying to restore a backup!

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/