Automated Backups

Overview

MariaDB SkySQL includes automated nightly backups:

  • Automated nightly backups include a full backup of every database in the service

  • Backups are stored in object storage

  • Customers can contact SkySQL Support to request a list of backups or to request backup output or logs

  • MariaDB Corporation SRE teams monitor automated backups and will contact customers if issues are detected

For details about restoring an automated backup, see "Restore an Automated Backup".

Compatibility

  • Distributed Transactions

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

Distributed Transactions

Distributed Transactions services are backed up using MariaDB Xpand's Fast Backup and Restore.

Single Node Analytics and Multi-Node Analytics

Single Node Analytics and Multi-Node Analytics services are backed up using a file copy procedure.

Single Node Transactions and Replicated Transactions

Single Node Transactions and Replicated Transactions services are backed up using MariaDB Enterprise Backup.

MariaDB Enterprise Backup implements hot online backups by breaking up the backup process into multiple stages. During most stages, locking is minimal. The design allows writes and schema changes to occur during backups.