xtrabackup mysql备份工具使用方法

kider

xtrabackup 虽然说开始出了windows版本的，但个人觉得不是很好用，然后恢复时也较麻烦些...
如果你的数据不是很大，用mysqldump吧，更好些。

yinshi_2

2.1.1        InnoDB Hot Backup (Commercial)
2.1.1.4        Result
1.        Backup smooth, impact DB lowest
2.        After restore DB, can use binary logs to recovery DB.
3.        Can recovery to point time.
2.1.1.5        Positive
1.        Commercial edition, can get support when encounter err
2.1.1.6        Negative
4.        The backup data need manual compress, occupy more storage
5.        Need more CPU, will impact DB load while backup
6.        After backup innodb data, need to backup .frm more

yinshi_2

2.1.2        XtraBackup (Open Source, Free)
2.1.2.6        Result
1.        Backup smooth, impact DB lowest
2.        After restore DB, can use binary logs to recovery DB.
3.        Can recovery to point time.
2.1.2.7        Positive
1.        Can compress backup file while backup, so it’s occupy fewer storage
2.        Support increment backup
3.        Need lower CPU
2.1.2.8        Negative
1.        After backup innodb data, need to backup .frm more
2.        When encounter err need buy support or research the code.