Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Load balancing qvp://, is that possible

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?

Tags (4)
1 Solution

Accepted Solutions
Employee
Employee

Re: Load balancing qvp://, is that possible

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

11 Replies
whiteline
Honored Contributor II

Re: Load balancing qvp://, is that possible

Hi.

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

Round-robin DNS

Re: Load balancing qvp://, is that possible

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
Valued Contributor II

Re: Load balancing qvp://, is that possible

Hi Svante

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

Not applicable

Re: Load balancing qvp://, is that possible

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
Valued Contributor II

Re: Load balancing qvp://, is that possible

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

Re: Load balancing qvp://, is that possible

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

Peter

Employee
Employee

Re: Load balancing qvp://, is that possible

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

Not applicable

Re: Load balancing qvp://, is that possible

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

Re: Load balancing qvp://, is that possible

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

Community Browser