Scale UP SpagoBI application with Tomcat

Question

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.

Interesting question. The answer would be helpful to me as well. So, I'll ask SpagoBI paid support and share the answer. — dbh, Sep 11 '16 at 15:59

score 1 · Accepted Answer · answered Sep 16 '16 at 05:30

1

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.

answered Sep 16 '16 at 05:30

dbh

can you explain how can I work with point 4 i.e Apache for load balancer – Mr x Sep 17 '16 at 14:11
I suggest looking into Apache web server's mod_proxy_balancer . Documentation at https://httpd.apache.org/docs/2.4/mod/mod_proxy_balancer.html – dbh Sep 18 '16 at 03:58

1 Answers1