Database Designer configuration



I am having the following scenario:


1) 3 Vertica nodes in a one cluster (using one hostname with multiple IP's);

2) A multi-tenancy schema that uses where clauses using customer_id. Schema consist of 5 multi-tenancy administration tables and 3 fact tables.




1. Regarding 1) - This means I already have a high availability and failover system over my Vertica cluster?

2. I want to use Database Designer over the current scheme in the following way: All 5 multi-tenancy administration tables to be replicated on all 3 nodes and the 3 fact tables to be segmented and projected on the 3 nodes taking in consideration the K=1 configuration. Is this possible? And if it is could this be applied using the presented scheme with customer_id clause?


Thank you for your answers!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file