Re: Mysql backup for large databases

[Dimitre Radoulov]

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