Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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!

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.