Bug 1854791

Summary:	"Migrating the Manager Database to a Remote Server" is broken
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Yedidyah Bar David <didi>
Component:	Documentation	Assignee:	Donna DaCosta <ddacosta>
Status:	CLOSED CURRENTRELEASE	QA Contact:	rhev-docs <rhev-docs>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	4.4.0	CC:	ctomasko, germano, lleistne, lsurette, mhicks, mkalinin, sgoodman, srevivo
Target Milestone:	ovirt-4.4.5	Keywords:	Documentation, NoDocsQEReview
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	No Doc Update
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2021-03-10 20:58:26 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Docs	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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.