Posted by spite on 2008-08-07
Okay, we don't really have the best hosting in the world. We knew it. We just didn't think it sucked so very much.
The thing is like this: the basic pack from 1and1 Spain offers you, amongst other things, five mySQL databases, with a 100MB size limit. That's fine with us.
Problems arise when, out of the blue, queries that took 30ms start taking seconds. Things go to hell when a query that should took a second takes up to 3 minutes.
That's it. Isn't it wonderful?
That's what's been happening for some hours now: one of the five database server -each database is in a different server- has been giving error messages of being out of available connections. Niiiiice. The matter being that this precise server is the one keeping the main database.
Nothing is working, so I've set up a "the site is down" page, and blocked the whole site. That's done with a single line rewrite rule in the .htaccess file.
So, that's it: first downtime in our history. Yay.
Update: During the long mail-in-mail-out discussion with 1and1's helpdesk, they've told us that since it's a shared hosting, it's quite usual to have "punctual saturation". I guess that's what you call having your database server down to its knees for more than 6 hours.