Access and Mserve

Community Support
1

Hello,

I have an access point and a load balancer with mserve.q loaded.  I have clients connecting to the access point and calling functions that send deferred sync messages to the load balancer which in turn finds least busy slave and returns the data.  The problem is that the deferred sync messages still block the access point so clients are experiencing slowed queries when waiting for the deferred sync queries to finish. 

Is there a better architecture I can setup?  Or someway to use asynchronous calls so that clients don’t have to wait?   

Thanks

2

To: Roni Hoffman , Kdb+ Personal Developers

Yes, there are two built in to kdb+

Negative port mode (multi threaded input queue)

Negative slaves mode (basically a built in load balancer)

The second requires async messages from clients and the first has some significant limitations on the types of queries that can run (but is generally quite workable)

The wiki has good examples of both


From: Roni Hoffman

Sent: Friday, February 12, 2016 15:06
To: Kdb+ Personal Developers
Reply To: personal-kdbplus@googlegroups.com
Subject: [personal kdb+] Access and Mserve

Hello,

I have an access point and a load balancer with mserve.q loaded. I have clients connecting to the access point and calling functions that send deferred sync messages to the load balancer which in turn finds least busy slave and returns the data. The problem is that the deferred sync messages still block the access point so clients are experiencing slowed queries when waiting for the deferred sync queries to finish.

Is there a better architecture I can setup? Or someway to use asynchronous calls so that clients don't have to wait?

Thanks

--

Submitted via Google Groups

3

I see, Thank you David I will take a look.

Roni Hoffman
1-519-859-1082