Forum Discussion
DataSource.Error: MySQL: Host is blocked because of many connection errors
Hi!
I asked the sys admins to increase the MySQL server connection threshold, so didn't have any problems ever since.
Make sure you have plenty of RAM and a powerful CPU on the server that has Enterprise gateway running. After I monitored resource usage, it was apparent that it was struggling with RAM, so that could be an option you could check.
Hi,
Thanks for the prompt response!
Ah right. I have Enterprice Gateway running on a virtual machine sat on our main server, the virtual machine has 8GB RAM (showing 6GB available) and is always online.
Just to check, I need the enterprise gateway to connect to:
* hosted MySQL on VPS (data pulled from multiple CRM sources)
* on-premise SQL (Sage 200 Manufacturing)
Like I say, I can connect to both sources no issues, just getting the refresh online connecting through the web seems to be the issue.
Help appreciated in advance
So what error message, exactly, are you receiving?
Ok doki, just took a screenshot below:
In this case as previously posted in the thread, you should ask your admins to run the mysqladmin flush-hosts command from the MySQL administration shell. If the problem persists you can try asking them to increase the max_connect_errors variable for that MySQL instance.
I'm kind of repeating what Eric_Zhang already said, but hopefully this is clearer.