action #134363
closed[qe-tools] New InfluxDB database for QE-Core metrics
0%
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.
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.
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