From: Marcus Bointon
Date: December 10 2009 7:49pm
Subject: Re: best practice - restore slave
List-Archive: http://lists.mysql.com/replication/1758
Message-Id: <0F6F5D70-0565-40E4-9D54-2F5F6B3C86B8@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1077)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

On 10 Dec 2009, at 20:35, Song Voong wrote:

> My question is while the master is running is it a good ideas to do =
the
> dump? Or do I need to stop all activities on master to do the dump?

It's safe if you lock tables while doing the dump, but then clients =
won't be able to write to the DB. If you don't do this, you can end up =
with inconsistent data as the database can change during the dump. =
Alternatively if you're using innodb tables you can use a hot backup =
system like xtrabackup, which can take a consistent backup without =
blocking write access to the master, and has the added benefit that the =
restore on the slave is more or less instant.

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