Determining the Current K-Safety

Jim_KnicelyJim_Knicely Administrator
edited January 2019 in Tips from the Team

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.