influxdb安装和学习

docker run -d --name influxdb -p 8086:8086 -p 8083:8083  -v /data/opt/monitor/influx/influxdb:/var/lib/influxdb influxdb

docker exec -it influxdb /bin/bash
输入influx

create user "admin" with password 'admin' with all privileges

docker run --rm influxdb influxd config > influxdb.conf

[http]
  enabled = true
  bind-address = ":8086"
  auth-enabled = true # ✨

docker kill influxdb
docker rm influxdb
docker run -d --name influxdb -p 8086:8086 -p 8083:8083 -v /data/opt/monitor/influx/influxdb.conf:/etc/influxdb/influxdb.conf:ro  -v /data/opt/monitor/influx/influxdb:/var/lib/influxdb influxdb

docker exec -it influxdb /bin/bash

auth admin admin
show databases;
create database demo

#!/bin/bash
# 0 0 * * * sh /data/opt/monitor/backup/influx/backup-influx.sh
source /etc/profile

LOG_DIR=/data/log/backup/influx
SOURCE_DIR=/data/opt/monitor/influx
BACKUP_DIR=/data/opt/monitor/backup/influx/data

REMOTE_IP=192.168.5.9
REMOTE_USER=root
REMOTE_DIR=/data/opt/backup/influx


function log()
{
  echo "[ `date '+%Y-%m-%d %H:%M:%S'` ] $1"
}


# 备份
function main(){
    d=`date "+%Y%m%d%H%M%S"`
    fname=${BACKUP_DIR}/backup_${d}.tgz
    log "开始备份 ${fname}"
    tar -zcf ${fname} ${SOURCE_DIR}

    scp ${fname} $REMOTE_USER@$REMOTE_IP:$REMOTE_DIR
    log "备份到远程成功"


    log "开始删除30天前的备份"
    find ${BACKUP_DIR} -type f  -atime +7 |xargs -t -i rm {}
    log "删除完毕"
}


main >> 2>&1 ${LOG_DIR}/backup.log

> create database demo
> use demo 
Using database demo
> show retention policies  on "demo"
name    duration shardGroupDuration replicaN default
----    -------- ------------------ -------- -------
autogen 0s       168h0m0s           1        true

create retention policy "rp_30days" on "demo" duration 30d replication 1 default

alter retention policy "rp_30days" on "demo" duration 30d default

drop retention policy "rp_name" on "db_name"