Quick Install from Package

This document describes how to install TDengine on Linux/Windows/macOS and perform queries and inserts.

The full package of TDengine includes the TDengine Server (taosd), TDengine Client (taosc), taosAdapter for connecting with third-party systems and providing a RESTful interface, a command-line interface (CLI, taos), and some tools. Note that taosAdapter supports Linux only. In addition to connectors for multiple languages, TDengine also provides a REST API through taosAdapter.

The standard server installation package includes taos, taosd, taosAdapter, taosBenchmark, and sample code. You can also download the Lite package that includes only taosd and the C/C++ connector.

The TDengine Community Edition is released as Deb and RPM packages. The Deb package can be installed on Debian, Ubuntu, and derivative systems. The RPM package can be installed on CentOS, RHEL, SUSE, and derivative systems. A .tar.gz package is also provided for enterprise customers, and you can install TDengine over apt-get as well. The .tar.tz package includes taosdump and the TDinsight installation script. If you want to use these utilities with the Deb or RPM package, download and install taosTools separately. TDengine can also be installed on x64 Windows and x64/m1 macOS.

Installation

  • .deb
  • .rpm
  • .tar.gz
  • apt-get
  • Windows
  • macOS

  1. Download the Deb installation package.

    Download TDengine

    TDengine Database

    Enter your email to receive a download link

    I would like to receive TDengine news and communications at this address.

    Submit

    Close

  2. In the directory where the package is located, use dpkg to install the package:

Please replace <version> with the corresponding version of the package downloaded

  1. sudo dpkg -i TDengine-server-<version>-Linux-x64.deb

  1. Download the .rpm installation package.

    Download TDengine

    TDengine Database

    Enter your email to receive a download link

    I would like to receive TDengine news and communications at this address.

    Submit

    Close

  2. In the directory where the package is located, use rpm to install the package:

Please replace <version> with the corresponding version of the package downloaded

  1. sudo rpm -ivh TDengine-server-<version>-Linux-x64.rpm

  1. Download the .tar.gz installation package.

    Download TDengine

    TDengine Database

    Enter your email to receive a download link

    I would like to receive TDengine news and communications at this address.

    Submit

    Close

  2. In the directory where the package is located, use tar to decompress the package:

Please replace <version> with the corresponding version of the package downloaded

  1. tar -zxvf TDengine-server-<version>-Linux-x64.tar.gz

In the directory to which the package was decompressed, run install.sh:

  1. sudo ./install.sh
Package - 图4info

Users will be prompted to enter some configuration information when install.sh is executing. The interactive mode can be disabled by executing ./install.sh -e no. ./install.sh -h can show all parameters with detailed explanation.

You can use `apt-get` to install TDengine from the official package repository.

Configure the package repository

  1. wget -qO - http://repos.taosdata.com/tdengine.key | sudo apt-key add -
  2. echo "deb [arch=amd64] http://repos.taosdata.com/tdengine-stable stable main" | sudo tee /etc/apt/sources.list.d/tdengine-stable.list

You can install beta versions by configuring the following repository:

  1. wget -qO - http://repos.taosdata.com/tdengine.key | sudo apt-key add -
  2. echo "deb [arch=amd64] http://repos.taosdata.com/tdengine-beta beta main" | sudo tee /etc/apt/sources.list.d/tdengine-beta.list

Install TDengine with apt-get

  1. sudo apt-get update
  2. apt-cache policy tdengine
  3. sudo apt-get install tdengine
Package - 图5tip

This installation method is supported only for Debian and Ubuntu.

Note: TDengine only supports Windows Server 2016/2019 and Windows 10/11 on the Windows platform.

  1. Download the Windows installation package.

    Download TDengine

    TDengine Database

    Enter your email to receive a download link

    I would like to receive TDengine news and communications at this address.

    Submit

    Close

  2. Run the downloaded package to install TDengine.

  3. Download the macOS installation package.

    Download TDengine

    TDengine Database

    Enter your email to receive a download link

    I would like to receive TDengine news and communications at this address.

    Submit

    Close

  4. Run the downloaded package to install TDengine. If the installation is blocked, you can right-click or ctrl-click on the installation package and select Open.

Package - 图8info

For information about TDengine other releases, check Release History.

Package - 图9note

On the first node in your TDengine cluster, leave the Enter FQDN: prompt blank and press Enter. On subsequent nodes, you can enter the endpoint of the first dnode in the cluster. You can also configure this setting after you have finished installing TDengine.

Quick Launch

  • Linux
  • Windows
  • macOS

After the installation is complete, run the following command to start the TDengine service:

  1. systemctl start taosd

Run the following command to confirm that TDengine is running normally:

  1. systemctl status taosd

Output similar to the following indicates that TDengine is running normally:

  1. Active: active (running)

Output similar to the following indicates that TDengine has not started successfully:

  1. Active: inactive (dead)

After confirming that TDengine is running, run the taos command to access the TDengine CLI.

The following systemctl commands can help you manage TDengine service:

  • Start TDengine Server: systemctl start taosd

  • Stop TDengine Server: systemctl stop taosd

  • Restart TDengine Server: systemctl restart taosd

  • Check TDengine Server status: systemctl status taosd

Package - 图10info
  • The systemctl command requires root privileges. If you are not logged in as the root user, use the sudo command.
  • The systemctl stop taosd command does not instantly stop TDengine Server. The server is stopped only after all data in memory is flushed to disk. The time required depends on the cache size.
  • If your system does not include systemd, you can run /usr/local/taos/bin/taosd to start TDengine manually.

Command Line Interface (CLI)

You can use the TDengine CLI to monitor your TDengine deployment and execute ad hoc queries. To open the CLI, you can execute taos in terminal.

After the installation is complete, run C:\TDengine\taosd.exe to start TDengine Server.

Command Line Interface (CLI)

You can use the TDengine CLI to monitor your TDengine deployment and execute ad hoc queries. To open the CLI, you can run taos.exe in the C:\TDengine directory of the Windows terminal to start the TDengine command line.

After the installation is complete, double-click the /applications/TDengine to start the program, or run launchctl start com.tdengine.taosd to start TDengine Server.

The following launchctl commands can help you manage TDengine service:

  • Start TDengine Server: launchctl start com.tdengine.taosd

  • Stop TDengine Server: launchctl stop com.tdengine.taosd

  • Check TDengine Server status: launchctl list | grep taosd

Package - 图11info
  • The launchctl command does not require root privileges. You don’t need to use the sudo command.
  • The first content returned by the launchctl list | grep taosd command is the PID of the program, if ‘-‘ indicates that the TDengine service is not running.

Command Line Interface (CLI)

You can use the TDengine CLI to monitor your TDengine deployment and execute ad hoc queries. To open the CLI, you can execute taos in terminal.

  1. taos

The TDengine CLI displays a welcome message and version information to indicate that its connection to the TDengine service was successful. If an error message is displayed, see the FAQ for troubleshooting information. At the following prompt, you can execute SQL commands.

  1. taos>

For example, you can create and delete databases and tables and run all types of queries. Each SQL command must be end with a semicolon (;). For example:

  1. CREATE DATABASE demo;
  2. USE demo;
  3. CREATE TABLE t (ts TIMESTAMP, speed INT);
  4. INSERT INTO t VALUES ('2019-07-15 00:00:00', 10);
  5. INSERT INTO t VALUES ('2019-07-15 01:00:00', 20);
  6. SELECT * FROM t;
  8.            ts            |    speed    |
  9. ========================================
  10.  2019-07-15 00:00:00.000 |          10 |
  11.  2019-07-15 01:00:00.000 |          20 |
  13. Query OK, 2 row(s) in set (0.003128s)

You can also can monitor the deployment status, add and remove user accounts, and manage running instances. You can run the TDengine CLI on either machines. For more information, see TDengine CLI.

Test data insert performance

After your TDengine Server is running normally, you can run the taosBenchmark utility to test its performance:

Start TDengine service and execute taosBenchmark (formerly named taosdemo) in a terminal.

  1. taosBenchmark

This command creates the meters supertable in the test database. In the meters supertable, it then creates 10,000 subtables named d0 to d9999. Each table has 10,000 rows and each row has four columns: ts, current, voltage, and phase. The timestamps of the data in these columns range from 2017-07-14 10:40:00 000 to 2017-07-14 10:40:09 999. Each table is randomly assigned a groupId tag from 1 to 10 and a location tag of either California.Campbell, California.Cupertino, California.LosAngeles, California.MountainView, California.PaloAlto, California.SanDiego, California.SanFrancisco, California.SanJose, California.SantaClara or California.Sunnyvale.

The taosBenchmark command creates a deployment with 100 million data points that you can use for testing purposes. The time required to create the deployment depends on your hardware. On most modern servers, the deployment is created in ten to twenty seconds.

You can customize the test deployment that taosBenchmark creates by specifying command-line parameters. For information about command-line parameters, run the taosBenchmark --help command. For more information about taosBenchmark, see taosBenchmark.

Test data query performance

After using taosBenchmark to create your test deployment, you can run queries in the TDengine CLI to test its performance:

From the TDengine CLI (taos) query the number of rows in the meters supertable:

  1. SELECT COUNT(*) FROM test.meters;

Query the average, maximum, and minimum values of all 100 million rows of data:

  1. SELECT AVG(current), MAX(voltage), MIN(phase) FROM test.meters;

Query the number of rows whose location tag is California.SanFrancisco:

  1. SELECT COUNT(*) FROM test.meters WHERE location = "California.SanFrancisco";

Query the average, maximum, and minimum values of all rows whose groupId tag is 10:

  1. SELECT AVG(current), MAX(voltage), MIN(phase) FROM test.meters WHERE groupId = 10;

Query the average, maximum, and minimum values for table d10 in 10 second intervals:

  1. SELECT FIRST(ts), AVG(current), MAX(voltage), MIN(phase) FROM test.d10 INTERVAL(10s);

In the query above you are selecting the first timestamp (ts) in the interval, another way of selecting this would be \_wstart which will give the start of the time window. For more information about windowed queries, see Time-Series Extensions.