Managing server groups
Dundas BI supports multi-server deployment out-of-the-box for load balancing purposes. In this scenario, multiple servers have Dundas BI installed but each installation points to the same Dundas BI Application Database (App DB).
This article shows you how to manage multiple servers and server groups in Dundas BI. Server groups make it easy to apply Dundas BI configuration settings at the group-level or override settings on a per-server basis.
2. Add a server group
To create a new server group, first log on to Dundas BI as an administrator. Go to the main menu and click Admin.
In the Admin screen, expand the Setup section and click Server Groups.
In the Server Groups screen, click Add server group.
In the Add Server Group screen, type the name of your server group and then click Submit.
Returning to the Server Groups screen, you'll see that the new server group appears in the list. You can edit or delete the group from this screen as well.
3. Register servers
Go back to the Admin screen and click Servers under the Setup section.
In the Registered Servers screen, you'll see a list of existing registered DBI servers. Click the Edit button to modify a server.
In the Registered Server Details screen, set the Server Group dropdown to the server group which you created earlier.
Register additional servers as needed from the Registered Servers screen.
Go back to the Server Groups screen. Edit the server group to see the list of servers in this group.
4. Modify configuration settings
In the Admin screen, click Config under the Setup section.
Set the Setting Scope to Server group, and then select the Server Group. You can now modify configuration settings which will apply to the server group as a whole.
If you want to customize the configuration settings per individual server, set the Setting Scope to Server, and then select your server.
- DBI licensing is tied to a specific Dundas BI instance which refers to everything that uses the same Dundas BI Application Database (App DB). If multiple servers are all referencing the same App DB, then additional licenses are generally not required when you add another such server.
- For load balancing setup, you typically need to install Dundas BI on each server, but have each installation pointing to the same App DB. You can do this by installing on one server normally using the Create new application database option. Then install DBI on the remaining servers using the Use existing application database option. Additionally, you must ensure the Dundas BI Scheduler Service is running on only one server and disabled on the rest. It is also required to set up session affinity (a.k.a. sticky sessions) on your load balancer.