Functional Spec: Stick Connection For Read Queries [Sticky Reads]
|v3.6.1 or above||Parameter||MySQL & MSSQL||Cluster Settings|
|Parameter Location||SCALEARC UI -> CLUSTER -> Cluster Settings -> SCALEARC|
|Value Range (if numeric)||0 - UNLIMITED|
|Modifiable without restarting cluster||YES|
Please refer to following KB to understand how ScaleArc performs Read + Write Split within a single client connection.
This feature gives control to dissociate a client connection from Read+Write server and achieve query load balancing within a single client connection
This parameter defines how many read queries are sent to Read+Write server following a write query. In other words, ScaleArc becomes able to send read queries to Read Only server after the count of read queries reach to this number within a single client connection.
QLLB must be ON in order to achieve QLLB within a single client connection.
When there is a need to load balance read queries within a single client connection, it is advisable to change its value from the default of 0 since ScaleArc won't dissociate a client connection from the Read+Write server if this value is set to 0.
NOTE: Write queries will always be sent to R+W server
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.