SkySQL Cloud Backup Release Notes

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:

• If two or more incremental restores on the same database are initiated within a short period of time, the restore may be successful but the success may not be reflected in the Cloud Backup console.

  • Successful restore can be verified by logging-in to the database and checking the data.

  • Since the restore status is not updated, it may not be possible to initiate additional restores for the database through the Cloud Backup console.

  • Contact SkySQL Support for assistance.

• 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.