Monitoring
Data for monitoring
Now we monitor two types of events for monitoring: request and error. First type is all requests, second is failed requests only.
Comparison of data formats for Clickhouse and InfluxDB:
InfluxDB: Each event is presented as a “point” in a time series. The structure of a point includes:
series name
start event time
tags, indexed data in storage, dictionary: keys - string tag names, values - string, integer, float
fields, non indexed data in storage, dictionary: keys - string tag names, values - string, integer, float
Clickhouse: In Clickhouse, the data structure resembles that of a traditional SQL table. Each event is represented as a record, where:
The `time` field contains the record’s creation timestamp;
The `data` field contains a JSON object with all the information that would otherwise be distributed across tags and fields in InfluxDB.
Important: In Clickhouse, there is no differentiation between “tags” and “fields”—all data is consolidated into a single JSON object within the data field.
The structure and the meaning of each monitoring series remain consistent. However, for Clickhouse, data from tags and fields are merged into a single JSON object under the data field. Below are examples for each series:
Requests series.
Triggered on every request. Each point contains a data about corresponding request (execution time and etc).
InfluxDB:
tags
tag name
description
service
always “luna-lambda”
route
concatenation of a request method and a request resource (POST:/plugin)
status_code
http status code of response
fields
fields
description
request_id
request id
execution_time
request execution time
ClickHouse JSON `data` field Example:
{ "service": "luna-lambda", "route": "POST:/plugin", "status_code": 204, "request_id": "1536751345,6a5c2191-3e9b-f5a4-fc45-3abf43625c5f", "execution_time": 123.45 }
Errors series.
Triggered on failed request. Each point contains error_code of luna error.
InfluxDB:
tags
tag name
description
service
always “luna-lambda”
route
concatenation of a request method and a request resource (POST:/plugins)
status_code
http status code of response
error_code
luna error code
fields
fields
description
request_id
request id
ClickHouse JSON `data` field Example:
{ "service": "luna-lambda", "route": "POST:/plugins", "status_code": 400, "error_code": 13037, "request_id": "1536751345,6a5c2191-3e9b-f5a4-fc45-3abf43625c5f", }
Database
You can refer to documentation for influx database and clickhouse database to compare the databases and choose what benefit your needs more. Note that clickhouse might be the better choice for aggregation You can setup your database credentials in configuration file in section “monitoring”.