Product Description

The cluster-based, column-oriented Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications.

Architecture

Known Versions

• 3.0
• 3.5
• 4.1
• 5.0
• 5.1
• 6.0
• 6.1
• 7.0
• 7.1
• 7.2

Software Pattern Summary

Platforms Supported by the Pattern

The patterns discover HP Vertica deployed on UNIX platforms only.

Identification

Software Instance Triggers

Simple Identification Mappings

The trigger process is given a simple identification mapping:

Obtaining install root

The VerticaDBNode pattern obtains install root from process using regex:

• "(?i)(/\S+)/bin/vertica"

Obtaining the version information

Active Versioning

The VerticaDBNode pattern executes the following command :

• "process.cmd --version"

From the output full version is extracted using regex :

• '(?i)vertica\(v(\d+(?:\.\d+)*)'

Package Versioning

The VerticaDBNode pattern looks for packages installed that would match regex "(?i)^vertica"

Obtaining database details

The VerticaDBNode pattern obtains db details from process arguments using the following regexes:

• "-C\s+(\S+)" - for db node type
• "-D\s+(\S+)" - for db home
• "-n\s+(\S+)" - for db node id

Application Model Produced by Software Pattern

Architecture

BMC Atrium Discovery uses the following approach for modeling HP Vertica components.

Software Pattern Model

Pattern Trigger

The VerticaDBNode pattern triggers on a discovered process with command line that matches specific regular expression.

The Vertica_Cluster pattern triggers on a created and confirmed HP Vertica Database Node SI that would have cluster_hosts attribute.

SI Depth

TheVerticaDBNode pattern creates an instance-based Software Instance with the key based on the SI type, and the host key.

The Vertica_Cluster pattern creates a second-order Software Instance with the key based on the cluster_hosts attribute and the SI type.

Software Context view

The image below is an example of software context view of the HP Vertica and related software:

Relationship creation

The pattern creates the following relationships:

model.setContainment :

• Containment relationships where HP Vertica Database contains the trigger HP Vertica Database Node SIs that belongs to the same cluster hosts group.

Subject Matter Expertise

Subject Matter Expert input will be welcome on any other potential approaches not discussed to improving product versioning coverage and depth of
HP Vertica model.

Information Sources

Open Issues

There are no known open issues with this pattern.