• Database Design

    High Availability and Fault Tolerance


    Having a highly available and fault tolerant cluster is a critical component of a production environment. Vertica utilizes a concept called K-safety to measure fault tolerance. High availability comes from having at least three nodes and replicating small tables or creating buddy projections for larger tables. This post will discuss and illustrate these concepts.

  • Administration

    April Release of VerticaKit


    The April 2015 release has the following changes: Updated unused projection query to exclude system tables Adds diagnostic query Cluster query distribution to identify potential load balancing issues

  • News

    Back to Basics


    The previous effort to provide news & resources on vertica.help hasn’t had the desired result. Embracing the established traffic of vertica.tips, all resources from vertica.help have been migrated to vertica.tips. With the migration, a cleaner theme has been deployed to provide easy navigation for existing content (in the header) as well as migrated resources (top…

  • Tips & Tricks

    Check load balancing


    In an ideal environment, all clients connecting to the database will request a load balanced connection; as well as having load balancing enabled on the database. This quick tip shows how to see the request distribution across a cluster.

  • News

    Vertica 8.0 Announced


    Vertica announced their newest release today. This new version takes the existing column architecture, and combines traditional row store into a completely new product.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.