I have a mysql server running. Due to the uptime is not perfect, sometimes the HTTP server is blocked when mysql server is down intermittently.
Host 'host_name' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
Currently, I have to set up a cron job to run "mysql-admin flush-hosts" to ensure my HTTP server can connect to database after the block.
My question is, how can I get certain IP (eg my HTTP Server) from being blocked by MySQL server ? Is it possible?