InnoDB Hot Backup在升级MySQL5.5后的备份注意事项

kider

出处：mysqlpub.com ，转载请注明。

MySQL5.5采用的是 Barracuda 文件格式，而MySQL5.1的是 Antelope

innodb_file_format = Barracuda

老版本的热备份工具将会有问题，具体原因，官方参考手册中注明：

WARNING: Version 3.0 of InnoDB Hot Backup does not support the new Barracuda file format. Using InnoDB Hot Backup Version 3 to backup databases in this format causes unpredictable behavior. MySQL Enterprise Backup, the successor product to InnoDB Hot Backup, does support tables with the Barracuda file format. You can also back up such databases with mysqldump.

那么xtrabackup也应该采用最新版。