action #134363
closed
[qe-tools] New InfluxDB database for QE-Core metrics
Added by mgrifalconi 9 months ago.
Updated 9 months ago.
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.
- 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.
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
Also available in: Atom
PDF