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

[复制链接]

kider

电梯直达

1^#

发表于 2013-2-19 11:46:02 | 只看该作者回帖奖励

|正序浏览 |阅读模式

出处：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也应该采用最新版。

升级