Chapter 3. About the History Database
3.1. History Database Overview
Red Hat Virtualization includes a comprehensive management history database, which can be used by reporting applications to generate reports at data center, cluster and host levels. This chapter provides information to enable you to set up queries against the history database.
Red Hat Virtualization Manager uses PostgreSQL 12.x
as a database platform to store information about the state of the virtualization environment, its configuration and performance. At install time, Red Hat Virtualization Manager creates a PostgreSQL database called engine
.
Installing the ovirt-engine-dwh
package creates a second database called ovirt_engine_history
, which contains historical configuration information and statistical metrics collected every minute over time from the engine
operational database. Tracking the changes to the database provides information on the objects in the database, enabling the user to analyze activity, enhance performance, and resolve difficulties.
The replication of data in the ovirt_engine_history
database is performed by the Red Hat Virtualization Manager Extract Transform Load Service, ovirt-engine-dwhd
. The service is based on Talend Open Studio, a data integration tool. This service is configured to start automatically during the data warehouse package setup. It is a Java program responsible for extracting data from the engine
database, transforming the data to the history database standard and loading it to the ovirt_engine_history
database.
The ovirt-engine-dwhd
service must not be stopped.
The ovirt_engine_history
database schema changes over time. The database includes a set of database views to provide a supported, versioned API with a consistent structure. A view is a virtual table composed of the result set of a database query. The database stores the definition of a view as a SELECT
statement. The result of the SELECT
statement populates the virtual table that the view returns. A user references the view name in PL/PGSQL
statements the same way a table is referenced.