Determining the Current K-Safety: Quick Tip

Posted January 15, 2019 by Jim Knicely, Big Data Solutions Architect, Vertica

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/latest/HTML/Content/Authoring/ConceptsGuide/Components/K-Safety.htm

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

Have fun!