So I’m not too far from going live with my app, and I am wondering what new issues will come along as suddenly I have lots of people using it.
I’d love to collect the feedback of those who have worked in a PHP/MySQL environment before for us all to learn from!
Best wishes,
Antony.
max_connect_errors
So I have already come across the max_connect_errors issue, where MySQL shuts down connections to the database when more than a certain number of erroneous connection attempts have been made.
This requires you to run the mysql> FLUSH HOSTS; command to clear the connect error count if you are happy you are not being attacked.
Have you experienced this, and what are your thoughts about a good value to set the max_connect_errors variable to?
This should normally not happen unless you have a lot of simultaneous requests. The database connections are being closed as soon the request ends.