How do you determine what K-Safe is set to on a database - and what command do you issue to set a K-

Steve_Angell

New to vertica - i need to check the current K-Safety setting on the database and I would like to know also how to set or change this The database I am looking at ids V4 (I Know its back level)

[Deleted User]

Hi Steve,

To check system k-safety:

vsql=> select DESIGNED_FAULT_TOLERANCE, CURRENT_FAULT_TOLERANCE from system;

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.


To change k-safety value:

VSQL=> SELECT MARK_DESIGN_KSAFE ( k )

 

Where k

 

2 enables high availability if the schema design meets requirements for K-Safety=2

1 enables high availability if the schema design meets requirements for K-Safety=1

0 disables high availability

You can read more about this in Vertica Documentation:

SQL Reference Manual --> SQL Functions --> Vertica Functions --> Catalog Management Functions --> MARK_DESIGN_K_SAFE.



Thanks,
Pravesh