TDengine叢集安裝

一、安裝包下載下傳：

1、下載下傳TDengine-server-2.0.20.12-Linux-x64.tar.gz

下載下傳位址：https://www.taosdata.com/cn/all-downloads/

二、叢集安裝

1、安裝環境 centos7.7，我們準備了兩台伺服器安裝，一台mnode節點，一台nnode節點

2、hostname配置（h1.wxx.com為mnode），兩台伺服器都要配置，這裡的Ip是雲伺服器的内網ip

192.168.1.20 h1.wxx.com
192.168.1.21 h2.wxx.com
           

3、建立資料存儲路徑data和log目錄（兩台伺服器都要建立）

cd /data
mkdir tdengine
cd tdengine
mkdir data
mkdir log
           

3、将包上傳至伺服器/data目錄

cd /data
tar xvf TDengine-server-2.0.20.12-Linux-x64.tar.gz
cd TDengine-server-2.0.20.12
./install.sh
           

重點說明：

mnode節點安裝，一路回車，不輸入任務内容

nnode節點安裝時，提示是否加入其餘他節點，輸入

h1.wxx.com:6030
           

4、taos.cfg配置檔案修改，兩台伺服器配置不同的就是fqdn參數

mnode節點

firstEp                   h1.wxx.com:6030
fqdn                      h1.wxx.com
serverPort                6030
logDir                    /data/tdengine/log
dataDir                  /data/tdengine/data
           

nnode節點

firstEp                   h1.wxx.com:6030
fqdn                      h2.wxx.com
serverPort                6030
logDir                    /data/tdengine/log
dataDir                  /data/tdengine/data
           

5、建立啟動腳本，時間長了，指令容易忘

cd /data/tdengine
vi mystart.sh
           

插入

systemctl start taosd
           

6、啟動

sh mystart.sh
systemctl status taosd
           

顯示如下，表示成功

[[email protected] tdengine]# systemctl status taosd
● taosd.service - TDengine server service
   Loaded: loaded (/etc/systemd/system/taosd.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2021-08-10 14:57:22 CST; 9s ago
  Process: 330 ExecStartPre=/usr/local/taos/bin/startPre.sh (code=exited, status=0/SUCCESS)
 Main PID: 339 (taosd)
   CGroup: /system.slice/taosd.service
           └─339 /usr/bin/taosd

Aug 10 14:57:22 server06 systemd[1]: Starting TDengine server service...
Aug 10 14:57:22 server06 systemd[1]: Started TDengine server service.
Aug 10 14:57:22 server06 TDengine:[339]: Starting TDengine service...
Aug 10 14:57:22 server06 TDengine:[339]: Started TDengine service successfully.
           

7、針對雲伺服器，開放端口，同時要開放TCP的6030端口，UDP的6030端口，用戶端才可以通路

三、驗證資料庫可用

1、檢視叢集相關節點，用taos指令進入指令視窗

taos> show dnodes;
   id   |           end_point            | vnodes | cores  |   status   | role  |       create_time       |      offline reason      |
======================================================================================================================================
      1 | h1.wxx.com:6030             |      0 |      8 | ready      | any   | 2021-08-10 11:33:02.299 |                          |
      2 | h2.wxx.com:6030             |      2 |      8 | ready      | any   | 2021-08-10 11:38:29.550 |                          |
Query OK, 2 row(s) in set (0.000641s)

taos> show mnodes;
   id   |           end_point            |     role     |       create_time       |
===================================================================================
      1 | h1.wxx.com:6030             | master       | 2021-08-10 11:33:02.299 |
Query OK, 1 row(s) in set (0.000529s)

           

2、建庫，建表

create database db;
use db;
create table t (ts timestamp, speed int);
insert into t values ('2019-07-15 00:00:00', 10);
insert into t values ('2019-07-15 01:00:00', 20);
select * from t;
           ts            |    speed    |
========================================
 2019-07-15 00:00:00.000 |          10 |
 2019-07-15 01:00:00.000 |          20 |
Query OK, 2 row(s) in set (0.003128s)
           

四、用戶端的使用

1、用戶端下載下傳（注：用戶端與伺服器端版本必須保持一至）

包名為：TDengine-client-2.0.20.12-Windows-x64.exe

下載下傳位址：https://www.taosdata.com/cn/all-downloads/

2、直接輕按兩下安裝，預設安裝到了C:\TDengine目錄，

3、編輯C:\TDengine\taos.cfg配置

關鍵配置如下：

firstEp                   h1.wxx.com:6030
           

4、修改C:\Windows\System32\drivers\etc\hosts，加入(這裡是雲伺服器的外網ip)

120.63.178.133  h1.wxx.com
120.63.254.178  h2.wxx.com
           

5、使用

C:\TDengine>taos.exe

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

taos> show databases;
              name              |      created_time       |   ntables   |   vgroups   | replica | quorum |  days  |   keep0,keep1,keep(D)    |  cache(MB)  |   blocks    |   minrows   |   maxrows   | wallevel |    fsync    | comp | cachelast | precision | update |   status   |
====================================================================================================================================================================================================================================================================================
 demo                           | 2021-08-10 11:41:30.773 |           1 |           1 |       1 |      1 |     10 | 3650,3650,3650           |          16 |           6 |         100 |        4096 |        1 |        3000 |    2 |         0 | ms        |      0 | ready      |
 log                            | 2021-08-10 11:33:03.301 |           5 |           1 |       1 |      1 |     10 | 30,30,30                 |           1 |           3 |         100 |        4096 |        1 |        3000 |    2 |         0 | us        |      0 | ready      |
Query OK, 2 row(s) in set (0.149000s)

taos> use demo;
Query OK, 0 of 0 row(s) in database (0.016000s)

taos> select * from t;
           ts            |    speed    |
========================================
 2019-07-15 00:00:00.000 |          10 |
 2019-07-15 01:00:00.000 |          20 |
Query OK, 2 row(s) in set (0.132000s)

taos>