标题: xtrabackup mysql备份工具使用方法 [打印本页] 作者: s2303 时间: 2010-9-20 15:02
提示: 作者被禁止或删除 内容自动屏蔽作者: kider 时间: 2010-9-25 10:59
xtrabackup 虽然说开始出了windows版本的，但个人觉得不是很好用，然后恢复时也较麻烦些...
如果你的数据不是很大，用mysqldump吧，更好些。作者: yinshi_2 时间: 2011-5-23 17:32
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 时间: 2011-5-23 17:32
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.