Back up and Restore

To prevent data loss, Accelerator automatically backs up your database.

Backup

The Backup feature creates automatic as well as on-demand backups of entire databases. Automatic backups are created every day at 2:00 AM UTC. If you prefer another time for automated backups, the Vertica operations team can update the time for you. All backups will be created and stored at the same communal storage location as the database.

Restore

With Restore, you can create copies of specific database tables as required. Eight of the most recent backups per database will always be available for restoration. If you prefer having a higher number of backups available, the Vertica operations team can update the limit for you. You can either specify table names to restore or choose to restore all the tables from a specific backup.

Prerequisites

In order to restore tables to a database, check the following:

• All backup and restore operations require the primary subcluster to be up.

• To avoid failures, Accelerator requires you to disable elastic autoscaling and idle stop before backup and restore operations. Also make sure to not have any scheduled jobs, edit instance, resize subcluster, create subcluster, or drop subcluster operations during the same period.

• Restore requires the current number of nodes in the primary subcluster to be equal to that of the backup being restored. In case of a mismatch, first, update the current number of nodes.

• Restore requires the Vertica version of the backup be the same as that of the current database. In case of a mismatch, the Vertica operations team can update it for you.

• Note: Vertica advises you to adjust your databases’ autoscaling policies as needed to make sure that automatic backups are created as scheduled.

Steps

1. Select the Backup & Restore option from the database’s More menu (more_vert).

2. Select Backup now to create a new backup. A new backup will be added with the name format backup_snapshot_<YYYYMMDD>_<HHMMSS> to the ‘Recent backups’ list.\ (YYYY = year, MM = month, DD = date, HH = hours, MM = minutes, and SS = seconds in UTC)

3. To restore, select Restore for the backup to be restored from the list of ‘Recent backups’.

4. Enter the required table names in the format backup_snapshot_<YYYYMMDD>_<HHMMSS>.<tablename> or select the Restore all tables checkbox.\ (YYYY = year, MM = month, DD = date, HH = hours, MM = minutes, and SS = seconds in UTC).

5. Select Restore. This may take a few minutes.\ Note: While the table(s) being restored may not be available until the restore is completed, the other tables remain available for use.