SkySQL Cloud Backup Release Notes
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.
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
mariabackupbackup can be selected to restore only the non-ColumnStore tables. The
columnstorebackup 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.
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
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
mydumperpackage must be manually installed.
SkySQL cloud databases in the
asia-south1region are not currently shown.
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.
The SkySQL Cloud Backup agent can currently be installed on:
Amazon Linux AMI
aarch64 architectures are supported.