Compatibility Matrix

The following table below outlines the various tools for backing up MariaDB database, along with their respective supported features and options.

Backup Tool

Supported OS

Operation

All Database

Specific Database

Specific Table

Mariabackup

Linux

Backup

Full backup, Incremental backup(Chained Differential)

Full backup only

Full backup only

Recovery

Full Recovery, Incremental Recovery, PITR

Full Recovery

Full Recovery Only

Mydumper

Linux

Backup

Full backup, Incremental backup(Chained Differential)

Full backup, Incremental backup(Chained Differential)

Full backup only

Recovery

Full Recovery, Incremental Recovery, PITR

Full Recovery, Incremental Recovery, PITR

Full Recovery Only

Mariadbdump

Windows & Linux

Backup

Full backup, Incremental backup(Chained Differential)

Full backup, Incremental backup(Chained Differential)

Full backup only

Recovery

Full Recovery, Incremental Recovery, PITR

Full Recovery, Incremental Recovery, PITR

Full Recovery Only

LVM

Linux

Backup

Full backup

NA

NA

Recovery

Full Recovery

NA

NA

Backup types-

  • Full Backup: A complete copy of all data from the selected databases will be taken.

  • Incremental Backup: Only the data that has changed since the last backup will be captured.

During the backup the dedupe will be enforced only changed data will be backed up.

Recovery types-

  • Full Recovery: Restores all data from the full backup snapshot, returning the database to its exact state at the time of the full backup.

  • Incremental Recovery: Restores all data from the full backup, plus all incremental backups taken up to the selected incremental backup, bringing the database up to date as of the selected incremental backup.

  • Point-in-Time Recovery (PITR): Restores all data from the full backup, plus all incremental backups taken up to a specific timestamp, allowing you to recover the database to a precise point in time.

Last updated

Was this helpful?