Determining the Current K-Safety

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
edited January 15 in Vertica Tips

K-safety sets the fault tolerance in your Vertica database cluster. The value K represents the number of times the data in the database cluster is replicated. These replicas allow other nodes to take over query processing for any failed nodes.

You can view the current K-Safety of a Vertica database in several ways.

Example:

dbadmin=> SELECT get_design_ksafe();
get_design_ksafe
------------------
                1
(1 row)

dbadmin=> SELECT current_fault_tolerance FROM system;
current_fault_tolerance
-------------------------
                       1
(1 row)

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConceptsGuide/Components/K-Safety.htm

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/SYSTEM.htm

Have fun!

Sign In or Register to comment.