Hi all, is this the correct way to move engine db from one server to another? 1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup Thanks, Giorgio
check this out: http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab... 2016-01-25 11:59 GMT-03:00 Giorgio Bart <giorgiobart300@gmail.com>:
Hi all, is this the correct way to move engine db from one server to another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup
Thanks, Giorgio
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
The problem should be only the encrypted password? I'd like to know if engine-setup will read and apply the new configurations from the file 2016-01-25 16:02 GMT+01:00 Marcelo Leandro <marceloltmm@gmail.com>:
check this out:
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab...
2016-01-25 11:59 GMT-03:00 Giorgio Bart <giorgiobart300@gmail.com>:
Hi all, is this the correct way to move engine db from one server to another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup
Thanks, Giorgio
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
On Mon, Jan 25, 2016 at 5:08 PM, Giorgio Bart <giorgiobart300@gmail.com> wrote:
The problem should be only the encrypted password? I'd like to know if engine-setup will read and apply the new configurations from the file
Sorry, I missed that. I think that 'service ovirt-engine start' will be enough - no engine-setup will be needed, and that if you do run it (e.g. to upgrade), that too will work correctly.
2016-01-25 16:02 GMT+01:00 Marcelo Leandro <marceloltmm@gmail.com>:
check this out:
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab...
2016-01-25 11:59 GMT-03:00 Giorgio Bart <giorgiobart300@gmail.com>:
Hi all, is this the correct way to move engine db from one server to another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup
Thanks, Giorgio
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
Ok, so if i modify any of the config under /etc/ovirt-engine, for example the db parameters, and restart the engine service it should just work, right ? 2016-01-25 16:11 GMT+01:00 Yedidyah Bar David <didi@redhat.com>:
On Mon, Jan 25, 2016 at 5:08 PM, Giorgio Bart <giorgiobart300@gmail.com> wrote:
The problem should be only the encrypted password? I'd like to know if engine-setup will read and apply the new configurations from the file
Sorry, I missed that. I think that 'service ovirt-engine start' will be enough - no engine-setup will be needed, and that if you do run it (e.g. to upgrade), that too will work correctly.
2016-01-25 16:02 GMT+01:00 Marcelo Leandro <marceloltmm@gmail.com>:
check this out:
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab...
2016-01-25 11:59 GMT-03:00 Giorgio Bart <giorgiobart300@gmail.com>:
Hi all, is this the correct way to move engine db from one server to another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup
Thanks, Giorgio
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
On Mon, Jan 25, 2016 at 6:27 PM, Giorgio Bart <giorgiobart300@gmail.com> wrote:
Ok, so if i modify any of the config under /etc/ovirt-engine, for example the db parameters, and restart the engine service it should just work, right ?
In principle, yes.
2016-01-25 16:11 GMT+01:00 Yedidyah Bar David <didi@redhat.com>:
On Mon, Jan 25, 2016 at 5:08 PM, Giorgio Bart <giorgiobart300@gmail.com> wrote:
The problem should be only the encrypted password? I'd like to know if engine-setup will read and apply the new configurations from the file
Sorry, I missed that. I think that 'service ovirt-engine start' will be enough - no engine-setup will be needed, and that if you do run it (e.g. to upgrade), that too will work correctly.
2016-01-25 16:02 GMT+01:00 Marcelo Leandro <marceloltmm@gmail.com>:
check this out:
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab...
2016-01-25 11:59 GMT-03:00 Giorgio Bart <giorgiobart300@gmail.com>:
Hi all, is this the correct way to move engine db from one server to another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup
Thanks, Giorgio
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
-- Didi
Thanks! I'll try ! 2016-01-25 18:54 GMT+01:00 Yedidyah Bar David <didi@redhat.com>:
On Mon, Jan 25, 2016 at 6:27 PM, Giorgio Bart <giorgiobart300@gmail.com> wrote:
Ok, so if i modify any of the config under /etc/ovirt-engine, for example the db parameters, and restart the engine service it should just work, right ?
In principle, yes.
2016-01-25 16:11 GMT+01:00 Yedidyah Bar David <didi@redhat.com>:
On Mon, Jan 25, 2016 at 5:08 PM, Giorgio Bart <giorgiobart300@gmail.com
wrote:
The problem should be only the encrypted password? I'd like to know if engine-setup will read and apply the new configurations from the file
Sorry, I missed that. I think that 'service ovirt-engine start' will be enough - no engine-setup will be needed, and that if you do run it (e.g. to upgrade), that too will work correctly.
2016-01-25 16:02 GMT+01:00 Marcelo Leandro <marceloltmm@gmail.com>:
check this out:
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab...
2016-01-25 11:59 GMT-03:00 Giorgio Bart <giorgiobart300@gmail.com>:
Hi all, is this the correct way to move engine db from one server to
another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup
Thanks, Giorgio
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
-- Didi
----- Original Message -----
From: "Giorgio Bart" <giorgiobart300@gmail.com> To: "Yedidyah Bar David" <didi@redhat.com> Cc: "users" <Users@ovirt.org> Sent: Monday, January 25, 2016 7:51:05 PM Subject: Re: [ovirt-users] moving db
Thanks! I'll try !
2016-01-25 18:54 GMT+01:00 Yedidyah Bar David < didi@redhat.com > :
On Mon, Jan 25, 2016 at 6:27 PM, Giorgio Bart < giorgiobart300@gmail.com > wrote:
Ok, so if i modify any of the config under /etc/ovirt-engine, for example the db parameters, and restart the engine service it should just work, right ?
In principle, yes.
2016-01-25 16:11 GMT+01:00 Yedidyah Bar David < didi@redhat.com >:
On Mon, Jan 25, 2016 at 5:08 PM, Giorgio Bart < giorgiobart300@gmail.com > wrote:
The problem should be only the encrypted password? I'd like to know if engine-setup will read and apply the new configurations from the file
Sorry, I missed that. I think that 'service ovirt-engine start' will be enough - no engine-setup will be needed, and that if you do run it (e.g. to upgrade), that too will work correctly.
2016-01-25 16:02 GMT+01:00 Marcelo Leandro < marceloltmm@gmail.com >:
check this out:
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab...
2016-01-25 11:59 GMT-03:00 Giorgio Bart < giorgiobart300@gmail.com >:
Hi all, is this the correct way to move engine db from one server to another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf
If you want to move oVirt 3.6 database please don't forget on aaa-jdbc database for 'internal' domain configured in /etc/ovirt-engine/aaa/internal.properties By default it's contained in engine database but in different schema name ( 'aaa-jdbc' for internal domain, 'public' for engine).
5) run engine-setup
Thanks, Giorgio
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
-- Didi
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Thank you Martin. I was talking about 3.5 here, forgot to mention. 2016-01-25 20:34 GMT+01:00 Martin Perina <mperina@redhat.com>:
----- Original Message -----
From: "Giorgio Bart" <giorgiobart300@gmail.com> To: "Yedidyah Bar David" <didi@redhat.com> Cc: "users" <Users@ovirt.org> Sent: Monday, January 25, 2016 7:51:05 PM Subject: Re: [ovirt-users] moving db
Thanks! I'll try !
2016-01-25 18:54 GMT+01:00 Yedidyah Bar David < didi@redhat.com > :
On Mon, Jan 25, 2016 at 6:27 PM, Giorgio Bart < giorgiobart300@gmail.com
wrote:
Ok, so if i modify any of the config under /etc/ovirt-engine, for example the db parameters, and restart the engine service it should just work, right ?
In principle, yes.
2016-01-25 16:11 GMT+01:00 Yedidyah Bar David < didi@redhat.com >:
On Mon, Jan 25, 2016 at 5:08 PM, Giorgio Bart <
giorgiobart300@gmail.com >
wrote:
The problem should be only the encrypted password? I'd like to know if engine-setup will read and apply the new configurations from the file
Sorry, I missed that. I think that 'service ovirt-engine start' will be enough - no engine-setup will be needed, and that if you do run it (e.g. to upgrade), that too will work correctly.
2016-01-25 16:02 GMT+01:00 Marcelo Leandro < marceloltmm@gmail.com
:
check this out:
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration#engine-setup_Datab...
2016-01-25 11:59 GMT-03:00 Giorgio Bart < giorgiobart300@gmail.com
:
> Hi all, > is this the correct way to move engine db from one server to another? > > 1) service engine stop > 2) dump db > 3) restore dump on new db server > 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf
If you want to move oVirt 3.6 database please don't forget on aaa-jdbc database for 'internal' domain configured in
/etc/ovirt-engine/aaa/internal.properties
By default it's contained in engine database but in different schema name ( 'aaa-jdbc' for internal domain, 'public' for engine).
> 5) run engine-setup > > Thanks, > Giorgio > > > > _______________________________________________ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users >
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
-- Didi
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
On Mon, Jan 25, 2016 at 4:59 PM, Giorgio Bart <giorgiobart300@gmail.com> wrote:
Hi all, is this the correct way to move engine db from one server to another?
1) service engine stop 2) dump db 3) restore dump on new db server 4) modify /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 5) run engine-setup
In principle, yes. You'll also have to take care of iptables etc., also postgresql stuff (create user/database, allow access). If you have dwh, you'll have to configure it too. Check this for some similar flows: http://www.ovirt.org/Features/Migration_of_local_DWH_Reports_to_remote Best, -- Didi
participants (4)
-
Giorgio Bart -
Marcelo Leandro -
Martin Perina -
Yedidyah Bar David