1.3. Migrating Data Warehouse to a Separate Machine

Ensure that all packages currently installed are up to date:

# yum update

Install the ovirt-engine-dwh-setup package:

# yum install ovirt-engine-dwh-setup

Stop the Data Warehouse service:

# systemctl stop ovirt-engine-dwhd.service

If the database is hosted on a remote machine, you must manually grant access by editing the postgres.conf file. Edit the /var/lib/pgsql/data/postgresql.conf file and modify the listen_addresses line so that it matches the following:

listen_addresses = '*'

If the line does not exist or has been commented out, add it manually.

If the database is hosted on the Manager machine and was configured during a clean setup of the Red Hat Virtualization Manager, access is granted by default.

See Section 1.3.1, “Migrating the Data Warehouse Database to a Separate Machine” for more information on how to configure and migrate the Data Warehouse database.

Restart the postgresql service:

# systemctl rh-postgresql95-postgresql restart

If you are migrating both the ovirt_engine_history database and the Data Warehouse service to the same machine, run the following, otherwise proceed to the next step.

# sed -i '/^ENGINE_DB_/d' \
        /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf

# sed -i \
     -e 's;^\(OVESETUP_ENGINE_CORE/enable=bool\):True;\1:False;' \
     -e '/^OVESETUP_CONFIG\/fqdn/d' \
     /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf

Run the engine-setup command to begin configuration of Data Warehouse on the machine:

# engine-setup

Press Enter to configure Data Warehouse:

Configure Data Warehouse on this host (Yes, No) [Yes]:

Press Enter to accept the automatically detected host name, or enter an alternative host name and press Enter:

Host fully qualified DNS name of this server [autodetected host name]:

Press Enter to automatically configure the firewall, or type No and press Enter to maintain existing settings:

Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]:

If you choose to automatically configure the firewall, and no firewall managers are active, you are prompted to select your chosen firewall manager from a list of supported options. Type the name of the firewall manager and press Enter. This applies even in cases where only one option is listed.

Enter the fully qualified domain name and password for the Manager. Press Enter to accept the default values in each other field:

Host fully qualified DNS name of the engine server []: engine-fqdn
Setup needs to do some actions on the remote engine server. Either automatically, using ssh as root to access it, or you will be prompted to manually perform each such action.
Please choose one of the following:
1 - Access remote engine server using ssh as root
2 - Perform each action manually, use files to copy content around
(1, 2) [1]:
ssh port on remote engine server [22]:
root password on remote engine server engine-fqdn: password

Answer the following question about the location of the ovirt_engine_history database:

Where is the DWH database located? (Local, Remote) [Local]: Remote

Type the alternative option as shown above then press Enter.

Enter the fully qualified domain name and password for your ovirt_engine_history host. Press Enter to accept the default values in each other field:

DWH database host []: dwh-db-fqdn
DWH database port [5432]:
DWH database secured connection (Yes, No) [No]:
DWH database name [ovirt_engine_history]:
DWH database user [ovirt_engine_history]:
DWH database password: password

See Section 1.3.1, “Migrating the Data Warehouse Database to a Separate Machine” for more information on how to configure and migrate the Data Warehouse database.

Enter the fully qualified domain name and password for the Manager database machine. Press Enter to accept the default values in each other field:

Engine database host []: engine-db-fqdn
Engine database port [5432]:
Engine database secured connection (Yes, No) [No]:
Engine database name [engine]:
Engine database user [engine]:
Engine database password: password

Choose how long Data Warehouse will retain collected data::

Please choose Data Warehouse sampling scale:
	(1) Basic
	(2) Full
	(1, 2)[1]:

Full uses the default values for the data storage settings listed in Section 2.4, “Application Settings for the Data Warehouse service in ovirt-engine-dwhd.conf” (recommended when Data Warehouse is installed on a remote host).

Basic reduces the values of DWH_TABLES_KEEP_HOURLY to 720 and DWH_TABLES_KEEP_DAILY to `0, easing the load on the Manager machine but with a less detailed history.

Confirm that you want to permanently disconnect the existing Data Warehouse service from the Manager:

Do you want to permanently disconnect this DWH from the engine? (Yes, No) [Yes]:

Confirm your installation settings:

Please confirm installation settings (OK, Cancel) [OK]:

On the Manager machine, restart the Manager:

# service ovirt-engine restart

Disable the Data Warehouse service:

# systemctl disable ovirt-engine-dwhd.service

Remove the Data Warehouse files:

# rm -f /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/* .conf /var/lib/ovirt-engine-dwh/backups/*