Recommendations for Creating BI Servers Cluster

Below is a list of basic recommendations that can be used on creating a BI servers cluster:

Any available balancer can be used if it meets the following requirement: the balancer must provide linking queries of certain client to the certain server.
As a state server, Foresight Analytics Platform supports work with Redis and Memcached.
Number of BI Servers. The number of BI servers started within the same operating system depends on the number of simultaneously working users, the number of queries handled in parallel and data volume. The number of BI servers is calculated individually for each application system based on load testing results. For initial assessment send an email to support@fsight.ru or via technical support services that are available after registration at the website.
Number of Operating Systems that Run BI Servers. Determining the number of operating systems depends on the number of BI servers, the number of simultaneously working users and the number of queries handled in parallel. The number of operating systems, in which BI servers are started, is calculated individually for each application system based on load testing results. For initial assessment send an email to support@fsight.ru or via technical support services that are available after registration at the website.

Recommendations for the number of BI servers and operating systems can be applied if the response time is short (1-4 seconds). If the developed web application shows long response time and suffers from the lack of CPU time, the number of working users will not have much influence and can be increased.

Resulting characteristics of the cluster are also influenced by such factors, as intended load, intended peak load or increasing fault tolerance requirements. The number of started BI servers or OS should not be unreasonably increased because it may cause loss of performance due to excessive resource usage to deploy cache, memory used by processes related to OS, and so on.