TSDB时序数据库

产品特征

产品 特征
InfluxDB 小而精,性能高,数据量较小(亿级)
TimescaleDB 简单,数据量不大(千万级),有联合查询、关系型数据库基础
opentsdb、KairosDB 数据量较大,大数据服务基础,分布式集群需求
druid 分布式集群需求,olap实时在线分析,资源较充足
Beringei 性能极致追求,数据冷热差异大
elsaticsearch 兼顾检索加载,分布式聚合计算
Mysql Archive 功能没有 TimescaleDB 强大

产品

TimescaleDB

docker 安装

  • 获取镜像
    1
    docker pull timescale/timescaledb-ha:pg14-latest
  • 启动
    1
    2
    3
    4
    5
    6
    7
    docker run \
    -d \
    -p 15432:5432 \
    --name timescaledb \
    -e POSTGRES_PASSWORD=123456 \
    -v /Users/suce/Documents/db/timescale:/var/lib/postgresql/data \
    timescale/timescaledb-ha:pg14-latest
  • 修改密码
    1
    2
    3
    4
    5
    docker exec -it 容器id /bin/sh
    su postgres
    psql
    ALTER USER postgres WITH PASSWORD '123456';
    exit #退出容器
    cat >> /etc/hosts<<EOF

192.168.8.150 k8s-master-10
192.168.8.151 k8s-work-11
192.168.8.152 k8s-work-12
EOF

ssh-keygen

ssh-copy-id -i ~/.ssh/id_rsa.pub root@k8s-master-10
ssh-copy-id -i ~/.ssh/id_rsa.pub root@k8s-work-11
ssh-copy-id -i ~/.ssh/id_rsa.pub root@k8s-work-12

yum erase podman buildah
yum install docker-ce|dnf install docker-ce

kubeadm init
–apiserver-advertise-address=192.168.8.150
–image-repository registry.aliyuncs.com/google_containers
–control-plane-endpoint=cluster-endpoint
–kubernetes-version v1.24.1
–service-cidr=10.1.0.0/16
–pod-network-cidr=10.244.0.0/16
–v=5

Author: suce
Link: https://haoubox.cn/2022/08/28/TSDB时序数据库/
Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.