2008-05-30 20:56:00
Today (or for the USAdians: tonight) my website was down for at least ten hours. The webserver itself was up and running, but the comms with the MySQL backend weren't working at all. Originally I'd assumed that the Dreamhost box my database runs on was dead, but oddly enough it was alive all day.
After some troubleshooting together with the DH team (who took their sweet time in answering my first e-mail), we found out that there were DNS issues. Apparently the requests regarding my database server were -very- slow, causing MySQL and such to time-out. Maybe it was related to the SIDN snafu last night?
Anywho... I'm up and running again, with a few improvements under the hood. This downtime has forced me to add some error reporting and few other niceties that ought to make my site a little more secure.
Now... Homework... ^_^
kilala.nl tags: website,
View or add comments (curr. 1)
All content, with exception of "borrowed" blogpost images, or unless otherwise indicated, is copyright of Thomas Sluyter. The character Kilala the cat-demon is copyright of Rumiko Takahashi and used here without permission.
2008-05-29 21:26:00
Posted by Cailin Coilleach
The final tweaking is done. Sorry for a few glitches after the fact that I posted everything was solved. I needed to quickly test a few things I'd implemented.
From now on, whenever the database connection is unpossible, a clean HTML file without any dynamic content will be served. Just the two graphics and a message informing the visitor about the site's troubles.
I've also finally done the right thing and have started filtering out any attempts at "h4x0Ring" the article IDs that are passed as URLs. From now on, any invalid article ID will not result in nasty PHP messages, but in a neat error screen. Great :)