Cluster traffic settings

In this section you configure

• the client-server traffic connection.
   

Client

Follow these procedures to configure these settings:

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

    

2. Click the Client tab.
   
    
    

3. Configure the fields as shown.

   ScaleArc provides default recommendations but strongly encourages you to keep in mind your application and database timeout settings and network latencies when you change these defaults.

   Field	Description	User input
   Idle Client Connection Time (seconds)	The time to wait before closing an idle connection by the client (web/application server/MySQL client). Tip If you use a client-side connection pool (Java/Apache connection pooling), set this value to more than the client connection pool timeout. Idle Client Connection Time should be larger than the Surge Queue Timeout in the server settings.	Default value 1200 seconds.
   Maximum Client Authentication Timeout (seconds)	The maximum time after which the client connection will be closed if ScaleArc does not receive the login request from the client.	Default value 10 seconds.
   Maximum Client Connection	The maximum number of client connections allowed for the cluster. The depth of the surge queue is also limited to this number.	Default value maximum is 60000

4. Click Apply All to submit your edits or click Load Defaults to reset to factory settings.

Server settings

1. Click the Server tab in the Cluster Settings dashboard to customize the server configuration.
   
   
    

2. Configure the fields as follows:

    

   Field	Description	Default/User input
   Server Connection Timeout (seconds)	The maximum time after which the server connection closes if ScaleArc fails to open the TCP connection with the server. Following a timeout, the corresponding client connection closes.	Default value is 5 seconds.
   Server Greeting Timeout (seconds)	If ScaleArc fails to open the database server connection because of 'Server Greeting Timeout', the server connection will be closed and a new server connection will be re-tried. After three such consecutive retries, the corresponding client connection will get en-queued into the surge (client connection wait) queue.	Default value is 5 seconds.
   Idle Server Connection Time (seconds)	The time to wait before closing an idle connection SQL Server. Preferably, set it to more than 120 seconds.	Default value is 300 seconds.
   Maximum Replication Lag (seconds)	The replication lag before a server is marked inactive in a cluster. If the lag is less than the time specified, fewer queries are loadbalanced to that server.	Default value is 30 seconds.
   Ignore Replication Lag for Load Balancing (seconds)	Send queries to the slave(s) even if they are lagging behind the principal sever. See Maximum Replication Lag.	Default is OFF. Turn ON.
   Health Check Attempts	The number of attempts to check the health of a DB server that should fail consecutively, after which it is marked down and taken out of load balancing.	The default is three attempts.
   Health Check Interval	The time between consecutive health attempts made to the database server, after which the health of the database server will be updated.	The default is 2 seconds.
   Surge Queue Timeouts (seconds)	The timeout value in the application or the connection pool configuration which determines the maximum length of time a connection can be held in the surge queue before returning an error message.	Default is 60 seconds.

    

    

3. Click Apply All to submit your edits or click Load Defaults to reset to factory settings.