Bug 1854791 - "Migrating the Manager Database to a Remote Server" is broken
Summary: "Migrating the Manager Database to a Remote Server" is broken
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: Documentation
Version: 4.4.0
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ovirt-4.4.5
: ---
Assignee: Donna DaCosta
QA Contact: rhev-docs@redhat.com
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-07-08 09:14 UTC by Yedidyah Bar David
Modified: 2021-03-10 20:58 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: No Doc Update
Doc Text:
Clone Of:
Environment:
Last Closed: 2021-03-10 20:58:26 UTC
oVirt Team: Docs
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Yedidyah Bar David 2020-07-08 09:14:50 UTC
Description of problem:

The procedure to migrate the engine/Manager database to a separate machine [1] is not working.

It should either be fixed or removed.

It's not clear we want to keep it, even if it can be fixed. Our testing indicates that usually, running the engine db on the engine machine performs better, overall.

The only reason we can think of, for running on a separate machine, is for organizations that know PostgreSQL well, have policies/tooling/etc for managing it, and prefer to put every PG database they can, on their own PG infrastructure.

It's probably broken for a long time now.

The procedure to migrate DWH (and its DB) to a separate machine, on the other hand, does make sense, from a performance point-of-view, and should definitely be maintained in the future (and is generally up-to-date, although I didn't test it myself recently (and it might require some fixes as well).

[1] https://access.redhat.com/documentation/en-us/red_hat_virtualization/4.4-beta/html/administration_guide/migrating-rhv-databases

Comment 1 Steve Goodman 2020-07-09 08:04:47 UTC
Lucie, could you please share your thoughts on and experience with this?

Comment 2 Lucie Leistnerova 2020-07-27 22:04:19 UTC
I was doing some testing to migrate engine database to separate machine and also create ansible role to do that on 4.3 https://github.com/oVirt/ovirt-ansible-local-to-remote-db.
I can see use cases where it can be requested but on large environments it probably will cause performance issues.

On the other hand migrating dwh database and service makes sense with Grafana as Didi said and I'm testing it in Bug 1860067.

Comment 4 Steve Goodman 2020-07-29 13:52:23 UTC
From @mtessun via gchat in response to Marina:

Thanks. @Steve Goodman So let's drop it instead of fixing it.

So I will remove this topic from the RHV 4.4 documentation.


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