Backups

Backups

Backups for CCX are handled and managed automatically. There is no further actions required by the users and there is no required inputs needed by the CCX as well from the user. The backups are triggered in the background and are available in various types:

• Full Backup
• Incremental Backup

The CCX Backup section will contain all the list of backups that were taken and also will show the backup schedules that are set by CCX to your database deployment. Below is an example of a MariaDB Cluster 10.4 with its list of backups and the available backup schedules set for this particular database deployment:

Backup Types

Full Backup

A full backup is a total copy of your entire database or your full data set of your database.

Incremental Backup

Incremental backup covers only the database transactions since the last full backup up to its current action of where the backup is running. It will contain all the change sets or last updated transactions going into your database from the last full backup.

What are the available backup types?

• MariaDB Cluster version 10.4:
  • Supports Full Backup using <strong>mariabackup</strong>. MariaDB Backup (mariabackup) is an open source tool provided by MariaDB for performing physical online backups. It is a fork of Percona XtraBackup designed to work with encrypted and compressed tables, and is the recommended backup method for MariaDB databases.
  • Supports Incremental Backup using mariabackup
• PostgreSQL 12:
  • Supports Full Backup using <strong>pg_dump</strong>. <strong>pg_dump</strong> is a utility for backing up a PostgreSQL database that creates a logical copy of your PostgreSQL database.
  • As of this time, incremental backup is not supported.
• Percona XtraDB Cluster version 5.7:
  • Supports Full Backup using xtrabackup. Percona XtraBackup is an open source tool for performing backups of MariaDB, MySQL and Percona Server databases. It performs online non-blocking (for the supported engines*), tightly compressed and secure full backups on transactional systems so that applications remain fully available for the duration of the backup window.
  • Supports Incremental Backup using xtrabackup.

Backup Scheduling

Backup schedules are set by CCX automatically. The schedules are set depends on the type of database deployment. Below are the set up schedules depending on the type of database:

MariaDB 10.4

The MariaDB 10.4 full backup schedule are set using UTC format during 12:00AM or 00:00 of the day. Whereas, the incremental are set to run in every 5 minutes since the rotation of the cron job. Full backup and incremental backup methods are taken using <strong>mariabackup</strong> command. Schedule is set on a crontab format which can be shown by an example screenshot below:

PostgreSQL 12

PostgreSQL 12 currently supports only pg_dump, which generates a logical copy of your PostgreSQL database backup. The scheduled backup is only taken at once done during the 12:00AM or 00:00 of the day. Backup type taken is a full backup which shall cover all your PostgreSQL data set.

Percona XtraDB Cluster 5.7

The Percona XtraDB Cluster 5.7 backup schedules are set using UTC format during 12:00AM or 00:00 of the day. Whereas, the incremental are set to run in every 5 minutes since the rotation of the cron job. Full backup and incremental backup methods are taken using <strong>xtrabackup</strong> command. Schedule is set on a crontab format which can be shown by an example screenshot below:

Viewing Your Backups

Viewing your Backups (full backups by default) in CCX can be done by going to Dashboard → <Select Your Database Deployment> → Backups.  The list of backups contains the following columns describe as follows:

• ID. The backup id of your backup copy. This is useful if you want to use this as a reference in case you need to share the information to your team or use it as a reference in case there’s an issue with the backup, such as addressing to Severalnines Support Team.
• Method. This is the type of backup method that is used to generate your backup.
• Type. This is the type of backup used such as full or incremental.
• Status. This is the state of your backup such as, Completed, In-Progress, or Failed.
• Started. Signifies when did the backup action has started.
• Duration. Signifies how long your backup was taken.
• Size. Signifies the size of your backup data or how large is your backup data.
• Action. Any available actions you can do for your backup. Currently, only Restore action is available.

Viewing My Incremental Backups

Viewing your incremental backups are only available on the database deployments that supports incremental. These are,

• MariaDB Cluster version 10.4
• Percona XtraDB Cluster version 5.7

The incremental backups are available upon viewing through the list of full backups. It is only viewable by clicking the <strong>+</strong> (plus) icon sign as shown below:

After you click, the list of incremental backups are shown. By default, it will show you the top-10 most latest incremental backups. You can customize this by clicking the page button just as what we have shown below: