暂无图片
Xtrabackup全备期间执行DDL
我来答
分享
佳佳
2021-08-31
Xtrabackup全备期间执行DDL

如图,Mysql 5.7,在做Xtrabackup全备时候,执行了一条DDL(add column),备份结果说不是一个一致性备份,问下:
Xtrabackup全备过程中执行DDL,那么备份就完全不可用?可以用原理解释一下吗?

InnoDB: Last flushed lsn: 1591327780398 load_index lsn 1591437377075
InnoDB: An optimized (without redo logging) DDL operation has been performed. All modified pages may not have been flushed to the disk yet. 
PXB will not be able to make a consistent backup. Retry the backup operation

image.png

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Lucifer三思而后行
暂无图片

这篇文章应该能帮助到你:

Avoiding the “An optimized (without redo logging) DDL operation has been performed” Error with Percona XtraBackup

To avoid issues with MySQL 5.7 skipping the redo log for DDL, Percona XtraBackup has implemented three new options ( xtrabackup --lock-ddl, xtrabackup --lock-ddl-timeout, xtrabackup --lock-ddl-per-table) that can be used to place MDL locks on tables while they are copied.

image.png

希望能帮助到你~

暂无图片 评论
暂无图片 有用 0
暂无图片
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