InfluxDB migration

# influxd version
InfluxDB v1.7.7 (git: 1.7 f8fdf652f348fc9980997fe1c972e2b79ddd13b0)

# du -h --max-depth=1 /var/lib/influxdb/
8.0K    /var/lib/influxdb/meta
99G     /var/lib/influxdb/data
30M     /var/lib/influxdb/wal
99G     /var/lib/influxdb/

# ls /var/lib/influxdb/data/telegraf/autogen
1007  1071  1135  1199  127   1335  1399  1463  1519  1587  1651  1715  191  31   375  439  503  567  631  7    759  823  887  951
1015  1079  1143  1207  1271  1343  1407  1471  1527  159   1659  1723  199  311  383  447  511  575  639  703  767  831  895  959
1023  1087  1151  1215  1279  135   1415  1479  1535  1595  1667  1731  2    319  39   455  519  583  647  71   775  839  903  967
103   1095  1159  1223  1287  1351  1423  1487  1539  1603  167   1739  207  327  391  463  527  591  655  711  783  847  911  975
1031  1103  1167  1231  1295  1359  143   1495  1547  1611  1675  1747  215  335  399  47   535  599  663  719  79   855  919  983
1039  111   1175  1239  1303  1367  1431  15    1555  1619  1683  175   223  343  407  471  543  607  671  727  791  863  927  991
1047  1111  1183  1247  1311  1375  1439  1503  1563  1627  1691  1755  23   351  415  479  55   615  679  735  799  87   935  999
1055  1119  119   1255  1319  1383  1447  151   1571  1635  1699  1763  231  359  423  487  551  623  687  743  807  871  943
1063  1127  1191  1263  1327  1391  1455  1511  1579  1643  1707  183   239  367  431  495  559  63   695  751  815  879  95

# time influxd backup -host MY_IP:8088 -database telegraf /nfs
2023/10/12 23:30:21 backing up metastore to /nfs/meta.00
2023/10/12 23:30:21 backing up db=telegraf
2023/10/12 23:30:21 backing up db=telegraf rp=autogen shard=2 to /nfs/telegraf.autogen.00002.00 since 0001-01-01T00:00:00Z
2023/10/12 23:30:23 backing up db=telegraf rp=autogen shard=7 to /nfs/telegraf.autogen.00007.00 since 0001-01-01T00:00:00Z
2023/10/12 23:30:28 backing up db=telegraf rp=autogen shard=15 to /nfs/telegraf.autogen.00015.00 since 0001-01-01T00:00:00Z
2023/10/12 23:30:31 backing up db=telegraf rp=autogen shard=23 to /nfs/telegraf.autogen.00023.00 since 0001-01-01T00:00:00Z
2023/10/12 23:30:35 backing up db=telegraf rp=autogen shard=31 to /nfs/telegraf.autogen.00031.00 since 0001-01-01T00:00:00Z
2023/10/12 23:30:42 backing up db=telegraf rp=autogen shard=39 to /nfs/telegraf.autogen.00039.00 since 0001-01-01T00:00:00Z
...
2023/10/13 00:13:16 backing up db=telegraf rp=autogen shard=1723 to /nfs/telegraf.autogen.01723.00 since 0001-01-01T00:00:00Z
2023/10/13 00:13:25 backing up db=telegraf rp=autogen shard=1731 to /nfs/telegraf.autogen.01731.00 since 0001-01-01T00:00:00Z
2023/10/13 00:13:32 backing up db=telegraf rp=autogen shard=1739 to /nfs/telegraf.autogen.01739.00 since 0001-01-01T00:00:00Z
2023/10/13 00:13:34 backing up db=telegraf rp=autogen shard=1747 to /nfs/telegraf.autogen.01747.00 since 0001-01-01T00:00:00Z
2023/10/13 00:13:36 backing up db=telegraf rp=autogen shard=1755 to /nfs/telegraf.autogen.01755.00 since 0001-01-01T00:00:00Z
2023/10/13 00:13:39 backing up db=telegraf rp=autogen shard=1763 to /nfs/telegraf.autogen.01763.00 since 0001-01-01T00:00:00Z
2023/10/13 00:13:40 backup complete:
2023/10/13 00:13:40     /nfs/nfs/meta.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00002.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00007.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00015.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00023.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00031.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00039.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00047.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00055.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00063.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.00071.00
...
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01707.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01715.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01723.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01731.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01739.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01747.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01755.00
2023/10/13 00:13:40     /nfs/nfs/telegraf.autogen.01763.00
influxd backup -host 150.183.100.58:8088 -database telegraf /nfs  19.34s user 146.55s system 6% cpu 43:20.43 total

# du -h /nfs
99G     /nfs

version: '3'

services:
  grafana:
    image: grafana/grafana:latest
    container_name: grafana
    ports:
      - "3000:3000"
    depends_on:
      - influxdb
    volumes:
      - grafana-data:/var/lib/grafana

  influxdb:
    image: influxdb:1.8
    container_name: influxdb
    ports:
      - "8086:8086"
    environment:
      - INFLUXDB_DB=telegraf
      - INFLUXDB_ADMIN_USER=hello
      - INFLUXDB_ADMIN_PASSWORD=world
    volumes:
      # - /opt/npb/influxdb:/var/lib/influxdb
      - influxdb-data:/var/lib/influxdb

volumes:
  grafana-data:
  influxdb-data:

(docker host)# mkdir /opt/influx/
(docker host)# cd /opt/influx/
(docker host)# vi docker-compose.html
(docker host)# docker-compose up -d
(docker host)# # docker ps -a
CONTAINER ID   IMAGE                    COMMAND                  CREATED       STATUS       PORTS                                       NAMES
3444ecb85e49   grafana/grafana:latest   "/run.sh"                2 hours ago   Up 2 hours   0.0.0.0:3000->3000/tcp, :::3000->3000/tcp   grafana
1472751ccb0d   influxdb:1.8             "/entrypoint.sh infl…"   2 hours ago   Up 2 hours   0.0.0.0:8086->8086/tcp, :::8086->8086/tcp   influxdb
(docker host)# docker exec -it influxdb /bin/sh
(influxdb container)# influxd restore -metadir /var/lib/influxdb/meta -datadir /var/lib/influxdb/data -database telegraf /backup
Using metastore snapshot: /backup/meta.00
2023/10/12 16:03:27 Restoring offline from backup /backup/telegraf.*