For AI agents: the complete documentation index is available at https://www.tteam.icu/zh/llms.txt, the full documentation bundle is available at https://www.tteam.icu/zh/llms-full.txt, and this page is available as Markdown at https://www.tteam.icu/zh/ops/database/tdengine.md.
buyfakett
  • 简体中文

      • tdengine

      AI 总结AI 生成

      核心内容：介绍 TDEngine 时序数据库的部署配置、数据备份恢复以及监控配置等操作。

      内容要点：

      • 部署与启动
      • tdengine-6030.sh
      • config/taos.cfg
      • 服务端操作
      • 命令行登录
      • 执行sql

      适合在数据库部署、备份恢复、迁移和日常维护时按步骤查阅。

      官方中文文档

      启动

      默认账号密码为 root/taosdata。

      tdengine-6030.sh

      tdengine-6030.sh
      #!/bin/bash

port=6030
http_port=$((${port} + 11))
master_tdengine=$(hostname)-tdengine-${port}
password=password

docker stop tdengine-${port}
docker rm tdengine-${port}

docker run -d \
--name tdengine-${port} \
--hostname $(hostname) \
--restart=always \
-e TAOS_FQDN=$(hostname)-tdengine-${port} \
-e TAOS_FIRST_EP=${master_tdengine} \
-v /etc/timezone:/etc/timezone:ro \
-v /etc/localtime:/etc/localtime:ro \
-v /etc/timezone:/etc/timezone:ro \
-v /etc/localtime:/etc/localtime:ro \
-v $(pwd)/data:/var/lib/taos \
-v $(pwd)/log:/var/log/taos \
-v ./config/taos.cfg:/etc/taos/taos.cfg \
-p ${port}:6030 \
-p ${http_port}:6041 \
-p $((${port} + 14))-$((${port} + 19)):6044-6049 \
-p $((${port} + 14))-$((${port} + 19)):6044-6049/udp \
--privileged=true \
tdengine/tdengine:3.3.0.0

# --entrypoint /bin/bash \
# docker exec -it tdengine-${port} taosdemo
# docker run --rm -it -e TAOS_FIRST_EP=tdengine --entrypoint=taos tdengine/tdengine:3.3.0.0

      config/taos.cfg

      taos.cfg
      monitor 1
monitorFQDN 172.30.137.38
monitorPort 6043
audit 1
monitorInterval 1
telemetryReporting 1
crashReporting 1
      Tip

      TDEngine 似乎不支持通过 Docker 环境变量修改密码，只能通过 SQL 修改:

      ALTER USER root PASS 'password';

      服务端操作

      命令行登录

      taos

      执行sql

      use <database>;

source 1.sql;

      导入csv

      INSERT INTO gps_information (xxx,xxx) FILE '/tmp/1.csv';

      备份与恢复

      备份

      Tip

      注意: 连接数据库用的http_port，也就是6041

      备份用到的端口是port，也就是6030
      docker run -i --rm -v ./:/tmp -w /tmp tdengine/tdengine:3.2.3.0 \
taosdump -A -h 192.168.1.1 -P 6030 -u root -ptaosdata -o /tmp

      恢复

      目前似乎不支持指定时间恢复。

      taosdump -i /bak

      监控

      需要使用 taoskeeper 组件，配合 Prometheus 定时采集数据。

      taoskeeper.sh

      taoskeeper.sh
      #!/bin/bash

port=6043

docker rm -f taoskeeper-${port}
docker run -d \
--name taoskeeper-${port} \
--hostname $(hostname) \
--restart=always \
-v /etc/timezone:/etc/timezone:ro \
-v /etc/localtime:/etc/localtime:ro \
-v ./config/taoskeeper.toml:/etc/taos/taoskeeper.toml \
-p ${port}:6043 \
--privileged=true \
buyfakett/taoskeeper

      config/taos.cfg

      taoskeeper.toml
      # Start with debug middleware for gin
debug = false

# Listen port, default is 6043
port = 6043

# log level
loglevel = "info"

# go pool size
gopoolsize = 50000

# interval for metrics
RotationInterval = "15s"

[tdengine]
host = "172.30.137.38"
port = 6041
username = "root"
password = "Ru9sZZJU78cdUTxi"

[metrics]
# metrics prefix in metrics names.
prefix = "taos"

# database for storing metrics data
database = "log"

# export some tables that are not super table
tables = []

# database options for db storing metrics data
[metrics.databaseoptions]
cachemodel = "none"

[environment]
# Whether running in cgroup.
incgroup = false

[audit]
[audit.database]
name = "audit"
[audit.database.options]
cachemodel = "none"

[log]
#path = "/var/log/taos"
rotationCount = 5
rotationTime = "24h"
rotationSize = 100000000