Load balancing qvp://, is that possible

[#1]

So, vi have 3 QVS behind a load balancer. When going via LB address (https://load-balancer/qlikview) everything works just fine, the 3 servers have equally load.

Then we have some (quite a few) users that like QV Desktop, using qvp://. They have to go directly to one of our servers.

Now, is there a way to load balance that protocol as well?

I've heard it's not working, is that true?

[whiteline]

Hi.

It's not a very nice solution, but you can always try something like this:

Round-robin DNS

[Peter_Cammaert]

I guess so, but not through QlikView.

In a regular setup like your current one, it is the AccessPoint web server that load balances requests to multiple QlikView servers. QVWS has this feature built-in.

However, when you use a desktop client with a qvp URL, you are directing your desktop client straight to a specific QVS, and gone is your load balancing opportunity.

However, there is a lower level-solution to this called Network Load Balancing. It's not software based, but utilizes a specific load-balancing network router. For some minimal specifics, consult the QlikView Server Reference Manual Chapter 17.

Good luck,

Peter

[jerrysvensson]

Hi Svante

Are running your QVS machine in one clustersetup or are they single machines?

[#5]

Hi all... thanks for input.

missed some info.

The 3 servers are in a cluster and all of them have QVS, QSS (qv settings service), running IIS.

So, first there is a seperate LB (hardware) that redirects traffic to the 3 IIS.

And:

Is it possible to 'Open In Server...' and lease license when you go via a LB instead of direct to a server?

[jerrysvensson]

What happens if you do qvp://<clustername>  ?

[Peter_Cammaert]

Maybe it's as simple as configuring the LB hardware to loadbalance sessions on port 4747 as well?

Peter

[Bill_Britt · Accepted solution]

Hi,

I would setup the accesspoint in the Desktop version so connect there first and when they click on the document it should work.

Bill

[#9]

Got mail from Qlik and this is not something they support, but here's how it could be done.

""QV.exe is not able to use load balancing unless you use the Settings\User Preferences\Locations tab to configure the AccessPoint URL and then use the Tools\Open AccessPoint option there, then it can load balance, but what is going on in the backend is the AccessPoint pages are actually handling the load balancing at that point, whereas File\Open in Server is a direct QVP URL call to QVServer, and bypasses the web server/AccessPoint completely. "

[Peter_Cammaert]

So, back to configuring your Load Balancing Network Hardware?

Would it be possible to configure load balancing for port 4747 in your current hardware? Then you can use Jerry Svensson's URL in Open-In-Server.

Best,

Peter