From: Marcus Bointon
Date: January 19 2012 12:02pm
Subject: Re: Slow Slave Replication Catchup
List-Archive: http://lists.mysql.com/replication/2307
Message-Id: <6E80B36C-87FC-4365-A360-B0548CD47895@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1251.1)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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
--=20
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/