Mysql server down by connection flood attack
godam64 - December 2, 2007 - 12:46
how to prevent mysql database server down with status message something like "too many connections" or "too many users"? my site only have 50 - 150 users when the error happen. my web hosting admin tell me that my site have been attacked by 5000 - 14000 conncetion request at a time. sometimes the hosting admin give my site a temporary suspended status to prevent mysql down.
my site using drupal 5.1 and mysql 4.1.22-standard
please help me since the problems occurs almost everyday. thanks...
=-=
A) you should be using Drupal 5.3, Drupall 5.1 has known security issues.
B) find patterns in the connections and block the offending IP addresses
C) move to a host that isn't as restrictive with MySQL, afterall Drupal is a DB driven CMS.
D) have host tune the MySQL server if necessary to allow for a better experience
E) get a dedicated server and set your own restrictions.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )