Project

General

Profile

Actions

action #134363

closed

[qe-tools] New InfluxDB database for QE-Core metrics

Added by mgrifalconi 10 months ago. Updated 10 months ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
-
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:

Description

Hello,

please create a new database in the existing InfluxDB instance used in monitor.qa.suse.de to allow qe-core to send its own metrics and statistics.

I would be ok to share the existing database if creating a new one is a problem, but I see no reasons to. Having our own DB makes us more independent on retention rules, and less likely to bother each other while trying out things.

I expect something like this https://docs.influxdata.com/influxdb/v1.8/introduction/get-started/#creating-a-database to be needed.

Asking for high prio since it seems a pretty easy task and openQA review + management are looking forward to have these statistics shown.

Actions #2

Updated by szarate 10 months ago

  • Tags set to platform-team
  • Project changed from 46 to openQA Infrastructure
  • Status changed from New to Resolved
  • Assignee set to szarate
  • Target version set to QE-Core: Ready

datasource is qametrics-maintenance, and the database is maintenanceBlocked; to the best of my knowledge databases in influxdb are datasources in grafana.

Let me know if something else is needed, gave you editor rights too.

Actions #3

Updated by szarate 10 months ago

In the end, all I did was:

influx -password $password -username $user  -host stats.openqa-monitor.qa.suse.de -execute 'CREATE DATABASE maintenanceMetrics' 
influx -password $password -username $user  -host stats.openqa-monitor.qa.suse.de -database 'maintenanceMetrics' -execute 'INSERT cpu,host=serverA,region=us_west value=0.64'
influx -password $password -username $user  -host stats.openqa-monitor.qa.suse.de -execute 'SHOW MEASUREMENTS on maintenanceMetrics
Actions

Also available in: Atom PDF