Vertica offers native automatic high availability through a unique real-time mechanism ensuring the system will continue to load and analyze data even if there are hardware failures in the cluster. We also offer the ability to store the redundant data in different sort orders to deliver the same advantage a secondary index would, without the overhead and hassle of an index.
A key attribute of the Vertica Analytics Platform is native high availability; a Vertica cluster can withstand a hardware failure with no material impact on the overall operation of the system. In the event of a hardware failure, Vertica administrators can simply pull the server from the cluster, repair the hardware, re-establish network connectivity, and re-insert the node into the cluster using Vertica’s Administration Tools. Vertica will then automatically handle the rest by restoring it in the background from the other nodes automatically. It is that simple.