Vertica Blog

Vertica Blog

Backup and Restore

Rocket to Moon with Vertica version 10.1

Vertica 10.1 Rockets Data Analytics to the Next Level

Paige Roberts, Vertica Open Source Relations Manager
February 1, 2021

As of February 1, 2021, the new version of Vertica rockets analytical database technology to the next level. Vertica 10.1 continues to show our commitment to broad, powerful in-database machine learning by including our most requested algorithm – XGBoost. Management Console makes administering Vertica in the cloud even easier. Support for complex data types in...
Return on Investment ROI

What’s the Deal with Vertica TCO?

Paige Roberts, Vertica Open Source Relations Manager
August 26, 2020

Recently, a colleague of mine was trying to express why Vertica had such a low total cost of ownership (TCO). It’s not obvious. Our customers rave about the fast return on investment. We have a half dozen excellent case studies from third-parties showing Vertica’s ROI. But why? Open source options are free. Vertica isn’t free....
WOS ROS differences

Write Optimized Store (WOS) Deprecation – What You Need to Know

Sumeet Keswani, Vertica Product Technology Engineer
March 23, 2020

In Vertica 10.0, WOS (Write Optimized Store) will be deprecated. In this blog, we introduce the historical justification for WOS and its purpose, why we believe that it's no longer needed, and our justification for deprecating it. We'll go over the data and the testing we performed that gives us the confidence to ensure that...
Vertica and Amazon logos

Vertica and Amazon – Better Together, for Years

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
October 23, 2019

The year was 2012. Marvel’s The Avengers hit the box office. Facebook went public. NASA's Curiosity rover landed on the surface of Mars. And, the Vertica AMI (Amazon Machine Image) made its debut on AWS Marketplace, enabling data-driven organizations to easily deploy Vertica on the Amazon cloud and start accelerating their analytics. Running Vertica on...
Compass rose with true north pointing to "Helpful Tips" text

Tracking VBR Invocations

James Knicely, Vertica Field Chief Technologist
June 28, 2019

The Vertica Backup and Recovery tool (vbr) allows you to back up and restore either the full database, or one or more schema and table objects of interest. You can also copy a cluster and list backups you created previously. You can view vbr invocations by querying the DC_VBR_INVOCATIONS data collector table! Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/VBRUtilityReference.htm...
Three 3D arrows, different colors pointing in different directions

Upgrading Vertica

Soniya Shah, Information Developer
June 14, 2018

Vertica adds new features and enhances existing features with every release. To access the new and improved features, upgrade to the latest release of Vertica. Prerequisites Before you upgrade, perform the following: Perform a full database backup. If upgrade is unsuccessful, a full back up allows you to roll back to your current version. You...

Expanding Your Cluster with New Nodes

Soniya Shah, Information Developer
June 14, 2018

Does your business need more storage? Consider adding nodes to your database if you need more storage. Vertica recommends that you add all new nodes at the same time. You can use this checklist to add nodes. These are basic steps. There are additional options discussed in the Vertica documentation. Step Task Results 1 Perform...

What Should I do if my Node Recovery is Slow?

Soniya Shah, Information Developer
June 14, 2018

If you are running Vertica 7.2.x or later, perform recovery by table. For details, see Recovery By Table in the Vertica documentation. If you are running a Vertica version prior to 7.1.x, stop the ETL jobs and restart node recovery. Step Task Results 1 Monitor progress of recovery: If is_running = f, recovery completed. Repeat...

Reusing EBS Volumes

Soniya Shah, Information Developer
May 24, 2018

This blog post was authored by Mark Hayden. You can deploy a Vertica cluster running in Eon or Enterprise mode using EC2 instances that support EBS volumes. This document provides the steps you need to use EBS volumes that were preserved from a Vertica cluster that was terminated, and how to reattach them to revive...

Understanding Vertica Eon Mode

Soniya Shah, Information Developer
May 17, 2018

This blog post was authored by Soniya Shah. This blog post is updated as of July 2018. With Eon mode, Vertica is a database that takes advantage of all elastic compute and scalable storage capabilities in the cloud. In Eon mode, Vertica can take advantage of cloud economics – it can be made to scale...
Programmer

Operational Considerations for Database Administrators in Eon Mode

Soniya Shah, Information Developer
March 6, 2018

This blog post was authored by Shrirang Kamat. The purpose of this document is to familiarize advanced Vertica Enterprise mode users about some of the behavioral similarities and differences between Vertica Enterprise mode and Vertica Eon mode. This document assumes you have a basic understanding about Eon mode architecture. You can find more details about...