Backup and Restore with MariaDB Xpand

Overview

MariaDB Xpand supports multiple backup/restore methods:

Fast Backup and Restore

  • Binary backup

  • Executed using BACKUP and RESTORE statements

  • Optimized using parallelism

  • Backups can be stored via FTP or SFTP

mariadb-dump

  • Text backup

  • Backup is stored as an SQL file

Point-in-Time Restoration (PITR)

  • Uses a binary backup and binlogs