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
3
votes
0 answers

How to handle no data alert in CnosDB?

I am using CnosDB + Grafana to collect some system info (CPU, memory) according to the doc. If everything goes well, there will be data all the time. However, if the system down, there would be NO DATA piping into the CnosDB database instance. Is…
Munin
  • 1,576
  • 2
  • 19
3
votes
0 answers

Is CnosDB support geospatial datatype or method?

Many common databases support geospatial types or geospatial methods, as a time series database, does CnosDB support geospatial datatype or method? I have gathered some information for reference only: Redis geospatial:…
Harbour
  • 46
  • 6
3
votes
1 answer

What is the default concurrency of CnosDB client?

I'm starting a connection to a CnosDB cluster but would like to increase the concurrency of the client. Having found this parameter from the doc: -t --target-partitions Optional; the number of slices to execute the query, increasing which can…
Munin
  • 1,576
  • 2
  • 19
2
votes
0 answers

Why run cnosdb docker image in MacOS(m2 chip) failed?

I tried to use cnosdb docker image on MacOS, but it failed to run. This is my running command: docker run --name cnosdb -p 8902:8902 -d cnosdb/cnosdb:community-latest cnosdb run -M singleton and this is my error message: qemu-x86_64: Could not open…
HighFive
  • 79
  • 5
2
votes
0 answers

The data in the coord_data_in table is written to user_queries,is it a issue?

I want to check the query statistics of cnosdb,command as fellow: select * from user_queries order by time desc limit 10; +-------------------------------+--------------+--------------+---------+------+---------+ | time |…
Baker
  • 71
  • 5
2
votes
2 answers

Using CnosDB python connector with pandas, but the returned response has no data

I put the dataset into cnosdb this morning and wanna use pandas to find some coefficients, but it looks like the connector can't parse the response so that it prints the response like this: area dv time 0 area dv time 1 area dv time 2 …
Darts
  • 153
  • 5
2
votes
0 answers

Can cnosdb handle kafka data

I saw that https://docs.cnosdb.com/en/latest/reference/sql.html#stream has a stream processing function in the document. Can Kafka be used as a data source to process data in real time?
cosmic
  • 109
  • 5
2
votes
0 answers

Is there any limit on number of fields we can create in a single table in CnosDB?

To my understanding, if CnosDB stores data using a key-value model and treats all fields as values, there would be a problem where the efficiency decreases as the number of fields increases. I am not sure if my speculation is correct, but I have not…
george
  • 94
  • 6
2
votes
0 answers

Is there a dedicated data type for storing amounts in CnosDB?

Is there a dedicated data type for storing amounts in CnosDB, or which data type do you recommend? In CnosDB, I did not find a no dedicated data type for storing amounts. However, the DECIMAL data type can be used to store monetary values. DECIMAL…
george
  • 94
  • 6
2
votes
0 answers

A problem with writing nanosecond timestamps to a millisecond precision database in cnosdb

I created a database with millisecond precision create database ms with precision 'ms'; and wrote a timestamp with nanosecond precision into it. create table ms_t (value BIGINT,tags(str)); insert into ms_t (time,str,value) values…
cosmic
  • 109
  • 5
2
votes
1 answer

Incorrect results when comparing values of timestamp type with different precisions in CnosDB

To reproduce: select * from user_queries where time <= to_timestamp_millis(1680856751413) limit 1; I can't get correct resultset. Note: time is TimestampNanosecond Expected behavior: I expected to get the correct result
cosmic
  • 109
  • 5
2
votes
1 answer

how can I use k8s dns name when deploy cnosdb cluster?

In k8s, dns name can be unchangable, the ip is unflexable. the cnosdb github repo provide ip to config the clusters, but in kubernetes the cluster should use dns name, please provide a workaround method to config. know the best practise to deploy…
xufei Alex
  • 65
  • 4
2
votes
0 answers

How to replicate data from CnosDB single instance to CnosDB cluster?

I am running several CnosDB single instances on edge side (oil fields) while running one CnosDB cluster in the private cloud. I used to replicate the data from the single instances by exporting the databases to CSV files via export command COPY INTO…
Munin
  • 1,576
  • 2
  • 19
2
votes
1 answer

How to do pagination in CnosDB?

There are some some concepts (limit/offset/slimit/soffset) in CnosDB similar to MySQL's limit/offset. I assume they could be used for pagination but I am really confused that why when I perform a query via limit 1, there are more than 1 result…
Munin
  • 1,576
  • 2
  • 19
2
votes
1 answer

Is there any limit on number of tags we can create in a single database in CnosDB?

OpenTSDB by default support up to 8 tags in a database (see here) and you can modify this in configuration. Since CnosDB is adopting similar tag-set model, is there any limit on the number of tags we can create in a single database here then? I…
Munin
  • 1,576
  • 2
  • 19
1
2 3
12 13