The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

how many random maximum nodes can go down but database cluster continues to alive without any issue?

In a 100 node cluster with K Safe value of 2, how many random maximum nodes can go down but database cluster continues to alive without any issue?

Answers

  • moshegmosheg Employee
    edited November 17

    It depends..
    K-safe 2 ensures that Vertica will run normally if any 2 nodes fail.
    Potentially, with K-safe 1 or K-safe 2, up to half the nodes -1 in the DB could fail, without causing the DB to shut down, as long as the data on each failed node is available from another active node.
    Because of the extra space and I/O required for each copy in K-safe 2 configuration,
    It is advised to use K-safety of 1 and define fault groups to reduce the risk of failures when two or more nodes fail.
    One can also use fault groups to make Vertica be rack aware.
    For more info about High Availability and Data Safety see: https://www.vertica.com/kb/KSafetyBestPractices/Content/BestPractices/KSafetyBestPractices.htm

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.