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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
