This add-on is operated by Quantum Gears

Automatic backup service for PostgreSQL and MySQL

Autobus

Last updated 08 July 2016

Autobus is an add-on for providing a simple-to-use automatic backup service for PostgreSQL (Heroku Postgres) and MySQL (ClearDB, JawsDB) databases. Autobus gives you the following:

• Smart automation — You can schedule daily backups to minimize load on your application database.

• Cross-continental backup — For applications that are hosted in the US, snapshots are stored in the EU region and the other way round.

• Data integrity verification — All snapshots are tested for restorability and you’ll be notified if anything goes wrong.

• Full control — You can entirely rule backup process. Exclude tables, select dump options and manage snapshots via web dashboard or RESTful API.

• Detalization — Autobus provides brief database statistics for each snapshot. You can monitor the changes in your database day by day.

• Quick start — You need just a few clicks to get a fully functional automatic backup system. No code and configs, just an easy-to-use web dashboard.

Provisioning the add-on

Autobus can be attached to a Heroku application via the CLI:

$ heroku addons:create autobus
-----> Adding autobus to sharp-mountain-4005... done, v18 (free)

After installation you need to log into the Autobus dashboard via the CLI:

$ heroku addons:open autobus
Opening autobus for sharp-mountain-4005…

or by visiting the Heroku Dashboard and selecting the application in question. Select Autobus from the Add-ons menu.

Autobus automatically fetches your databases via the Heroku Platform API so the first time you visit the Autobus dashboard you will be redirected to the authorization page where you need to allow access to read your configuration variables.

Now you have a working automatic backup system. It’s also a good idea to look through default preferences on the Settings tab and personalize them if necessary.

Backups Retention Limits

Monthly snapshots are disabled by default, you can enable it on the “Settings” tab (section “Monthly backups”) in the Autobus dashboard.

Restore to local database

You can download any snapshot from the Autobus dashboard and restore it into your local database.

PostgreSQL

$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb DATABASE_54d4041969702d0295380301.dump

MySQL

$ gzip -d -c DATABASE_54d4041969702d0295380301.sql.gz | mysql -h localhost -uuser_name -ppassword db_name

API

Autobus provides the simple RESTful API to access your snapshots via any http-client. By default it’s disabled. Before use you need to enable it on the “Settings” tab (“Account settings” section) in the Autobus dashboard. In the same section you can find your personal API token.

List all snapshots

URL: "https://www.autobus.io/api/snapshots"
Method: "GET"
Content-Type: "application/json"
Parameters: {"token": "YOUR_API_TOKEN"}
Response Body: [{"id":"550bb45669702d21bd430000", "kind":"Daily", "created_at":"2015-03-20T05:47:03.592Z", ...}, ...]

Get the latest snapshot URL

URL: "https://www.autobus.io/api/snapshots/latest"
Method: "GET"
Content-Type: "application/json"
Parameters: {"token": "YOUR_API_TOKEN"}
Response Body: "https://autobus-us.s3.amazonaws.com/PURPLE_552b383e69702d5b420f0000.dump..."

Create snapshot

URL: "https://www.autobus.io/api/snapshots"
Method: "POST"
Content-Type: "application/json"
Parameters: {"token": "YOUR_API_TOKEN", "database": "FULL_DATABASE_NAME", "description": "SNAPSHOT_DESCRIPTION"}
Response Body: {"message": "Snapshot is in progress, it may take awhile"}

Note: “database” and “description” parameters are optional.

Get information about the certain snapshot

URL: "https://www.autobus.io/api/snapshots/:snapshot_id"
Method: "GET"
Content-Type: "application/json"
Parameters: {"token": "YOUR_API_TOKEN"}
Response Body: {"id":"550bb45669702d21bd430000", "kind":"Daily", "created_at":"2015-03-20T05:47:03.592Z", ...}

Delete snapshot

URL: "https://www.autobus.io/api/snapshots/:snapshot_id"
Method: "DELETE"
Content-Type: "application/json"
Parameters: {"token": "YOUR_API_TOKEN"}
Response Body: {"message": "Snapshot has been deleted"}

Migrating between plans

Use the heroku addons:upgrade command to migrate to a new plan.

$ heroku addons:upgrade autobus:travel
-----> Upgrading autobus:travel to sharp-mountain-4005... done, v18 ($20/mo)
       Your plan has been updated to: autobus:travel

Removing the add-on

Autobus can be removed via the CLI.

$ heroku addons:destroy autobus
-----> Removing autobus from sharp-mountain-4005... done, v20 (free)

Before removing the Autobus add-on you can download recent snapshots from the dashboard.

Support

All Autobus support and runtime issues should be submitted via one of the Heroku Support channels. Any non-support related issues or product feedback is welcome at support@autobus.io.