Upgrade from InfluxDB 1.x to 2.9 with Docker

Use the automated upgrade process built into the InfluxDB 2.x Docker image to update InfluxDB 1.x Docker deployments to InfluxDB 2.x.

• Upgrade requirements
  • InfluxDB 2.x initialization credentials
  • File system mounts
  • Upgrade initialization mode
• Minimal upgrade
• Upgrade with a custom InfluxDB 1.x configuration file
• Upgrade with custom paths
• Use new InfluxDB tools
  • Migrate continuous queries to tasks
  • Use the interactive InfluxQL shell

Upgrade requirements

InfluxDB 2.x provides a 1.x compatibility API, but expects a different storage layout on disk. To account for theses differences, the InfluxDB Docker image migrates 1.x data and into 2.x-compatible data automatically before booting the influxd server.

• InfluxDB 2.x initialization credentials
• File system mounts
• Upgrade initialization mode

Find more information about the automated InfluxDB upgrade process, see Automatically upgrade from InfluxDB 1.x to 2.9.

InfluxDB 2.x initialization credentials

The automated InfluxDB upgrade process bootstraps an initial admin user, organization, and bucket required by InfluxDB 2.x. Set the following environment variables in your Docker container to provide setup credentials:

• DOCKER_INFLUXDB_INIT_USERNAME: Username to set for the admin user (Required).
• DOCKER_INFLUXDB_INIT_PASSWORD: Password to set for the admin user (Required).
• DOCKER_INFLUXDB_INIT_ORG: Name to set for the initial organization (Required).
• DOCKER_INFLUXDB_INIT_BUCKET: Name to set for the initial bucket (Required).
• DOCKER_INFLUXDB_INIT_RETENTION: Duration for the initial bucket’s retention period. If not set, the initial bucket will retain data forever.
• DOCKER_INFLUXDB_INIT_ADMIN_TOKEN: API token to associate with the admin user. If not set, InfluxDB automatically generates a token.

File system mounts

The InfluxDB upgrade process requires extra volumes to be mounted into the 2.x container. Use environment variables and Docker mounts to specify and configure the appropriate mount paths for the following:

• 1.x data on disk
• Custom 1.x configuration file (if any)
• 2.x data on disk (/var/lib/influxdb2)
• 2.x configuration directory (/etc/influxdb2)

The InfluxDB upgrade process searches for mounted 1.x data and configuration files in the following priority order:

1. 1.x configuration file specified by the DOCKER_INFLUXDB_INIT_UPGRADE_V1_CONFIG environment variable
2. 1.x data directory specified by the DOCKER_INFLUXDB_INIT_UPGRADE_V1_DIR environment variable
3. 1.x configuration file mounted at /etc/influxdb/influxdb.conf
4. 1.x data directory mounted at /var/lib/influxdb

Upgrade initialization mode

Set the DOCKER_INFLUXDB_INIT_MODE environment variable to upgrade.

Minimal upgrade

If you’re currently running a minimal InfluxDB 1.x deployment similar to:

docker run -p 8086:8086 \
  -v influxdb:/var/lib/influxdb \
  influxdb:1.8

To upgrade this minimal deployment to InfluxDB 2.x:

1. Stop the running InfluxDB 1.x container.

2. Start the InfluxDB container with the following:

   • Volume mount for the InfluxDB 1.x data directory
   • Volume mount for the InfluxDB 2.x data directory
   • InfluxDB initialization mode environment variable
   • InfluxDB initialization credential environment variables
   • influxdb:2.9 Docker image

   docker run -p 8086:8086 \
     -v influxdb:/var/lib/influxdb \
     -v influxdb2:/var/lib/influxdb2 \
     -e DOCKER_INFLUXDB_INIT_MODE=upgrade \
     -e DOCKER_INFLUXDB_INIT_USERNAME=my-user \
     -e DOCKER_INFLUXDB_INIT_PASSWORD=my-password \
     -e DOCKER_INFLUXDB_INIT_ORG=my-org \
     -e DOCKER_INFLUXDB_INIT_BUCKET=my-bucket \
     influxdb:2.9

Upgrade with a custom InfluxDB 1.x configuration file

If you’re currently running an InfluxDB 1.x deployment with a custom configuration file similar to:

docker run -p 8086:8086 \
  -v influxdb:/var/lib/influxdb \
  -v $PWD/influxdb.conf:/etc/influxdb/influxdb.conf:ro \
  influxdb:1.8

To upgrade an InfluxDB 1.x deployment with a custom configuration file to InfluxDB 2.x:

