Most of them are outdated , but provide historical design context.
They are not user documentation and should not be treated as such.
Documentation is available here.
Separate DWH Host
Allow ovirt-engine-dwh to be installed and configured by engine-setup on a separate machine, without requiring ovirt-engine to be on the same host.
- Name: Didi (Didi)
- Email: email@example.com
Implemented, should be available in 3.5.
We assume that engine is already setup and running on machine A. We assume that user wants to install dwh on machine B.
We need access to the engine's database. If on separate host, user will be prompted for them.
We need to also fix bug https://bugzilla.redhat.com/1059283 - check minimal ETL version, as we'll not be able to rely on package dependencies anymore.
Migrating an existing DWH and Reports installation
For migration of an existing local installation of DWH and Report to a different server please refer to Migration_of_local_DWH_Reports_to_remote.
Benefit to oVirt
DWH sometimes causes a significant load on the engine machine. Installing it on a separate machine will allow distributing the load.
Dependencies / Related Features
Documentation / External references
An annotated example setup on three machines is part of the related feature page Separate-Reports-Host.
Install and setup ovirt-engine on machine A, ovirt-engine-dwh on machine B, see that dwhd on B collects data from the engine on A.
yum install ovirt-engine-setup engine-setup
yum install ovirt-engine-dwh-setup engine-setup
dwhd is currently running
You might get en error from engine-setup 'dwhd is currently running'.
To fix this, you can try one of the following:
service ovirt-engine-dwhd restart
and make sure that it stopped and started cleanly (without errors in the log)
- Clear DwhCurrentlyRunning
Make sure that dwhd is stopped, and then, in the engine's database,
UPDATE dwh_history_timekeeping SET var_value = 0 WHERE var_name = 'DwhCurrentlyRunning';
When upgrading the engine, dwhd must be first stopped, then upgraded, then started. Otherwise it might try to collect inconsistent data, from a database in the middle of an upgrade, or from an upgraded database. In previous versions this was forced by engine-setup. Now that might be impossible, if they are on separate machines. To enforce that, a new flag was added to the database, marking that dwhd is up. It's set by dwhd on start, cleared on stop, and tested by engine-setup. Another flag was added to mark that dwhd should stop. If engine-setup sees that dwhd is up, it asks it to stop by marking that flag, then waits some time, and eventually times out and aborts if dwhd didn't mark that it is stopped. The most likely cause of this is an uncontrolled exit of dwhd, e.g. killing it with SIGKILL or unplugging the power of its host.
Separate DWH Host Separate DWH Host Separate DWH Host