Looks like the site it up. Great!
Maybe some things can be done to avoid some of these problems in the future. I am the author of Video Monkey (http://videomonkey.org
). I use thetvdb.com to get metadata for TV Shows Video Monkey is encoding. My users love it. But I made the mistake of doing an autosearch when a file is dragged into the GUI, and that has caused horrible delays and errors over the last few days. I'm fixing that so you can turn off auto-search.
For me, the biggest problem has been that the front page was down, so I had no way of knowing what was going on. Google shows lots of old message threads of the site going down, so it was hard to find new information. Yesterday, I finally stumbled on this forum, which thankfully was not down. So I felt a bit better informed about what was going on.
It's great that the database is now apparently on a new server and might be more reliable. But this problem will happen again. It always does with these sorts of databases. That down time is a lot more tolerable if there is good information about why it's happening. Is there some way that the front page of the site could be hosted somewhere else that didn't have downtime issues. I would imagine that the downtime problems are a result of the huge database, so putting the front page on a separate server seems like it would be more reliable. That way, you could put a message on the front page that said the server was down and some indication of when it might be back up.
Doing this also seems like it would make it possible for searches to quickly give back 404 or some other error pages when downtime happens, so that a tool like mine can issue a useful error. And it would make it possible to get to the wiki and forum pages for more information.
Finally, I'm sure the subject of mirrors has come up before. I'm sure there are plenty of us out here who would be willing to mirror the data. I'm note sure how big the database is, but I know from recent research that the IMDb database is < 500MB. Now that doesn't include artwork, which I'm sure takes a huge amount of storage. But even if a mirror couldn't host the artwork, it seems like it would be a reasonable temporary fallback. I have a server on a pair of OC3 lines, which has 100G or so of storage sitting idle. I'd be happy to use some of that for a mirror.
Once again, congratulations on getting the site back up. I'm sure it's been more painful for all of you than for all of us.