Shulou(Shulou.com)06/01 Report--

01-Introduction to InfluxDB Please add link description

02-Influxdb permissions management

03-Introduction to backup and recovery of Influxdb

InfluxDB comes with the influxd command, which also supports data backup and recovery. Backup is divided into meta, manifest, and data. The actual operation is described below.

1. Export native data backup

Backup database: monitordb

Backup storage directory location: /data/backup

influxd backup -portable -database monitordb /data/backup

Specify remote host backup parameters · -host 192.168.1.6:8086 · -database monitordb #specifies the database to be backed up, if not specified default all · -portable #Compatible with newer version of influxdb backup file format, officially recommended · -start #Specify the start timestamp of the data to be backed up-start 2015-12-24T08:12:23Z · -end #End timestamp-end 2015-12-31T08:12:23Z2. Export remote host backup

influxd backup -portable -database zabbix -host 192.168.1.5:8088 /data/backup

2018/11/24 17:52:58 backing up metastore to /data/backup/meta.002018/11/24 17:52:58 backing up db=zabbix2018/11/24 17:52:58 backing up db=zabbix rp=autogen shard=2 to /data/backup/zabbix.autogen.00002.00 since 0001-01-01T00:00:00Z2018/11/24 17:52:58 backup complete:2018/11/24 17:52:58 /data/backup/20181124T095258Z.meta2018/11/24 17:52:58 /data/backup/20181124T095258Z.s2.tar.gz2018/11/24 17:52:58 /data/backup/20181124T095258Z.manifest3. Recover data

recover local data

influxd restore -portable -db zabbix /data/backup/2018/11/26 05:03:42 Restoring shard 8 live from backup 20181125T205756Z.s8.tar.gz

View recovered data

> show serieskey---cpu,host=serverA,region=ca_eastcpu,host=serverA,region=us_west> show measurementsname: measurementsname----cpu> show tag keysname: cputagKey------hostregion> show field keysname: cpufieldKey fieldType-------- ---------value float> select * from zabbix> select * from cpuname: cputime host region value---- ---- ------ -----1543042396476461820 serverA us_west 0.641543042713994239023 serverA ca_east 0.99

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.