InfluxDB数据备份与恢复

转载

知止内明 2018-08-28 23:38:43 博主文章分类：数据库

1.1 创建本地备份目录
mkdir influxdb_backup
cd ./influxdb_backup
 
1.2 备份元数据
influxd backup -database mydatabase -retention autogen ./
 
1.3 备份数据库
influxd backup -database testdb -retention autogen ./

第二种

1、本地备份

1.1 创建本地备份目录 mkdir influxdb_backup cd ./influxdb_backup 3.1.2 备份元数据influxd backup -database mydatabase -retention autogen ./1.3 备份数据库influxd backup -database testdb -retention autogen ./ 2、远程备份:假设备份192.168.10.188的数据到192.168.10.199 注:备份192.168.10.188的数据,需要登录到192.168.10.199执行备份命令

1.1 创建备份目录mkdir backup_188cd ./backup_1881.2 备份元数据influxd backup -host 192.168.10.188:8088 ./1.3 备份数据库influxd backup -database testdb -host 192.168.10.188:8088 ./ 2. 三、数据恢复(必须先恢复元数据,再恢复数据库中的数据)

1、恢复元数据

在188上:cd ./influxdb_backup influxd restore -metadir /var/lib/influxdb/meta ./或在199上:cd ./backup_188influxd restore -metadir /var/lib/influxdb/meta ./

2、恢复数据库中的数据

在188上:cd ./influxdb_backup influxd restore -database testdb -datadir /var/lib/influxdb/data ./或在199上cd ./backup_188influxd restore -database testdb -datadir /var/lib/influxdb/data ./

3、修改目录权限

chown -R influxdb:influxdb /var/lib/influxdb

4、重启服务

service influxdb restart 注:上述中的/var/lib/influxdb/meta 和 /var/lib/influxdb/data 是InfluxDB执行配置文件中配置的参数,详见/etc/influxdb/influxdb.conf配置文件meta 和 data 配置。

https://www.aliyun.com/jiaocheng/127796.html

实际工作：

[root@jmeter03 influxdb_backup]# influxd backup -database jmeter -retention autogen ./
2018/08/31 10:18:45 backing up rp=autogen since 0001-01-01 00:00:00 +0000 UTC
2018/08/31 10:18:45 backing up metastore to meta.00
2018/08/31 10:18:45 backing up db=jmeter rp=autogen shard=2 to jmeter.autogen.00002.00 since 0001-01-01 00:00:00 +0000 UTC
2018/08/31 10:18:45 backup complete
[root@jmeter03 influxdb_backup]# influxd backup -database jmeter -retention autogen ./       
2018/08/31 10:19:19 backing up rp=autogen since 0001-01-01 00:00:00 +0000 UTC
2018/08/31 10:19:19 backing up metastore to meta.01
2018/08/31 10:19:19 backing up db=jmeter rp=autogen shard=2 to jmeter.autogen.00002.01 since 0001-01-01 00:00:00 +0000 UTC
2018/08/31 10:19:19 backup complete

恢复

-rw-r--r--. 1 root root   265 Aug 31 09:29 meta.01
[root@localhost nfluxdb_backup]# rm -rf *
[root@localhost nfluxdb_backup]# rz
rz waiting to receive.
 zmodem trl+C ȡ

  100%      20 KB   20 KB/s 00:00:01       0 Errors0...
  100%      20 KB   20 KB/s 00:00:01       0 Errors
  100%     265 bytes  265 bytes/s 00:00:01       0 Errors
  100%     265 bytes  265 bytes/s 00:00:01       0 Errors

[root@localhost nfluxdb_backup]# 
[root@localhost nfluxdb_backup]# 
[root@localhost nfluxdb_backup]# ll
total 48
-rw-r--r--. 1 root root 20480 Aug 31 10:18 jmeter.autogen.00002.00
-rw-r--r--. 1 root root 20480 Aug 31 10:19 jmeter.autogen.00002.01
-rw-r--r--. 1 root root   265 Aug 31 10:18 meta.00
-rw-r--r--. 1 root root   265 Aug 31 10:19 meta.01
[root@localhost nfluxdb_backup]# influxd restore -metadir /var/lib/influxdb/meta ./
Using metastore snapshot: meta.01
[root@localhost nfluxdb_backup]# influxd restore -database jmeter -datadir /var/lib/influxdb/data ./      
Restoring from backup jmeter.*
unpacking /var/lib/influxdb/data/jmeter/autogen/2/000000001-000000001.tsm
unpacking /var/lib/influxdb/data/jmeter/autogen/2/000000001-000000001.tsm
[root@localhost nfluxdb_backup]# 
[root@localhost nfluxdb_backup]# 
[root@localhost nfluxdb_backup]# 
[root@localhost nfluxdb_backup]# chown -R influxdb:influxdb /var/lib/influxdb
[root@localhost nfluxdb_backup]# service influxdb restart 
Redirecting to /bin/systemctl restart  influxdb.service

![]