By godam64 on

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...

⋅ Categories: Drupal 5.x

Comments

vm’s picture

vm commented

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 : )