High Availability in an EON Mode Database with Read-Only Mode
Amrita Akshay, Information Developer
January 9, 2023
This blog is authored by Sruthi Anumula In Eon Mode, there are two major requirements for high availability: maintaining quorum and shard coverage. If either of them is lost, the whole cluster goes down. Before going into details, let us understand what quorum and shard coverage mean. Quorum: In Eon Mode, more than half of...
How to Quickly Install Vertica on Large Clusters
Amrita Akshay, Information Developer
December 19, 2022
This quick tip was provided by Sruthi Anumula. Vertica 12.0.2 introduces a new feature that allows you to install Vertica in parallel on all hosts rather than one at a time as in earlier releases. This reduces the installation time in large clusters. To use this feature, run the --parallel-no-prompts flag with the install_vertica command....
Improving COUNT DISTINCT Performance with Approximate Functions
Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 16, 2022
A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...
How to run Vertica CE in Windows 10 using Docker
Alexandr Skorobogatov
September 14, 2021
Sometimes we want to test a new version of Vertica. In the past, the best way to do that was to use a Vertica Community Edition (CE) virtual machine. But starting with Vertica version 10.1, there is an easier way to achieve this. There is an official Docker image for the latest Vertica CE version...