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.
© 2021 - DevGraph | An integrated suite of software development tools from DevFactory FZ LLC, an ESW Capital Group Company | Contact Support 401 Congress Avenue, Austin, TX 78701 | Email: scalearc-support@devgraph.com |
Comments
0 comments
Please sign in to leave a comment.