search cancel

How do you check what ksafety level the Vertica Data Repository database is in and how many node failures it can tolerate before the database shuts down?  

book

Article ID: 201024

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

How do you check what ksafety level the Vertica Data Repository database is in and how many node failures it can tolerate before the database shuts down?  

Environment

Release : 3.7.x, 20.2.x

Resolution

You can utilize the following sql call run as the database administrator account (default = dradmin)

dradmin=> select DESIGNED_FAULT_TOLERANCE, CURRENT_FAULT_TOLERANCE from system;

DESIGNED_FAULT_TOLERANCE | CURRENT_FAULT_TOLERANCE
-------------------------+-------------------------
1                        |1
(1 row)

Where:

DESIGNED_FAULT_TOLERANCE = The designed or intended K-Safety level.

CURRENT_FAULT_TOLERANCE = The number of node failures the cluster can tolerate before it shuts down automatically.