Database Designer configuration
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!