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?

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.