前言
… …
部署
]# 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