A definitive guide to run Influxdb QL with Raspberry Pi 3 RPi3

In simple words, everything works flawleslly at first installation. Soon enough, the database grow and high RAM usage appear. The problem emerge due to 32bit version. If you like to use 64bit, you need to migrate to Flux language.

Just use an external drive to store your database.

$ tree
.
├── config
│   └── influxdb.conf
└── docker-compose.yml

$ cat config/influxdb.conf 
[meta]
  dir = "/var/lib/influxdb/meta"

[data]
  dir = "/var/lib/influxdb/data"
  engine = "tsm1"
  wal-dir = "/var/lib/influxdb/wal"
  index-version = "tsi1"
  cache-max-memory-size = "500m"
  tsm-use-seek = true
  wal-fsync-delay = "0s"
  max-concurrent-compactions = 1
[monitor]
  store-enabled = false

[http]
  auth-enabled = true
  log-enabled = false   
  pprof-enabled = true
  pprof-auth-enabled = true 
  ping-auth-enabled = true
  flux-enabled=true

$ cat docker-compose.yml
services:
  influxdb:
    image: quay.io/thomasjungblut/influxdb-arm32:287e3ed6
    container_name: influxdb-32
    restart: always
    ports:
      - '8086:8086'
    volumes:
      - /home/user/External/influxdb-storage-32:/var/lib/influxdb
      - /home/user/docker/influxdb-32/config:/etc/influxdb
      - /home/user/External/influx-backup-32:/tmp/backup
    environment:
      - INFLUXDB_ADMIN_USER=your_username
      - INFLUXDB_ADMIN_PASSWORD=your_password
    logging:
      options:
        max-size: "100m"
        max-file: "3"

influxdata/influxdb#12362 (comment)

Big thanks to https://github.com/simonvetter for keeping the forked branch https://github.com/simonvetter/influxdb/tree/1.8.10+big_db_32bit Thanks https://github.com/raoulbhatia and https://github.com/thomasjungblut, for the docker image.

thalesmaoa/influxdb_docker_rpi3.md