The database itself is probably a mess in terms of efficiency and resource management. It's old and I know it has had trouble in the past. The worst thing is that it's a compounding problem. The bots try to open a bunch of connections, which causes the server to burp, which causes the bots to send even more connection requests. There's not a good way to stop it cheaply. You COULD throw money at more CPU and such but it won't fix the problem.
What we really need is for the hosting provider to provide some kind of DDOS protection so that the requests get filtered before they hit the server. But that costs money, considerably more than just upgrading resources.
|