Routing Queries in ElastiCube Sets
Applicable to Sisense on Linux and Microsoft Windows
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 ElastiCubes are on standby in passive mode.
Sisense also supports active-active mode where queries are spread across available ElastiCubes 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 ElastiCubes 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:
- Click Admin and select the Data Sources tab on the left.
- For the relevant ElastiCube Set, select Edit.
- From the Routing Strategy list, select the relevant strategy.
- Click Save.