Skip to:
Xtrabackup version affected:
2.4.29
8.0.35
Problem:
If --lock-ddl is disabled which is default,
--lock-ddl
before load tablespace and open ibds operations from schema 1,
rename tables from schema 1 to schema 2, and rename tables back from schema 2 to schema 1 before load from schema 2,
backup are not inconsistent because some .ibds are not copied.
.ibd
With lock-ddl=OFF, it is the user's responsibility to avoid DDLs. This is why we recommend lock-ddl=ON and default is ON.
We have plans to reduce the total lock duration. Stay tuned!
How to repeat:
Create 2 databases, and create tables in one database;
Begin backup, rename tables from this database to other, and rename tables back;
Prepare backup, and check if some .ibd files are not copied.
Xtrabackup version affected:
2.4.29
8.0.35
Problem:
If
--lock-ddlis disabled which is default,before load tablespace and open ibds operations from schema 1,
rename tables from schema 1 to schema 2, and rename tables back from schema 2 to schema 1 before load from schema 2,
backup are not inconsistent because some
.ibds are not copied.