|Parameter Location||CLUSTER -> SCALEARC -> Query Level Sticky Query|
|Modifiable without restarting cluster||YES|
This parameter comes in the picture once you enable the Query Level Load Balancing.
In connection level load-balancing (QLLB OFF), ScaleArc sticks to Write (RW Server) for the entire lifetime of the connection.
In the case of Query Level Load Balancing (QLLB ON), ScaleArc tries to load balance the traffic on every query. While doing this, in order to maintain the integrity of the data post DML queries, ScaleArc sends few subsequent read queries to the same RW server. The number of such read queries that should be forwarded to the same RW Server is defined by the parameter "Query Level Sticky Query".
The default is 1 query.
If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support. We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315.
For general support inquiries, you can also e-mail us at firstname.lastname@example.org.
2901 Tasman Drive Santa Clara, CA 95054 | Email: email@example.com