Search code examples
javatomcat7scalabilitybusiness-intelligencespagobi

Scale UP SpagoBI application with Tomcat

I have SpagoBI 5.1 application running on tomcat on my server.

I would like to know how that can be Scaled UP Horizontally as well as Vertically ant at what extent.

So please guide.

Solution

  • These are paraphrased suggestions from Spago Support

    • Install DBMS in highly available mode

    • Create a single database for the SpagoBI Server metadata db

    • Setup a cluster environment for SpagoBI Servers.The cluster should have two or more nodes.Each SpagoBI Server will run a separate Tomcat, so no session data is shared.

    • Add a web server (such as Apache) as a load balancer, configuring Apache in the session affinity.That allows a user to login into a SpagoBI server and stay directed to that server in the cluster for the user's session.