SkySQL Cloud Backup Release Notes

Overview

MariaDB SkySQL Cloud Backup is a backup and recovery solution offered by MariaDB.

SkySQL Cloud Backup is currently provided as a Technical Preview and is currently free to use. Products in Technical Preview should not be used with production environments. Users of the SkySQL Cloud Backup Technical Preview are encouraged to provide feedback.

Notable Features

  • Backups, backup operations, and restore operations are managed and monitored using a web-based management console.

    • A tour is provided of Cloud Backup functionality. To begin the tour, click the "Take the Tour" button in the upper-right corner of the Cloud Backup dashboard.

    • A step-by-step configuration wizard is available for initial setup of Storage, Schedule, Retention, and Servers. To initiate setup, click the "Step by Step Wizard" button in the upper-right corner of the Cloud Backup dashboard.

  • Backup is currently supported for databases outside MariaDB SkySQL.

    • MariaDB Community Server, MariaDB Enterprise Server, MariaDB ColumnStore, and MariaDB Xpand are supported. Community Server and Enterprise Server support PITR (point-in-time recovery).

    • Full, incremental, and differential backups are supported.

    • For databases running in environments where the SkySQL Cloud Backup agent cannot be deployed, the Managed Agent can be used.

    • Backups can currently be stored to a local filesystem, to SkySQL Cloud Backup storage in GCP, or a customer-managed GCP GCS bucket or AWS S3 bucket (contents should not be manually modified).

  • For SkySQL services, nightly SkySQL backups are now known as "default backups". Default backups are visible in SkySQL Cloud Backup.

    • Default full backups have priority over customer-initiated backups, which have priority over incremental backups.

    • Default backup schedule can be changed by the customer.

    • Default backups are stored in the SkySQL managed backup service.

    • Customers can initiate an on-demand full backup to run immediately.

  • Restore is currently supported to MariaDB SkySQL cloud databases in GCP, or databases outside MariaDB SkySQL.

    • For ColumnStore, each backup event produces two backups. The mariabackup backup can be selected to restore only the non-ColumnStore tables. The columnstore backup can be selected to restore both ColumnStore and non-ColumnStore tables.

  • Schedules currently support on-demand, hourly, daily, weekly, and monthly frequency.

  • Backup retention policies can currently be set based on days or count of backups.

  • Alerting emails are triggered for failed tasks, or if an agent is offline.

Limits

SkySQL Cloud Backup is currently free to use.

SkySQL Cloud Backup is currently available as a Technical Preview. Products in Technical Preview should not be used with production environments.

The following usage limits have been established:

  • 100GB of SkySQL Cloud Backup Storage

  • 100GB of data egress

  • 5 managed agents

  • Minimum interval for on-premises incremental backups is 1 hour

Known Issues

Products in Technical Preview should not be used with production environments.

The following known issues currently exist for the SkySQL Cloud Backup Technical Preview:

  • Failed backup tasks will not immediately retry, and will be repeated only at the next scheduled time.

  • To use the mydumper backup method and myloader restore method with on-premises databases without a managed agent, the version 0.14.3 or above of the mydumper package must be manually installed.

  • SkySQL cloud databases in the asia-south1 region are not currently shown.

Unsupported Features

  • Backups to SkySQL Cloud Backup Storage on AWS S3 and restore to SkySQL cloud databases on AWS are currently unsupported.

  • binlog backups are not currently supported.

  • Custom pre-backup and post-backup scripts are not currently supported.

  • SkySQL previous release databases are not shown.

Platforms

The SkySQL Cloud Backup agent can currently be installed on:

  • Ubuntu

  • Debian

  • CentOS

  • Red Hat

  • Amazon Linux AMI

x86-64 and aarch64 architectures are supported.