topic Re: Sense cluster: how to force scheduler to use a specific engine ? in Management & Governance

Sense cluster: how to force scheduler to use a specific engine ?

dvasseur — Thu, 11 Jan 2018 10:41:37 GMT

Hi,

I've the following environment:

Server A: Central
Server B: Scheduler + Engine (and Oracle drivers installed)
Server C: Engine (no Oracle driver installed)

When launching a reload, if the Engine on server B is used, the reload is OK (SQL queries executed because the Oracle driver is installed), but sometimes the reload fails because B is using the Engine on C, which doesn't have the proper Oracle drivers installed.

=> Question: How can I force the scheduler to use the Engine on the same server (server B here) ? Probably some kind of load balancing security rule, but which one ??

Thanks !

Re: Sense cluster: how to force scheduler to use a specific engine ?

awhitfield — Thu, 11 Jan 2018 15:10:19 GMT

The attached link give some useful pointers:

https://ptarmiganlabs.com/blog/2017/02/05/setting-priority-reloads-qlik-sense/

Re: Sense cluster: how to force scheduler to use a specific engine ?

dvasseur — Thu, 11 Jan 2018 15:55:24 GMT

Thanks but are these load balancing rules used for the reload / the navigation or both ? I think it's for both but I cannot find a way to specify the context.

Re: Sense cluster: how to force scheduler to use a specific engine ?

Levi_Turner — Fri, 26 Jan 2018 00:47:41 GMT

Load Balancing / Sync rules scope to Engines. Engines can do either/both delivery of front end applications or reloads. So both.

Do note that reloads in the Hub do not get routed to the Scheduler nodes for reloads. So in this scenario you would not be able to reload from the Hub.