From: Dimitre Radoulov
Date: November 1 2012 10:49am
Subject: Re: Mysql backup for large databases
List-Archive: http://lists.mysql.com/mysql/228561
Message-Id: <509253D1.3090305@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 01/11/2012 11.28, Machiel Richards - Gmail wrote:
[...]
>      I am busy investigating some options relating to the backup for 
> MySQL databases when they get quite large.
>
>     When using the MySQL enterprise, there is the option to use the 
> MySQL enterprise backup as it is part of the Enterprise license.
>
>         However, when using the GA (freely available) versions, the 
> options for backups on large databases seems to be a bit limited.
[...]

Hi Machiel,
I'm currently evaluating Percona xtrabackup for the same reasons.
A few notes:
  - backup/restore times will be definitely shorter compered to mysqldump
  - MyISAM tables will be locked for consistency during the backup (just 
like with MEB or mysqldump). This is optional, but it's required
      if you want a consistent backup
  - if I read the documentation correctly, the only way to restore a 
single database in a consolidated environment is to use the -export 
option AND percona server
     as an import server


Hope this helps
Dimitre