产品特征
| 产品 | 特征 |
|---|---|
| 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
7docker 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 - 修改密码cat >> /etc/hosts<<EOF
1
2
3
4
5docker exec -it 容器id /bin/sh
su postgres
psql
ALTER USER postgres WITH PASSWORD '123456';
exit #退出容器
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