Database Designer configuration

Dragosss

Hello,

 

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.

 

Questions:

 

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!