New and changed in Vertica 25.1

New features and changes in Vertica 25.1.

Client proxy for subclusters in Kubernetes

Connections are now redirected through the client proxy before reaching the Vertica nodes. For details on enabling client proxy, creating replicas, and connecting to Vertica nodes through the proxy, see Client proxy for subclusters.

Shut down sandbox and subcluster in Kubernetes

You can now stop and shut down the sandbox along with all its subclusters. For more information, see Sandboxing on K8s. You can also stop and shut down individual subclusters in the main cluster. See Scaling subclusters.

Async replication in Kubernetes

Previously, Kubernetes supported only synchronous replication which required replicating the entire database. Now, replication is asynchronous by default. The VerticaDB operator initiates replication and checks progress periodically without waiting for the replication to complete. Additionally, partial replication is supported, allowing you to replicate specific schemas or tables based on names or wildcard patterns to be replicated instead of the entire database. This provides better control and efficiency in replication tasks. For more information, see VerticaReplicator custom resource definition.

Execute data loader file parameters

You can now specify parameters such as compression and node assignment for each file in the WITH FILES clause of EXECUTE DATA LOADER. For more details about parameter transfer and override rules, see EXECUTE DATA LOADER.

Eon Mode

Multiple communal storage locations

Eon Mode databases now support multiple communal storage locations. You can add communal storage locations to your database with the CREATE LOCATION function, and then use the SET_OBJECT_STORAGE_POLICY function to assign database objects to one of the storage locations.

In-database restore points

In-database restore points are lightweight, copy-free backups for Eon Mode databases that enable you to roll back a database to the state at which a restore point was saved. Unlike vbr-based backups, restore points are stored in-database and do not require additional data copies to be stored externally, which results in fast restore point creation and low storage overhead. For more information about in-db restore points, see In-DB restore points.

Health Watchdog tuning knobs

Tuning knobs have been added to the Health Watchdog to tune it to your system. For more details, see Health Watchdog.

About OpenText Core Analytics Database

OpenText™ Core Analytics Database (OTCAD) provides a managed database service for your data management needs, as it integrates with leading cloud service providers such as AWS. OTCAD:

  • Manages your data and helps you avoid daily maintenance of a data warehouse or data lake environment.
  • Provides data analysts and business intelligence professionals with access to powerful analytics and reporting tools, facilitating efficient insights from large datasets.
  • Uses Vertica running on Kubernetes as the main engine for the data warehouse or data lake.

OTCAD is a cloud solution that enhances the speed and scalability of a Vertica analytics database without the need to manage hardware. Use OTCAD to build databases securely and scale them to large amounts of data in the cloud.

OTCAD supports machine learning with VerticaPy for data science and AI-driven data science applications. It also supports the following third-party applications:

  • IBM Cognos BI
  • Grafana
  • Informatica PowerCenter
  • DbVisualizer
  • DBeaver
  • Domino Data Lab

To get access to OTCAD, contact your sales representative or contact us.