Scalingo InfluxDB Addon

Some operation requires our command-line tool to be installed.
Instructions are detailed in Command-Line Tool Documentation and installer page.

Scalingo InfluxDB addon is the official addon provided by Scalingo, details on the available plans can be found here. This addon gives your app instant access to an InfluxDB database running in its own Docker container.

Adding Scalingo InfluxDB addon to your app

You can add the InfluxDB addon through the Dashboard or through the command-line interface. The capacity of your database is elastic, you will be able to upgrade it later.

Through the Dashboard

  1. Go to your app on Scalingo Dashboard
  2. Click on Addons tab
  3. Select the addon you want to add
  4. In the dialog select the database plan you need
  5. Validate your choice

Through the command-line interface

$ scalingo -a example-app addons-add scalingo-influxdb 1g

-----> Addon scalingo-influxdb has been provisionned
       ID: sample_influxdb_3707
       Modified variables: [INFLUX_URL SCALINGO_INFLUX_URL]
       Message from addon provider: Database successfully created

This command will provision the application sample-influxdb with a 1g InfluxDB database plan.

To find out what other plans are available:

$ scalingo addons-plans scalingo-influxdb

Getting your connection URI

Once the addon is provisioned, 2 environment variables are added to your app: SCALINGO_INFLUX_URL and INFLUX_URL. INFLUX_URL is an alias to SCALINGO_INFLUX_URL. To find out how to use it in your code please refer to Application environment.

In most cases, you can pass the variable directly to the client library you are using in your code. But sometimes the library requires a specific URI format, you’ll need to add a little bit of code to suit the library.

You can get environment variables from the Dashboard or the command-line interface.

From the Dashboard

  1. Go to your app on Scalingo Dashboard
  2. Click on Environment tab
  3. SCALINGO_INFLUX_URL is displayed

From the command-line interface

$ scalingo --app sample-influxdb env

INFLUX_URL=$SCALINGO_INFLUX_URL
SCALINGO_INFLUX_URL=http://sample_influxdb_3707:RCtlmiQDXuXosYJ4mIOP@sample-influxdb-3707.influxdb.dbs.appsdeck.eu:31061/sample_influxdb_3707

Remote access your database

If you need to access your database from other places than your app please follow the Access your database guide.

Changing plans

You can upgrade or downgrade your database plan whenever you need it. This operation happens instantly thanks to Docker containers and no manual input is required. When you change the plan, your database will be stopped then simply restarted on a new host with new parameters of the chosen plan. During the operation the connection is dropped bewteen your app and the database. Finally, after the operation is successful, the related app will be restarted.

From the Dashboard

  1. Go to your app on Scalingo Dashboard
  2. Click on Addons tab
  3. Select the addon you want to change
  4. In the dialog select the plan you want to upgrade/downgrade to
  5. Validate your choice

From the command-line interface

To upgrade or downgrade your addon the sub-command is the same: addons-upgrade.

$ scalingo --app sample-influxdb addons-upgrade sample_influxdb_3707 2g

In this example, sample_influxdb_3707 is the ID of the addon, and 2g is the plan we want to upgrade to.

To find out the addon ID:

$ scalingo --app sample-influxdb addons 

+-------------------+----------------------+------+
|       ADDON       |          ID          | PLAN |
+-------------------+----------------------+------+
| Scalingo InfluxDB | sample_influxdb_3707 | 1g   |
+-------------------+----------------------+------+

Database dashboard

The Scalingo InfluxDB dashboard is the central place for administrative tasks such as:

  • Monitor database and system stats
  • Upgrade the database engine version
  • Activate database specific features
  • Manage database users
  • Manage backups

Database Upgrade

When the database vendor releases a new version of your database engine, we will try to provide it as soon as possible. You will have the choice to upgrade your database with just one click through your database dashboard.

This operation is similar to changing your database plan; your database will be stopped and restarted with new database environment. Thanks to Docker containers this happens seamlessly and quickly without manual action. When this operation finishes, your application will be restarted.

Beware that no downgrade is possible once your database has been upgraded.

Container Stats

CPU usage Current CPU usage.
Memory usage Display the current, hightest and free memory. Highest is the maximum memory recorded since database restarted.
Swap usage Display the current, hightest and free swap. Highest is the maximum swap recorded since database restarted.

Database Stats

Data size Size of your data provided by InfluxDB
Database on disk size Effective physical space used.

Backups

If your database is in a paid plan (i.e. It’s not “free plan”), we’ll make automated backups of your database on a daily basis, at around 1 AM Central European Time (CET or UTC+0100). However, we don’t keep those backups forever. The following rules are applied for backups storing:

  • Everyday for the past 30 days (1 month)
  • One per week during the 2nd and 3rd months
  • One per month during the 4th, 5th and 6th months

Download automated backups

Automated backups are listed in the database specific dashboard.

  1. Go to your app on Scalingo Dashboard
  2. Click on Addons tab
  3. Click Link to dashboard which will take you to the Scalingo InfluxDB dashboard
  4. Click on Backups tab
  5. Download the backup you want

Restoring a backup

Follow our guide: How to dump and restore my InfluxDB database on Scalingo

Add Retention Policies

InfluxDB provides a way to automatically delete records older than a certain date called retention policy:

CREATE RETENTION POLICY "one_hour" ON "tweets" DURATION 1h REPLICATION 1 DEFAULT

Creating retention policy is not available to simple database users. If you wish to create one, you can log into your database dashboard, and go to the “Advanced” tab.

schedule 03 Mar 2017