xtrabackup mysql备份工具使用方法

只看该作者 · 发表于 2010-9-20 15:02:14

提示: 作者被禁止或删除内容自动屏蔽

kider · 发表于 2010-9-25 10:59:58

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

yinshi_2 · 发表于 2011-5-23 17:32:03

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:39

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.

帐号		自动登录	找回密码
密码			注册

s2303 该用户已被删除	电梯直达 1^# 发表于 2010-9-20 15:02:14 \| 只看该作者 \|倒序浏览 \|阅读模式提示: 作者被禁止或删除内容自动屏蔽
s2303 该用户已被删除	分享到: QQ好友和群 QQ空间腾讯微博腾讯朋友微信收藏0 淘帖0 顶0 踩0
	回复使用道具举报提升卡置顶卡沉默卡喧嚣卡变色卡千斤顶显身卡

[XtraBackup] xtrabackup mysql备份工具使用方法