Managing server groups

Contents[Hide]

1. Overview

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.

Click Add server group
Click Add server group

In the Add Server Group screen, type the name of your server group and then click Submit.

Type the name of your server group
Type the name of your server group

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.

New server group is listed
New server group is listed

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.

Edit a server
Edit a server

In the Registered Server Details screen, set the Server Group dropdown to the server group which you created earlier.

Select a server group
Select a server group

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.

Server Group Details screen shows list of servers in the group
Server Group Details screen shows list of servers in the 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.

Server Group configuration settings
Server Group configuration settings

If you want to customize the configuration settings per individual server, set the Setting Scope to Server, and then select your server.

5. Notes

  • 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.

6. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri