Bug 1814643 - [RFE] Configure Grafana for oVirt DWH
Summary: [RFE] Configure Grafana for oVirt DWH
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine-dwh
Classification: oVirt
Component: Setup
Version: 4.4.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ovirt-4.4.1
: 4.4.1
Assignee: Shirly Radco
QA Contact: Pavel Novotny
URL:
Whiteboard:
Depends On:
Blocks: 1777877
TreeView+ depends on / blocked
 
Reported: 2020-03-18 12:37 UTC by Shirly Radco
Modified: 2020-08-05 06:25 UTC (History)
3 users (show)

Fixed In Version: ovirt-engine-dwh-4.4.1
Clone Of:
Environment:
Last Closed: 2020-08-05 06:25:13 UTC
oVirt Team: Metrics
Embargoed:
sradco: ovirt-4.4?
pm-rhel: planning_ack?
sbonazzo: devel_ack+
lleistne: testing_ack+


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 108576 0 master MERGED Add grafana integration support 2021-01-27 19:16:31 UTC
oVirt gerrit 109048 0 master MERGED Add initial Grafana dashboards 2021-01-27 19:16:31 UTC

Description Shirly Radco 2020-03-18 12:37:26 UTC
We want to add an ansible playbook that installs and configures Grafana to display Dashboards about the data collected in the oVirt DWH.

This would give a simple and relatively low resource monitoring solution for visualizing oVirt metrics.

Comment 1 Yedidyah Bar David 2020-05-06 13:39:37 UTC
In an internal discussion, we decided to do this inside engine-setup, not in a separate ansible playbook.

Current code (not merged yet) is mostly ready. Notable missing parts:

- dashboards. I understand that Shirly is working on this, will update later
- Make it work well also if dwh and engine are on separate machines. Currently grafana is always on dwh machine
- SSO with the engine

Code can be seen here:

https://github.com/didib/ovirt-dwh/tree/grafana-integration
- This is the full branch, with all of my (some small) patches

https://gerrit.ovirt.org/108576
- Above, squashed to a single patch. Might be easier to review, definitely easier on CI...

https://gerrit.ovirt.org/108585
- Engine-side patches

Comment 2 Yedidyah Bar David 2020-05-18 08:13:05 UTC
Note to QE:

I only tested engine-setup when engine+DWH+grafana+DBs are all on the same machine, both new setup and upgrade (via backup/restore) from 4.3.

Please test also at least how it works when everything is on the same machine except for the DWH Database, which you put on a separate machine. I think this is important, for performance, on larger setups, and is hopefully enough.

Other relevant configurations, such as engine on one machine and dwh+grafana on another, are likely broken. If you check them, please open separate bugs for them.

Anyway: Once you finish setup, you can access grafana on:

https://FQDN/ovirt-engine-grafana/

with FQDN being (for now) the FQDN for the engine.

You can login with admin and the password you supplied, or with SSO (there is a button for that).

If you login with SSO, you'll not have admin permissions. after you login with SSO, you can login again with internal admin, and give the SSO user admin permissions. From then on, you can login with SSO and have admin.

Comment 3 Lucie Leistnerova 2020-06-24 13:38:34 UTC
Testing grafana on remote machine is part of Bug 1847963
So this is just basic setup.

Comment 4 Pavel Novotny 2020-07-15 21:43:58 UTC
Verified in
ovirt-engine-4.4.1.8-0.7.el8ev.noarch
ovirt-engine-dwh-4.4.1.2-1.el8ev.noarch

engine-setup installs and configures the Grafana instance (tried only everything on the same machine).
User admin@internal has access to the Grafana UI by default (login via Grafana login form or via oVirt Engine Auth).
Inviting & setting up new users works as well.

Following dashboards are available:

oVirt Executive Dashboards
  Cluster Dashboard
  Datacenter Dashboard
  Executive Dashboard
  System Dashboard

oVirt Inventory Dashboards
  Hosts Inventory Dashboard
  Inventory Dashboard
  Storage Domains Inventory Dashboard
  VMs Inventory Dashboard

oVirt Service Level Dashboards
  Cluster Quality of Service - Hosts Dashboard
  Cluster Quality of Service - Virtual Machines Dashboard
  Hosts Uptime Dashboard
  Uptime Dashboard
  Virtual Machines Uptime Dashboard

oVirt Trend Dashboards
  Hosts Resource Usage Dashboard
  Hosts Trend Dashboard
  Trend Dashboard
  Virtual Machines Resource Usage Dashboard
  Virtual Machines Trend Dashboard

Comment 5 Sandro Bonazzola 2020-08-05 06:25:13 UTC
This bugzilla is included in oVirt 4.4.1 release, published on July 8th 2020.

Since the problem described in this bug report should be resolved in oVirt 4.4.1 release, it has been closed with a resolution of CURRENT RELEASE.

If the solution does not work for you, please open a new bug report.


Note You need to log in before you can comment on or make changes to this bug.