Operations¶

Backup¶

Backupninja¶

Backupninja is running everyday at 23:30 doing incremental backups while retaining 60 days of history. It backups important files and directories and the InfluxDB and Grafana databases:

include = /opt
include = /srv
include = /var/www
include = /var/lib/mosquitto
include = /var/lib/grafana
exclude = /var/lib/grafana/sessions

InfluxDB¶

Basics¶

influx_databases=$(influx --execute 'show databases;' -format 'csv' | awk -F, '{ print $2 }' | tail -n +2)
influxd backup -database "${database}" "/var/backups/influxdb/snapshots/${database}"

Backupninja handler¶

A Backupninja handler for backing up all InfluxDB databases:

# -*- mode: sh; sh-basic-offset: 3; indent-tabs-mode: nil; -*-
# vim: set filetype=sh sw=3 sts=3 expandtab autoindent:
#
# InfluxDB backup handler script for backupninja
#
# 2016-01-27 Andreas Motl <andreas.motl@elmyra.de>
#
getconf backupdir /var/backups/influxdb
getconf databases "$(influx --execute 'show databases;' -format 'csv' | awk -F, '{ print $2 }' | tail -n +2)"
getconf method snapshot

status="ok"

[ -d $backupdir ] || mkdir -p $backupdir
[ -d $backupdir ] || fatal "Backup directory '$backupdir'"

snapshotdir="$backupdir/snapshots"
[ -d $snapshotdir ] || mkdir -p $snapshotdir

names=(${databases})
info "Backing up ${#names[@]} InfluxDB databases\n${databases}"

for database in $databases; do

      execstr="influxd backup -database '${database}' '$snapshotdir/${database}'"

      if [ $test ]; then

         info "Pretending to backup InfluxDB database '${database}'"
         debug "$execstr"

      else

         debug "$execstr"
         output=`su root -c "set -o pipefail ; $execstr" 2>&1`
         code=$?
         if [ "$code" == "0" ]; then
            debug $output
            info "Successfully finished InfluxDB backup of $database"
         else
            warning $output
            warning "Failed InfluxDB backup of $database"
         fi

      fi
done

return 0