From: Marcus Bointon
Date: April 4 2012 9:08am
Subject: Re: discrepancy on a single table
List-Archive: http://lists.mysql.com/replication/2335
Message-Id: <764E048D-0B9E-45A1-836E-3C38EED8CDEA@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1257)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

On 4 Apr 2012, at 10:07, nhadie ramos wrote:

> i have tried xtrabackup before but not for a single table. tried it
> for my whole DB, the prob i have is that it locks the tables which i
> cant afford doing on the live server

Xtrabackup only holds a read-lock on non-transactional tables - if you =
are InnoDB-only it doesn't do any locking at all. Also take a look at =
the --no-lock option to see if you can work with that.
AFAIK mysqldump with --single-transaction will still read-lock =
non-transactional tables for the duration of the backup. It's possible =
to turn off read lock for MyISAM backups, but you'll end up with an =
inconsistent 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/