Functional Spec: Query Level Load Balance [QLLB]
|v3.6.1 or above||Parameter||MySQL & MSSQL||Cluster Settings|
|Parameter Location||SCALEARC UI -> CLUSTER -> Cluster Settings -> SCALEARC|
|Modifiable without restarting cluster||YES|
This setting is used to achieve query load balancing on a single server connection.
ScaleArc becomes able to dissociate a client connection from existing R+W server when the number of read queries following a write query reaches the value set in Stick Connection for Read Queries. Subsequently, ScaleArc is abe to re-associate the client connection with Read Only server.
NOTE: Write queries are always sent to R+W server
It is advisable to turn this ON and change Stick Connection for Read Queries if and only if there is a need to load balance Read queries in a single client connection, for example, your applications use connection pooling feature.
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.