The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to expand k-safe / fault tolerance from 0 to 1, i have expand vertica db from 1 to 3 nodes ?

Bilal_razaBilal_raza Community Edition User

I have expand vertica db from 1 to 3 nodes, but my k-safe / current_fault_tolarence is 0, how could i set k-safe from 0 to 1.
kindly guide me


  • Bryan_HBryan_H Vertica Employee Administrator

    On an EE mode database, you'll need to create buddy projections to increase k-safety. The easiest way to do this is to run DataBase Designer (DBD) in admintools or Management Console to build a design with K-safety 1. K-safety will be increased when the new design DDL is deployed.

  • moshegmosheg Vertica Employee Administrator
    edited July 2022

    In addition, after you expand K-safe from 0 to 1 and before nodes are taken down,
    Please consider to verify that your DB configured as K-safe = 1, and all projections have a buddy projection.
    Select * from system; --> Check the current_fault_tolerance of the DB.

    If your cluster is configured with KSAFE=0 consider to use DBD in admintools like Bryan already suggested,
    The above API will create the required buddies, refresh them, rebalance if necessary
    and will also mark the cluster to K-SAFE 1 (from 0).
    Please note that this can take time and consume more disk space to create all buddies.
    BTW, dbd_add_nodes_rebalance_data is not needed in Eon mode.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file