Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

ali_hijazi
Honored Contributor

Distributed installation of Qlikview services

Hello

we have 2 server machines BI1 and BI2

Bi1 is located at location X where IT department offices exist

Bi2 is located at location Y where end users offices exist

We have license for QlikView server with publisher and cluster for 2 machines

what is the best scenario of installing QlikView services so that on  BI1 the reloads and creation of QVD files occur

and end users browse to the access point on BI2 machine?

I was thinking of installing on BI1 the QlikView Server Service, Management Service, and Distribution service

so Tasks run and consume RAM of BI1 during the night and IT people (developers) use this machine for development

On BI2 we install QlikView WebServer Service

Access point and folders will be defined on BI2

the publisher will distribute QVW to BI2 to be accessed by users from BI2

is this fine?

Do we need to have a third server machine to benefit from cluster option?

Please advise

6 Replies
amit_saini
Honored Contributor III

Re: Distributed installation of Qlikview services

Hi Ali,

Best I would suggest :

Use " Bi1" as server having below services:

and use "Bi2" as an Publisher with "Distribution" service

I have dome something similar , but in my case I'm having 2 publishers. See below:

Thanks,
AS

ali_hijazi
Honored Contributor

Re: Distributed installation of Qlikview services

I want to host QVW on BI2 so that I benefit from all the available RAM for end users

reloads and publishing is carried by BI1

note server machines are in different locations (100 KM away premises)

Re: Distributed installation of Qlikview services

A few - maybe useful - remarks:

  • If you have a QlikView server and a Publisher licenses, they are always for both a single machine as well as for a dual machine installation. I do not entirely understand how the "Cluster" option features in your story. Do you have a clustered QVS and a clustered Publisher license? In that case you should use at least 4 machines for load distribution.
  • QVS is the service that is servicing documents to end-users. That's the one that eats memory like candy. The QVWS service doesn't do much except for displaying the AP landing page and tunnelling.
  • Where you host the QVWs (on disk) is not important; you can either put the files on B1, on B2 or on an external Windows file share. Performance-wise I would say, put them in a Windows share on the Publisher machine (publication is quicker). And let the QVS service load them across the network. But since your users seem to be 100km from the Publisher machine, you may want to put the share on the QVS machine so that the Publisher may take longer to update a particular QVW, but at least the refresh in memory by QVS will be quicker.
  • Put both QVWS and QVS on the same machine and closest to your end-users. Put the Publisher closest to your data sources.

You can still use Amit's suggested setup with this additional change: swap the installations = QVWS+QVS+QMS+DSC go on machine BI2, Publisher (optionally with QMS if you don't put that one on BI2) go to BI1.

Best,

Peter

ali_hijazi
Honored Contributor

Re: Distributed installation of Qlikview services

yes I have in the LEF

NUMBER_OF_CLUSTER_NODES;2

so you mean that QVW will go to the RAM of the machine having QlikView server service?

Re: Distributed installation of Qlikview services

If this is the LEF for QlikView server (Publisher has its own license and LEF), then it means that you can install two QVS on separate machines, and make them act like a single more powerful QVS. In total, you will have three Windows production machines: two to handle end-user requests (QVS1 and QVS2) and one to reload documents (Publisher)

"QVW will go to the RAM..." Indeed. Whenever an end-user requests access to a document in the AccessPoint, one of the QVS servers will load that document in RAM and send a first sheet to the end-user's browser. As long as that user keeps rummaging in that particular document, the QVW file will reamin loaded in RAM of that particular QVS.

But mind you: a Publisher machine also needs RAM to reload a particular document. For some documents, the required amount can be considerable. And a publisher will also need as many CPU cores as possible to execute a reload script. Those are the two main reasons why in an enterprise environment QVS and QDS services are almost always hosted on different machines.

Peter

ali_hijazi
Honored Contributor

Re: Distributed installation of Qlikview services

ok we got 3 powerful machines Bi1, Bi2, and Bi3 each with 1 Tera of RAM

Bi1 will be located at IT department premises

Bi2, and Bi3 will be located at the end users premises which is 100 KM away from IT department premises

so I understand from you that I go on with the following installation:

on Bi1 I install the

  • Management Service so that we have the management console application to give licenses to users create tasks on QVW that create QVD files (it is the IT department who is responsible for assigning licenses to users)
  • Distribution Service to distribute QVWs to Bi2

and I apply the publisher license to Bi1

on Bi2 I install the

  • Qlikview server service
  • QlikView web server service
  • QlikView management service (so that I configure the nodes of the cluster)

on Bi2 I apply the QVS license which has the Cluster enabled

on Bi3 I install the QVS (BI3 will be used for load balancing)

tell me if I'm wrong

Community Browser