Questions tagged [cnosdb]

CnosDB is an open-source, distributed, temporal database. It can be used for IoT, DevOps, real-time analytics, and much more. This tag is for questions specifically related to CnosDB.

CnosDB is a time series database optimized for time-stamped or time series data. The versatility of CnosDB brings an easy and familiarity to developers and users to monitor physical systems, software systems, performance indicators, network data, sensor data and many other types of analytics data.

All of the code is open-sourced and available on GitHub.

Key features

  • High performance: CnosDB addresses the issue of time-series data expansion and theoretically supports unlimited time-series data. It supports aggregate queries along the timeline, including queries divided by equal intervals, queries divided by enumeration values of a column, and queries divided by the length of the time interval between adjacent time-series records. It also has caching capabilities for the latest data and the cache space can be configured for fast access to the latest data.
  • Easy to use: CnosDB provides clear and simple interfaces, easy configuration options, standard SQL support, seamless integration with third-party tools, and convenient data access functions. It supports schema-less writing mode and supports historical data supplement(including out of order writing).
  • Cloud native: CnosDB has a native distributed design, data sharding and partitioning, separation of storage and computing, Quorum mechanism, Kubernetes deployment and complete observability, ensuring final consistency. It can be deployed in public clouds, private clouds, and hybrid clouds. t also supports multi-tenancy and has role-based permission control. The computing and storage nodes support horizontal scaling.

Use cases

  • DevOps Monitoring: CnosDB's DevOps monitoring solution offers developers enhanced visibility across their infrastructures including servers, databases, microservices, cloud services to promote faster development cycles and increased agility in responding to market demands. With over 100 plugins, CnosDB offers extensive and transparent visibility into various application and infrastructure components, allowing teams across the organization to monitor system and application performance and health. The platform also features extensible instrumentation and open APIs for added flexibility and customization.
  • IoT Monitoring: CnosDB is designed to handle the constant flow of IoT data from multiple sources, typically associated with time-series workloads. The extensive use of IoT devices often results in real-time data reporting in streaming mode, presenting difficulties caused by their limited hardware performance and cache capacity. To overcome unexpected traffic surges, a database with high scalability and elasticity is necessary. CnosDB is a perfect fit for these situations, with features such as horizontal expansion and real-time analysis, ensuring optimal read and write performance, and accommodating flexible capacity needs.
  • Predictive Maintenance: CnosDB collects time-series data from sensors and other monitoring devices, stores it, and applies machine learning algorithms to analyze the data. This process enables the system to identify the health status and potential failure modes of equipment or systems. In scenarios such as oil and gas storage and transportation, nuclear power management, and bridge inspection, engineers can use CnosDB to predict and prevent equipment or system failures through predictive maintenance. They can take the necessary maintenance measures before a failure occurs.

Helpful links

196 questions
0
votes
0 answers

how to backup CnosDB meta cluster data

Can cnosdb implement backup meta cluster data? I would like to know some plans of cnosdb in this regard. CnosDB should implement this feature
0
votes
0 answers

How to import a csv file into CnosDB datatable?

According to the doc, I can import a txt-file with cmd "\w". Question-1: How can I directly import a file from a remote storage, S3 for example? Question-2: How can I import a csv file into CnosDB-table with mismatch header row? For instance, i…
learn_more
  • 145
  • 10
0
votes
0 answers

Can cnosdb implement encryption or password-free login?

Can cnosdb implement encryption or password-free login? I would like to know some plans of cnosdb in this regard. I expect that cnosdb can realize password-free login
Baker
  • 71
  • 5
0
votes
0 answers

how can I deploy cnosdb cluster on my aws ec2?

how can I deploy cnosdb cluster on my aws ec2 i want to know the best practice to deploy cnosdb cluster on my aws test environment
xufei Alex
  • 65
  • 4
0
votes
0 answers

Where can I find the error log for CnosDB v2.2 (Docker version)?

I am currently deploying a Docker version for CnosDB v2.2. After deploying the instance, I restart the CnosDB server. Some requests work but others don't. Where can I find the error log file? I tried these places: logs/debug.log, messages.log and…
Munin
  • 1,576
  • 2
  • 19
0
votes
0 answers

How to Get the Size of a Table in CnosDB

The new version of CnosDB seems to be compatible to SQL. I am able to create a table as follows according to the manual: CREATE TABLE air ( visibility DOUBLE, temperature DOUBLE, presssure DOUBLE, TAGS(station) ); But how could I get…
Munin
  • 1,576
  • 2
  • 19
0
votes
1 answer

Compile the rust program with cross-rs

Some unexpected events occurred when using cross-rs to compile rust The source code is here: https://github.com/IvanGao01/cnosdb/tree/2d870495aa65e3432755ad0bbc6a02bd957cd922 Execute the following command to compile Build image docker build -t…
Ivan Gao
  • 35
  • 4
0
votes
0 answers

Add Data Node in CnosDB Cluster?

I could spin up a CnosDB Cluster via this manual and add the meta node as follows: curl http://127.0.0.1:21001/init -d '{}' curl http://127.0.0.1:21001/add-learner -H "Content-Type: application/json" -d '[2, "127.0.0.1:21002"]' curl…
Munin
  • 1,576
  • 2
  • 19
0
votes
0 answers

How can I insert NULL values in CnosDB?

From the doc, it seems I could insert null values (no matter being tag or field column). I am creating a table first: CREATE TABLE air ( visibility DOUBLE, temperature DOUBLE, presssure DOUBLE, TAGS(station,region) ); Then insert a…
Munin
  • 1,576
  • 2
  • 19
0
votes
0 answers

Does CnosDB have unique constraint?

I am adding the same data again and again into CnosDB, which is a time series database. I suppose there should be unique constraint. Probably the tag? The duplicate won't trigger an error. So, do we have the uniqueness check here?
Munin
  • 1,576
  • 2
  • 19
0
votes
1 answer

Cannot Show Databases in CnosDB

Following this QuickStart doc, I created a database but couldn't see it coming up in the query. Details are: docker run -itd --env cpu=2 --env memory=4 -p 31007:31007 cnosdb/cnosdb docker exec -it sh $ cnosdb-cli CREATE DATABASE…
Munin
  • 1,576
  • 2
  • 19
0
votes
0 answers

Count on tag return nothing in CnosDB

I am confused why CnosDB show such behavior when I am trying to count on a tag. It doesn't return any error or return any info. I am using the sample database from the doc. The data looks as follows: > select * from test_air name: test_air time …
Munin
  • 1,576
  • 2
  • 19
-1
votes
0 answers

Why is cnosdb writing to disk so slow

When I benchmark cnosdb, the write memory speed is still reasonable, but I find the write disk is very low by iostat. Why is this, how to optimize?
Subsegment
  • 152
  • 6
-1
votes
1 answer

god:encoded unsigned integer out of range

When use the tsdb-comparisons of CnosDB to do the queries test, I met an error, which is reported 2023/06/14 02:53:26 gob: encoded unsigned integer out of range. Does anybody met this question before? I followed the README.md of tsdb-comparisons…
Caroline
  • 19
  • 3
1 2 3
12
13