1. Stop the running InfluxDB 1.x container.

2. Start the InfluxDB container with the following:

   • Volume mount for the InfluxDB 1.x data directory
   • Volume mount for the InfluxDB 1.x configuration file
   • Volume mount for the InfluxDB 2.x data directory (/var/lib/influxdb2)
   • Volume mount for the InfluxDB 2.x configuration directory (/etc/influxdb2)
   • InfluxDB initialization mode environment variable
   • InfluxDB initialization credential environment variables
   • influxdb:2.9 Docker image

docker run -p 8086:8086 \
  -v influxdb:/var/lib/influxdb \
  -v $PWD/influxdb.conf:/etc/influxdb/influxdb.conf:ro \
  -v influxdb2:/var/lib/influxdb2 \
  -v influxdb2:/etc/influxdb2 \
  -e DOCKER_INFLUXDB_INIT_MODE=upgrade \
  -e DOCKER_INFLUXDB_INIT_USERNAME=my-user \
  -e DOCKER_INFLUXDB_INIT_PASSWORD=my-password \
  -e DOCKER_INFLUXDB_INIT_ORG=my-org \
  -e DOCKER_INFLUXDB_INIT_BUCKET=my-bucket \
  influxdb:2.9

Upgrade with custom paths

If you’re currently running an InfluxDB 1.x deployment with the data directory and configuration file mounted at custom paths similar to:

docker run -p 8086:8086 \
  -v influxdb:/root/influxdb/data \
  -v $PWD/influxdb.conf:/root/influxdb/influxdb.conf:ro \
  influxdb:1.8 -config /root/influxdb/influxdb.conf

To upgrade an InfluxDB 1.x deployment with custom paths to InfluxDB 2.x:

1. Stop the running InfluxDB 1.x container.
2. Decide to either keep using custom paths or use InfluxDB 2.x default paths.

docker run -p 8086:8086 \
  -v influxdb:/root/influxdb/data \
  -v $PWD/influxdb.conf:/root/influxdb/influxdb.conf:ro \
  -v influxdb2:/root/influxdb2/data \
  -v influxdb2:/root/influxdb2 \
  -e DOCKER_INFLUXDB_INIT_MODE=upgrade \
  -e DOCKER_INFLUXDB_INIT_USERNAME=my-user \
  -e DOCKER_INFLUXDB_INIT_PASSWORD=my-password \
  -e DOCKER_INFLUXDB_INIT_ORG=my-org \
  -e DOCKER_INFLUXDB_INIT_BUCKET=my-bucket \
  -e DOCKER_INFLUXDB_INIT_UPGRADE_V1_CONFIG=/root/influxdb/influxdb.conf \
  -e INFLUXD_CONFIG_PATH=/root/influxdb2/config.toml \
  -e INFLUXD_BOLT_PATH=/root/influxdb2/influxdb.bolt \
  -e INFLUXD_ENGINE_PATH=/root/influxdb2/engine \
  influxdb:<span class="current-version">2.9</span>

docker run -p 8086:8086 \
  -v influxdb:/root/influxdb/data \
  -v $PWD/influxdb.conf:/root/influxdb/influxdb.conf:ro \
  -v influxdb2:/var/lib/influxdb2 \
  -v influxdb2:/etc/influxdb2 \
  -e DOCKER_INFLUXDB_INIT_MODE=upgrade \
  -e DOCKER_INFLUXDB_INIT_USERNAME=my-user \
  -e DOCKER_INFLUXDB_INIT_PASSWORD=my-password \
  -e DOCKER_INFLUXDB_INIT_ORG=my-org \
  -e DOCKER_INFLUXDB_INIT_BUCKET=my-bucket \
  -e DOCKER_INFLUXDB_INIT_UPGRADE_V1_CONFIG=/root/influxdb/influxdb.conf \
  influxdb:<span class="current-version">2.9</span>

Use the interactive InfluxQL shell

The InfluxDB 2.9 influx CLI includes an interactive InfluxQL shell for executing InfluxQL queries. The InfluxDB 2.9 Docker image includes the influx CLI.

To start an InfluxQL shell:

1. Start a bash session in your InfluxDB container:

   docker exec -it influxdb /bin/bash

2. Set up your influx CLI authentication credentials.

3. Run the influx v1 shell command.

For more information, see:

• Use the InfluxQL shell
• Query data with InfluxQL

To build an interactive shell to execute Flux queries, compile and build a command line Flux REPL from source.