Routing Queries in ElastiCube Sets
  • 29 Mar 2022
  • 1 Minute to read
  • Dark
    Light

Routing Queries in ElastiCube Sets

  • Dark
    Light

When a user queries an ElastiCube that is part of an ElastiCube Set, Sisense routes the query to a single ElastiCube with the latest ElastiCube build. By default, ElastiCube Sets operate in active-passive mode. In active-passive mode, one ElastiCube , by default the ElastiCube with the latest build, handles incoming queries. This ElastiCube is active while the remaining ElastiCube s are on standby in passive mode.

Sisense also supports active-active mode where queries are spread across available ElastiCube s within an ElastiCube Set. In active-active mode, each ElastiCube that is not currently building can handle queries.

You can modify how queries are routed to ElastiCube s within ElastiCube Sets by selecting one of the following routing strategies:

Single : (Default). ElastiCubes operate in active-passive mode where the ElastiCube with the freshest data receives all the queries while the remaining ElastiCubes are on standby.

Multiple ElastiCubes – Fresh Data : ElastiCubes operate in active-active mode where queries are spread across all ElastiCubes with the latest data.

Multiple ElastiCubes – Best Spread : ElastiCubes operate in active-active mode where queries are spread across the largest group of ElastiCubes with identical data.

To set a query routing strategy:

  1. Click Admin and select the Data Sources tab on the left.

  2. For the relevant ElastiCube Set, select Edit.

    8-5v7seteditthumb0300.png

  3. From the Routing Strategy list, select the relevant strategy.

  4. Click Save.


Was this article helpful?