Configuring Cluster Settings - ScaleArc

The Cluster Settings screen is divided into 9 sections/tabs which are: CLUSTER, CLIENT, SERVER, ScaleArc, CACHE, AUTO FAILOVER, SSL, Advanced Settings, and DEBUG.

This article explains the configuration settings under the ScaleArc tab which provides various settings to modify or enhance cluster-specific settings of the ScaleArc appliance.

Follow these steps to configure the various cluster settings under the ScaleArc tab:

  1. On the ScaleArc dashboard, locate the Status column and click Cluster Settings
    Cluster_Settings_button.png

  2. Click on the ScaleArc tab on the Cluster Settings control panel.

    ScaleArc_settings.png

  3. Reference the below table to configure the ScaleArc settings:

    Field Description Default/User input
    Write Ignore

    When ON, ScaleArc excludes certain MySQL Server protocol commands and queries, which do not change the data, by specifying these using the Set Rules section. This helps load balance queries to Read-only replicas when a connection-pooled application behavior (certain SET commands or non-standard commands) causes the Read/Write split feature to favor principal servers most of the time. See the KB article for more details.

    Connection pooled apps like Java/Ruby on Rails require you to set Write ignore and Set ignore rules to achieve a Read/Write split during query-level load balancing. Adding a set option like "SET names utf8" informs ScaleArc to send the Set rules to a Read server. Consider putting the same SET rules into SET replay as well to retain connection-level fidelity. If you have two applications -- one connection pooled and the other non-connection pooled -- use two different ScaleArc clusters to optimize the different advanced settings for performance.

    Turn ON/OFF
    Set Commands

    MySQL commands configured as write ignore commands.

    See the KB article for more details.
    Set Rules

    Excludes certain MySQL queries from being detected as write queries. 

    See the KB article for more details.
    Set Replay

    Specifies a SQL command or statement which gets executed on every new connection that ScaleArc uses after switching the connection from one database server to another. The switch can occur for the following reasons: query routing, Read/Write split, query level load balancing, switchover, mark server offline, or a new client connection.

    See the KB article for more details.
    Authentication Salt Reuse

    Enables the capability to reuse authentication salt during the authentication offload to improve performance.  This setting can improve performance for a PHP-like application where connection pooling is not done at the app layer and there are lots of SQL connections being created and destroyed every second.

    Turn ON/OFF
    Maximum Query Logging Length

    Maximum numbers of characters from a query to be logged in the query log file.

    Default value is 2000
    Query Based Connection Unstick

    Enable/disable query-based connection unstick. This only resets stickiness caused by the SET query.

    The default setting is OFF
    Unstick Commands Enabled commands are matched against API-generated commands in the connection. If matched, the connections unstick from the existing server connection. See below.
    Unstick Query Query patterns provided here are matched against queries sent by the application. If matched, connections unstick from the existing server connection. See below.
    Counter Module Status Control the counter infrastructure feature which is used to gather statistics and counters of various ScaleArc states and resources at run time.  The default setting is ON.
    Counter Update Interval (seconds)

    The counter statistics are collected from the core engine at a specified interval. 

    Default value is 5 seconds. 

     

  4. Click APPLY ALL to save the configuration changes or click LOAD DEFAULTS to reset the configuration to the default values.

Unstick Commands

This feature resets stickiness caused by non-ScaleArc supported SET queries.

Refer to this KB article for the complete List of Recordable Sets for SET Replay.

  1. Click Unstick Commands.
  2. Select the commands that you wish to match against the commands in the connection. If matched, the connections unstick from the existing server connection. 

    Unstick_Commands_MySQL.png 

Unstick Query

This feature resets stickiness caused by non-ScaleArc supported SET queries. This KB article provides a list of supported sets.

  1. Click Unstick Query.
  2. Add the query patterns that you wish to match against each query. If matched, connections unstick from the existing server connection. 

    Unstick_Query_MySQL.png

Back to top

Comments

0 comments

Please sign in to leave a comment.