KB 2058 - Maximum client connections available for this cluster are

User gets the following error message while trying to change the maximum number of client connections available for a cluster.

Setting a value higher than the number of maximum number of client connections available for a cluster will return an error. Please set another value for maximum client connections for a cluster and try the operation again. 

The Max connections for MSSQL is 32000

To check the max connections on mysql you and run the below query on MySQL

show varibles like "max_connections";

This will return a result like this:

+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 100   |
+-----------------+-------+

You can increase the max connections in mysql at run time by running the below command

set global max_connections = <connecitonnumber>;

To persist the configuration change make the below change to the /etc/my.cnf file on the mysql database server

max_connections = 200

If you are experiencing issues with ScaleArc or with any of its features, please contact ScaleArc Support.

We are available 24x7 by phone at +1 972-588-4221.  For general support inquiries, you can also e-mail us at scalearc-support@devgraph.com.