Please increase max_connect_errors to 999999 by using 'set global max_connect_errors=999999' on the MySQL server

Release	Classification	Level	DB Platform	Categories
3.5+	Solution		MySQL	Troubleshooting

Error

Please increase max_connect_errors to 999999 by using 'set global max_connect_errors=999999' on the MySQL server.

Solution

This value should be equal to 999999 or more. If the value is lower than 999999, you will not able to create a cluster utilizing such a database server.

You can set this in mysql without restarting your mysql service:

[root@server ~] mysql -uroot -p

mysql> set global max_connections=999999;

mysql> set global max_connect_errors=999999;

You can set this in the MySQL configuration file so that the settings are not lost after service restarts.

[root@server ~]# vi /etc/my.cnf

[mysqld]

  :

 max_connections = 999999

 max_connect_errors = 999999

  :

Reference:

Why should we increase max_connect_error in MySQL DB 

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.