#1 2017-07-18 12:37:52

Achilie
Member
From: Hamburg, Deutschland
Registered: 2017-01-24
Website

ReportServer-Cluster

Hi,

is it possible to share one internal RS-Database with two or more ReportServer instances?
This would be a RS-Cluster.


Best Regards
Joachim

Offline

#2 2017-07-18 12:47:05

eduardo
Administrator
Registered: 2016-11-01
Website

Re: ReportServer-Cluster

Hi Joachim,

I am afraid that ReportServer at this time is not clusterable out of the box. Let me try to explain: If you do a basic cluster setup with sticky sessions for load balancing then most of ReportServer will simply work. There are, however, a few caveats: for once, ReportServer runs a few maintenance threads that are currently not synchronized via multiple nodes. This, in particular, includes the scheduler which would need to be configured to only run on a single node, that is, the scheduler needs to be disabled on every node but one. The second, and more severe, problem concerns scripted and CSV datasources. ReportServer loads these into a database cache which is currently also not synchronized via multiple nodes. Thus, accessing data from either a script or a CSV datasource might currently fail in a clustered setup.

In case you do not plan on using script or csv datasources you should be fine running ReportServer in a clustered environment, given that you properly handle the scheduler. (I have to add, that we are not running ReportServer in a cluster environment at this time for any of our clients, so these findings are based only on limited tests.)

I created the ticket RS-2735 and we will take a look if this is possible for 3.1: to make reportserver clusterable out-of-the-box.

Best regards,
Eduardo

Offline

#3 2019-05-09 07:01:36

Patryx
Member
Registered: 2019-03-25

Re: ReportServer-Cluster

Hi Eduardo again smile
How is going with resolving RS-2735? Is nowadays RS clusterable?

Offline

#4 2019-05-09 09:46:30

eduardo
Administrator
Registered: 2016-11-01
Website

Re: ReportServer-Cluster

Hi Patryx,

this is not currently possible out-of-the-box. We will update here when this happens.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB