Skip to content

VIP Dashboard

Backups

Database backups for a VIP Platform environment can be viewed and accessed in the Backups panel of the VIP Dashboard. Database backups are useful for internal security policies, to automate regular data ingestion for analysis systems, and can be imported to local development environments.

  • Databases for production environments are backed up every hour, including custom tables, and non-production databases are backed up daily.
  • Backups are encrypted at rest before being replicated to Amazon AWS S3 utilizing encryption in transit and retained for 30 days.
  • Backup SQL database download files are in a gzip-compressed plain text format with the file extension *.sql.gz.

Prerequisites

View database backups

Database backups are listed chronologically, with the most recent backup at the top of the list. A countdown is displayed near the top of the panel with the text “Next hourly backup is in [0-9]m [0-9]s“, indicating when the next backup will occur.

  1. Navigate to the VIP Dashboard for an application.
  2. Select an environment from the environment dropdown located at the upper left of the VIP Dashboard.
  3. Select the “Data” panel option at the left.
  4. Select “Database Backups”.

Download a database backup

Only one database backup file at a time can be prepared for download per environment.

  1. Navigate to the VIP Dashboard for an application.
  2. Select an environment from the environment dropdown located at the upper left of the VIP Dashboard.
  3. Select the “Data” panel option at the left.
  4. Select “Database Backups”.
  5. Select the “Generate Copy” button to the right of a database backup.
    The button label will display the text “Preparing Backup” while the database backup file is being prepared for download.
    Backup files for larger databases will take a longer time to prepare.
  6. The button label will display the text “Download” when the database backup file is ready for download.
    Select the “Download” button to download the file to the user’s local machine.
    The “Download” button will expire after 15 minutes. Downloads that are already in progress will continue after the button expires.
Screenshot example of the Backups panel with a prepared database backup file ready for download

Configure Database Backup Shipping

The Database Backup Shipping feature automatically ships database backups for an application’s production environment at regular intervals to an assigned AWS S3 bucket. To enable Database Backup Shipping, select the “Configure” button displayed in the right hand column of the Backups panel.

Last updated: April 12, 2022