Skip to main content

K-Safety


Mohit_Anchlia
Forum|alt.badge.img+1
I just created a new vertica database and have not used database designer. By default what's the k-safety. And, with K-safety 1 how many copies are stored? I am assuming 2.

2 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • June 23, 2013
if you have 3 nodes by default is k-safe=1 and it will have 2 copy of the data. in the system table, select * from system;, there is a colum named desing fault tolerance and that indicate the k-safe that your database is. Hope this helps, Eugenia

Navin_C
Forum|alt.badge.img+2
  • Participating Frequently
  • June 24, 2013
If you have a 3nodes database cluster, which is the minimum required for K safety, then the K-safety value by defualt is 1. You can use increase your k safety to 2. If k safety 1 = 2 copies of each projection k safety 2 = 3 copies of each projection