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

Terrace routing on Vertica EON

Hi Team,

1) Will Terrace routing work same as its in EON also.
2) since EON separated compute and storage, how terrace routing to going to help us in performance
3) If we impletented Terrace Routing , the same architecture we will be carrying while implementing to EON?
4) if we implemented EON do we need to additional implement Terrace routing?
Please respond as soon as possible

Amit

Comments

  • Ben_VandiverBen_Vandiver Employee
    edited April 2018

    Terrace routing is not directly affected by Eon mode. Eon is about storage and it leaves the execution engine relatively untouched. Terrace routing is an execution engine only optimization for reducing the number of network flows.

    More interesting is the interaction between Eon's Elastic Throughput Scaling (ETS) and Terrace Routing (TR). ETS and TR both make use of Fault Groups. ETS kicks in when each fault group has more nodes than database shards, allowing a query to be served entirely within a fault group. By contrast, TR only applies when there are nodes in multiple fault groups participating in the same query.

    In short, depending on how you deploy Eon, Terrace routing may or may not be relevant. If it is relevant (large node count and shard count), then Terrace routing will work the way you have historically seen it work.

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.