How do you determine what K-Safe is set to on a database - and what command do you issue to set a K-
+1New 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)
+2Hi Steve,
To check system k-safety:
vsql=> select DESIGNED_FAULT_TOLERANCE, CURRENT_FAULT_TOLERANCE from system;
Where:
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
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:
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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
