Skip to content

Instantly share code, notes, and snippets.

@thalesmaoa
Last active June 12, 2024 09:18
Show Gist options
  • Save thalesmaoa/a707257ddb0113b7b343fae3ca608199 to your computer and use it in GitHub Desktop.
Save thalesmaoa/a707257ddb0113b7b343fae3ca608199 to your computer and use it in GitHub Desktop.
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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment