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
1
vote
0 answers

The time zone in the CnosDB log is incorrect

The time recorded in the log is eight hours later than the actual time CnosDB version: a20d094 enter image description here How can I solve this problem, is there any relevant configuration? Or is this a bug? The time zone in the log is consistent…
cosmic
  • 109
  • 5
1
vote
0 answers

How to update data in cnosdb?

I created a table and wrote some data. Now I want to change the value of ta column using Update statement. create table test(fa bigint, tags(ta)); insert into table test(ta, fa) values ('ta', 1); select * from…
ZuoTiJia
  • 161
  • 5
1
vote
0 answers

How to migrate data in CnosDB cluster

After adding a new data node, I want to migrate some data from the old node to the new, balancing the disk storage space of each server. How should I migrate? Data can be smoothly migrated between nodes.
1
vote
0 answers

Does CnosDB support storing log data

It is convenient and intuitive to read promethus directly and cooperate with grafna monitoring charts. Hopefully, it can also support opentsdb protocol
Subsegment
  • 152
  • 6
1
vote
1 answer

How to make CnosDB store duplicate data?

According to CnosDB's insert syntax, I am trying to write duplicate data points (same timestamp + same tag but different field values in different batch), these data points should have been merged together into one data point. I am using v2.0.1. See…
Munin
  • 1,576
  • 2
  • 19
1
vote
1 answer

how can I do health check for cnosdb in kubernetes?

how can I do health check for cnosdb in kubernetes, as we know, health-check is important in kubernetes, as common, a binary should provider a restful api for kubernetes periodically health-checking. Does cnosdb provider such api? best practise to…
xufei Alex
  • 65
  • 4
1
vote
1 answer

Why is there no new table in cnosdb? the data does not seem to be stored in cnosdb

I have configured remote read and write in prometheus, and also configured capture job. Now the data is also displayed on grafana. Why is there no new table in cnosdb? , the data does not seem to be stored in cnosdb.I am using cnosdb official image…
1
vote
0 answers

How to use Cross Join to query data in CnosDB?

I try to use cross join to query data in CnosDB. But I failed. create table air(pressure double, tags(station)); select * from air a1, air a2; Result: "422 Unprocessable Entity, details: {\"error_code\":\"010001\",\"error_message\":\"Datafusion:…
ZuoTiJia
  • 161
  • 5
1
vote
1 answer

Does CnosDB support CASE-WHEN queries?

I have a data set whose original values are integers. The SQL is straightforward: SELECT last("DischargingBattery") FROM battery I would like to convert the none zero numbers into "BUSY" string and zero number into "IDLE". The SQL would like…
Munin
  • 1,576
  • 2
  • 19
1
vote
0 answers

How could I downgrade CnosDB?

I am setting up a CnosDB cluster with the latest version 2.2 and loading piles of CSV files. There might be some breaking fix I suspect. How could I downgrade to previous version with some simple command? cnosdbd downgrade 2.1.0
Munin
  • 1,576
  • 2
  • 19
1
vote
1 answer

While I was using cnosdb, I found a problem with SQL execution failing

I tried to execute some SQL using cnosdb.When I execute the following sql, the execution fails, I don't find the syntax error, the error message is sum(...) ... Not a "field name". Here's the sql I executed: select driver, date_trunc('day',time) as…
HighFive
  • 79
  • 5
1
vote
0 answers

How do I view cluster status in CnosDB?

I have set up the CnosDB cluster (3 meta nodes + 3 data nodes) according to the manual. Is there any easy way to view the cluster status in a command? I found this command doing partial work: curl http://127.0.0.1:21001/metrics curl…
Munin
  • 1,576
  • 2
  • 19
1
vote
0 answers

How do I achieve Change Data Capture in CnosDB

I am migrating some of the IoT data from MySQL to CnosDB and then replicate some of the anomalies and also the changes/delta of the change to ClickHouse for further analysis. Currently I have to do full replication (similar to full backup). Is there…
Munin
  • 1,576
  • 2
  • 19
1
vote
1 answer

SELECT STATEMENT of certain columns don't return anything in CnosDB

Following the CnosDB QuickStart, I am now able to create database, table and insert some data. But SELECT STATEMENT of certain columns don't return anything. Here are the steps to double check: CREATE DATABASE oceanic_station; CREATE TABLE air ( …
Munin
  • 1,576
  • 2
  • 19
1
vote
1 answer

How to rename a field in CnosDB?

I have following data in CnosDB per this doc: > select * from air where visibility > 70 name: air time pressure station temperature visibility ---- -------- ------- ----------- ---------- 2021-08-31T16:00:00Z…
Munin
  • 1,576
  • 2
  • 19
1 2
3
12 13