What is a Backup Parachute? | Ottomatik

What is a Backup Parachute?

At a high level the Backup Parachute feature provides for very quick creation of several backup jobs for one database; easy visualization of those jobs and quick recovery if and when needed.

The Backup Parachute streamlines the setup and configuration process of adding your server to Ottomatik, and installing the necessary SSH Key + software dependencies.

Next it rolls up the configuration of hourly (if your account supports that feature), daily, weekly and monthly database backup jobs.  It uses sensible defaults for the schedules and retention settings, which you can change later if you like by editing the individual backup jobs.  If you'd like to add or remove an associated job (hourly, daily, weekly, monthly) you can just edit the Backup Parachute and add / remove a checkbox.  Changing a DB password? Just edit the Backup Parachute which will push the updated information down to the associated database backup jobs. 

The recovery process from a Backup Parachute is a very streamlined process which allows you to restore a backup very quickly.  Additionally you may restore to a different server, or different database if desired, just select the server and provide the database name.  Even if the database doesn't exist on the selected server, Ottomatik will create it for you, then restore to it.

 

Default Settings

 When creating a Backup Parachute Ottomatik uses sensible defaults for many configuration settings.  If you'd like to change these later you may do so by editing the individual jobs.  These are the defaults:

  • Backups created
    • Hourly (If plan supported)
    • Daily
    • Weekly
    • Monthly
  • Should get structure? => True
  • Should get content? => True
  • Should use drop syntax? => True
  • Flush binary logs before backup? => True
  • Include stored procedures and functions? => True
  • Include event scheduler events? => True
  • If plan supports zero-downtime options
    • Use quick option for large tables? => True
    • Skip locking the tables? => True
    • Backup using a single transaction? => True
  • If plan supports upload streaming
    • Stream the backup file upload to your archive location? => True
  • File retention detaults
    • Hourly => 24
    • Daily => 7
    • Weekly => 5
    • Monthly => 12
  • Schedule defaults (in your timezone)
    • Hourly => At the top of every hour
    • Daily => Every day at 12:15am
    • Weekly => Every Sunday at 1:30am
    • Monthly => 1st of every month at 2:45am