[MDEV-13833] implement --innodb-track-changed-pages Created: 2017-09-18  Updated: 2023-10-12

Status: Open
Project: MariaDB Server
Component/s: Backup, Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Andrii Nikitin (Inactive) Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-10798 Implement ALL user statements for han... Closed
relates to MDEV-14992 BACKUP: in-server backup Open
relates to MDEV-12472 InnoDB should accept XtraDB parameter... Closed

 Description   

The feature is critical for quick incremental backups (e.g. of huge tables).

(Xtradb has this feature, which allows quick incremental backups with mariabackup 10.1 ).



 Comments   
Comment by Ralf Gebhardt [ 2023-10-12 ]

I have removed the fixVersion for this task as it is one of 5.5, 10.1, 10.2, 10.3, which are EOLed.

Please add a new fixVersion if you plan to work on this task for a not EOLed versions.

Comment by Marko Mäkelä [ 2023-10-12 ]

This could be considered as part of MDEV-14992.

A trivial way of implementing this would be to just use the InnoDB redo log, and implement something like

SET GLOBAL innodb_log_file_archive=@@last_backup_end_lsn;

so that any log that was written since the last successfully completed backup would be archived, and an incremental backup based on simply copying that log would be possible.

Ideally, I would remove other types of executing incremental backup.

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