如果你的数据不是很大,用mysqldump吧,更好些。 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 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.
页:
[1]