삽질/개발,엔지니어링

influx db 이전 (백업 > 복원)

maengis 2023. 2. 12. 13:10

서버 한 대를 HTPC로 쓰기로 해서 서버에 있는 기능을 NAS로 옮기기로 했다.

 

NAS서버에서 백업을 하러 접근을 해야해서 influx 설정을 변경해줘야 한다.

sudo vi /etc/influxdb/influxdb.conf

백업을 위해 8088 포트로 접근을 해야 하는데, 기본 값은 로컬만 접속이 가능해서 그냥 다 열게 수정 한다.

# Bind address to use for the RPC service for backup and restore.
bind-address = ":8088"

재시작을 해주면 적용 된다.

sudo systemctl restart influxdb
$ sudo netstat -nlp | grep influxd
tcp6       0      0 :::8088                 :::*                    LISTEN      948909/influxd
tcp6       0      0 :::8086                 :::*                    LISTEN      948909/influxd

 

접근을 할 수 있게 됐으니 NAS에 influx db 설치 후 기존 서버 데이터를 백업

sudo influxd backup -portable -database {DB명} -host {기존influxdb있는서버IP}:8088 ./

복원

sudo influxd restore -portable -db {DB명} -newdb {DB명} ./

 

나는 /home/tmp 경로 생성 후 위 작업을 했다. 백업 파일들이 아래처럼 해당 경로에 있으므로 작업 후에는 삭제함.

/home/tmp$ ll
total 1640
drwxr-xr-x 2 root root  4096 Feb 12 12:53 ./
drwxr-xr-x 8 root root  4096 Feb 12 12:45 ../
-rw------- 1 root root  5346 Feb 12 12:53 20230212T035347Z.manifest
-rw-r--r-- 1 root root  2648 Feb 12 12:53 20230212T035347Z.meta
-rw------- 1 root root 61531 Feb 12 12:53 20230212T035347Z.s100.tar.gz
-rw------- 1 root root 60207 Feb 12 12:53 20230212T035347Z.s109.tar.gz
-rw------- 1 root root 59843 Feb 12 12:53 20230212T035347Z.s10.tar.gz
-rw------- 1 root root 61112 Feb 12 12:53 20230212T035347Z.s118.tar.gz
-rw------- 1 root root 60974 Feb 12 12:53 20230212T035347Z.s127.tar.gz
-rw------- 1 root root 61258 Feb 12 12:53 20230212T035347Z.s136.tar.gz
-rw------- 1 root root 62736 Feb 12 12:53 20230212T035347Z.s145.tar.gz
-rw------- 1 root root 60534 Feb 12 12:53 20230212T035347Z.s154.tar.gz
-rw------- 1 root root 63607 Feb 12 12:53 20230212T035347Z.s163.tar.gz
-rw------- 1 root root 63308 Feb 12 12:53 20230212T035347Z.s172.tar.gz
-rw------- 1 root root 65267 Feb 12 12:53 20230212T035347Z.s181.tar.gz
-rw------- 1 root root 63085 Feb 12 12:53 20230212T035347Z.s190.tar.gz
-rw------- 1 root root 61432 Feb 12 12:53 20230212T035347Z.s199.tar.gz
-rw------- 1 root root 58561 Feb 12 12:53 20230212T035347Z.s19.tar.gz
-rw------- 1 root root 61109 Feb 12 12:53 20230212T035347Z.s208.tar.gz
-rw------- 1 root root 61501 Feb 12 12:53 20230212T035347Z.s217.tar.gz
-rw------- 1 root root 62548 Feb 12 12:53 20230212T035347Z.s226.tar.gz
-rw------- 1 root root 58574 Feb 12 12:53 20230212T035347Z.s235.tar.gz
-rw------- 1 root root 60418 Feb 12 12:53 20230212T035347Z.s28.tar.gz
-rw------- 1 root root 57092 Feb 12 12:53 20230212T035347Z.s37.tar.gz
-rw------- 1 root root 59619 Feb 12 12:53 20230212T035347Z.s46.tar.gz
-rw------- 1 root root 57863 Feb 12 12:53 20230212T035347Z.s55.tar.gz
-rw------- 1 root root  1191 Feb 12 12:53 20230212T035347Z.s5.tar.gz
-rw------- 1 root root 57551 Feb 12 12:53 20230212T035347Z.s64.tar.gz
-rw------- 1 root root 26092 Feb 12 12:53 20230212T035347Z.s6.tar.gz
-rw------- 1 root root 60426 Feb 12 12:53 20230212T035347Z.s73.tar.gz
-rw------- 1 root root 60117 Feb 12 12:53 20230212T035347Z.s82.tar.gz
-rw------- 1 root root 58924 Feb 12 12:53 20230212T035347Z.s91.tar.gz
반응형