We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Database Designer configuration — Vertica Forum

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