Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Highlighted
Partner
Partner

How to verify load balancing

Hey guys,

I have setup 1 central node and 3 rim nodes using qlik sense june 2017 edition.

Under virtual proxies > node > load balancing, I have added all 4 nodes to each of the nodes (see photo below)


125b7ae2-fbe2-4702-aa4c-52351221c61f.jpg

fba8630a-3413-44d3-a839-f20bbf76660d.jpg

Now I assume activity in Qlik will be load balance across all 4 nodes (I did not configure load balancing rules)

However when I go to operations monitoring and did a manual reload, looking at the following photo,

a1d18e98-f163-4580-a7b5-93116e80d1c5.jpg

we can see that VSRPRDAPP11 (central node) and VSRPRDAPP12 (rim 1) are clearly not in used.

VSRPRDAPP14 (rim 3) is also too heavily in used while VSRPRDAPP13 (rim 2) is used rarely.

Is operations monitor the correct method to verify that load balancing is indeed working?

And if so, the results seems to indicate load balancing is not working as per intended.

10 Replies

Re: How to verify load balancing

Hi, I'm not sure how the default balancing (no balancing rules) works, just a few comments:

Nodes are assigned to sessions, if you open different apps in the same session all will go to the same node.

There is another monitoring app called Sessions monitor wich can show wich node has opened each app, you can import that app from %ProgramData%\Qlik\Sense\Repository\DefaultApps\

You can try setting load balancing rules to confirm central node can redirect sessions to each node. Also note that central node has a default rule to access everything, so maybe you need to remove central node from virtual proxy balance nodes to force some app to open on RIM nodes.

Partner
Partner

Re: How to verify load balancing

Appreciate your reply Ruben!

We have previously imported sessions monitor and been reloading via task on a daily basis.

Nevertheless, I perform a manual reload on it and discover something astonishing.

c4bfd4fa-65ef-42ac-ab42-9459a94c1e21.jpg

[Sessions Monitor last reload date]

 

b2389eca-853d-48fc-aa87-9332db9ab32b.jpg

[Sessions Monitor Session Details]

It looks like the last session date is 2018-06-07 which is impossible!

I went ahead to open session details on operations monitor.

d4af53e6-65a0-42ad-b9ed-f99146a2a0d9.jpg

[Operations Monitor Session Details]

It looks like operations monitor last session is correct but not the session details from Sessions Monitor.

With regard to the default load balancing rules, our central node is already redirecting sessions to each node but as per topic, it seems to be heavily sending sessions to VSRPRDAPP13 and neglecting itself, VSRPRDAPP12 and VSRPRDAPP14.

Hmm just to confirm, is my setup correct by assigning all nodes to each virtual proxy -> load balancing?

I does feel is correct because 2 of the servers has firewall (forgot to close) and we had customers complaining sometimes they can perform data reload (so happen they are load balance to VSRPRDAPP11 and VSRPRDAPP12) and sometimes they cannot (load balance to VSRPRDAPP13 and VSRPRDADD14).

Re: How to verify load balancing

Hi Bryan, assigning all nodes to each virtual proxy should work and the central node is used, I've only configured a few multinode sites but from what I see the central node was the one heavily used while testing, I have to remove it from the balancing nodes to check redirection to other nodes, so my experience is opposite than yours with central node.
About sessions app data, have you configured the additional steps to allow accesing shared data (instead of the default 'localhost' data):
https://help.qlik.com/en-US/sense/November2018/Subsystems/Monitoring/Content/Sense_Monitoring/Introd...
OguzcanA
New Contributor

Re: How to verify load balancing

Hello Bryan,

You can try to open some random apps from reaching to your proxy which is running in centralnode ie. https://<QlikCentralNodeHostname>/hub 

Then in your RIM Nodes run taskmgr.exe and go to details tab to check CPU/RAM usage of Engine.exe.

If Engine.exe rises up in RIM nodes as you open apps ,your deployments seems ok.

You can temporarily stop QlikSense Engine service in your central node to forcing qliksense loadbalance to your rim nodes. If your setup is correct you should be able to open apps via reaching https://<QlikCentralNodeHostname>/hub while engine service is down on your central.

 

Partner
Partner

Re: How to verify load balancing

Hmm, I would check this "localhost" configuration when I'm back on site, thanks!

Partner
Partner

Re: How to verify load balancing

Thanks for the reply OguzancA!

Hmm, the processing are probably load balance to the nodes since VSRPRDAPP14 (Rim 3) is heavily loaded at 69% while VSRPRDAPP13 (Rim 2) at 2%.

I'm kind of curious why operations monitor report it that way if load balancing is configured and working correctly.

Do you guys have a somewhat distributed load across all rim nodes? like 23%, 27%, 26%, 24% across 4 nodes

daiana_rossignol
New Contributor III

Re: How to verify load balancing

Hi! did you solve this?

Partner
Partner

Re: How to verify load balancing

sadly no, we are still trying various ways to see what can be done

hjampani2019
New Contributor

Re: How to verify load balancing

Bryan,

I am interested to know/learn about the updates on this communication.  Can you share me your findings?

Thanks

Hari