docker部署tdengine服务

前言

… …

部署

]# echo 'Asia/Shanghai' > /etc/timezone
]# mkdir -p /data/deploy/tdengine/
]# cd /data/deploy/tdengine/
tdengine]# cat > docker-compose.yml <<-EOF
version: "3.5"
services:
  tdengine:
    image: tdengine/tdengine:2.2.0.5
    container_name: tdengine
    hostname: tdengine
    ports:
      - 6030:6030
      - 6035:6035
      - 6041:6041
      - 6030-6040:6030-6040/udp
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro
      - /data/volume/tdengine/lib:/var/lib/taos:Z
      - /data/volume/tdengine/log:/var/log/taos:Z
    restart: always
    tty: true
EOF
tdengine]# docker-compose up -d

配置用户

tdengine]# docker exec -it tdengine /bin/bash
root@tdengine:~/TDengine-server-2.2.0.5# taos

Welcome to the TDengine shell from Linux, Client Version:2.2.0.5
Copyright (c) 2020 by TAOS Data, Inc. All rights reserved.

taos> create user fht pass 'fht123';
Query OK, 0 of 0 row(s) in database (0.002280s)

查看用户权限

taos> SHOW USERS;
           name           | privilege |       create_time       |         account          |
============================================================================================
 _root                    | writable  | 2021-11-23 07:57:16.970 | root                     |
 monitor                  | writable  | 2021-11-23 07:57:16.970 | root                     |
 fht                      | writable  | 2021-11-23 08:32:23.941 | root                     |
 root                     | super     | 2021-11-23 07:57:16.970 | root                     |
Query OK, 4 row(s) in set (0.002371s)

本地测试连接

]# docker exec -it tdengine /bin/bash
root@tdengine:~/TDengine-server-2.2.0.5# taos -u fht -p
Welcome to the TDengine shell from Linux, Client Version:2.2.0.5
Copyright (c) 2020 by TAOS Data, Inc. All rights reserved.

Enter password: 	# 输入密码
taos> 

远程客户端测试连接

• 客户端的版本要与服务端一致，不然会报如下错误信息
• win上的tdengine客户端可从这里下载TDengine server and client all download)

C:\TDengine>taos -h 192.168.1.30 -u fht -p
Welcome to the TDengine shell from Windows, Client Version:2.3.2.0
Copyright (c) 2020 by TAOS Data, Inc. All rights reserved.

Enter password:
taos connect failed, reason: Invalid app version.
C:\TDengine>taos -h 192.168.1.30 -u fht -p
Welcome to the TDengine shell from Windows, Client Version:2.2.0.5
Copyright (c) 2020 by TAOS Data, Inc. All rights reserved.

Enter password:
taos> SHOW USERS;
           name           | privilege |       create_time       |         account          |
============================================================================================
 _root                    | writable  | 2021-11-23 15:57:16.970 | root                     |
 monitor                  | writable  | 2021-11-23 15:57:16.970 | root                     |
 fht                      | writable  | 2021-11-23 16:32:23.941 | root                     |
 root                     | super     | 2021-11-23 15:57:16.970 | root                     |
Query OK, 4 row(s) in set (0.065000s)

数据的导入导出

数据需要进行迁移、备份

导入导出以服务器10.0.1.2、服务器10.0.1.5为例

• 导出(自行登陆服务器执行如下命令)

midd ~]# mkdir data-data0101-1123
midd ~]# taosdump -o data-data0101-1123 -A

• 导入(自行登陆服务器执行如下命令，并把2备份的数据放置在5服务器的/root下)

tdengine]# docker exec tdengine taosdump -i /root/data-data0101-1123
... ...

结语
TDengine常用命令及SQL
dockerhub tdengine
docker tdengine
TDengine视频教程-快速上手
TDengine DUMP工具使用指南
TDengine v2.0 数据库文档
三分钟梳理TDengine安装部署的逻辑
TDengine server and client all download