[MDEV-13563] lock DDL for mariabackup in 10.2+ Created: 2017-08-17  Updated: 2018-07-24  Resolved: 2017-09-12

Status: Closed
Project: MariaDB Server
Component/s: Backup
Fix Version/s: 10.2.9

Type: Task Priority: Major
Reporter: Vladislav Vaintroub Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MDEV-13802 mariabackup --lock-ddl-per-table fail... Closed
causes MDEV-13825 mariabackup --lock-ddl-per-table does... Closed
Relates
relates to MDEV-13564 TRUNCATE TABLE and undo tablespace tr... Closed
relates to MDEV-16809 Allow full redo logging for ALTER TABLE Closed
relates to MDEV-14545 Backup fails due to MLOG_INDEX_LOAD r... Closed

 Description   

In MySQL 5.7 (and MariaDB 10.2.2 onwards), the InnoDB redo log is not self-contained with respect to some DDL operations.
Most notably, WL#7277 disables the redo logging of data pages in the initial phase of ALTER TABLE…ALGORITHM=INPLACE. (The online_log apply is still being redo-logged.) The presence of a MLOG_INDEX_LOAD record indicates that some data was omitted from the redo log.

Percona implements a workaround. We should look at their implementation.

MDEV-13564 mentions another class of operations that makes the redo log not self-contained: TRUNCATE TABLE and undo tablespace truncation.


Generated at Thu Feb 08 08:06:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.