openGemini data source plugin

OpenGemini is a global open-source cloud-native distributed time series database. It provides standalone and distributed versions with excellent read and write performance and efficient data analysis capabilities. Supports mainstream development languages and multi-form deployment (such as cloud, Docker, and physical machine), integrates storage and analysis, and is easy to expand. It is dedicated to efficiently storing and analyzing massive time series data in IoT and O&M monitoring scenarios to further reduce enterprise operation and O&M costs and improve product quality and production efficiency.

Plugin usage

1. Click left menuConnections

   

2. Select openGemini

   

3. ClickAdd new data source

   

Datasource configuration

1. Configure parameters for linking to openGemini, such as HTTP URL, user name, password, database and other related information

   

2. Configuration item description

   • Name Set the name of the datasource
   • Default Default datasource
   • URL The HTTP protocol, IP address, and port of your InfluxDB API. InfluxDB’s default API port is 8086.
   • Allowed cookies Defines which cookies are forwarded to the data source. All other cookies are deleted.
   • Timeout Timeout
   • Database Default database
   • HTTP Method Sets the HTTP method used to query your data source. The POST verb allows for larger queries that would return an error using the GET verb. Defaults to GET.
   • Min time interval Defines a lower limit for the auto group-by time interval.

Query

Query syntax: openGemini docs

Format as：Choose to format the data as time series, table, log.

Alias by: Support replace the measurement name,column name or tag name

• $measurement replace measurement name
• $col replace column name
• $tag_exampletag replace exampletag tag value

For example, query the CPU usage of each node, query statement

SELECT mean("CpuUsage") FROM $database.."system" WHERE $timeFilter GROUP BY time($__interval), "host" fill(null)

Alias by filling in $tag_host indicates the presentation of the default measurement name with the host value

Use time series and table format to display the effect as shown in the following figure:

​ time series

​ table

Query logs. The query statement is as follows:

select * from mst181998 limit 100