When Databases Die What Happens To Your Site?

Bookmark and Share
| | Comments (5)
With dynamic publishing you get instant gratification. You click on "publish" and your latest rendition is immediately available to the world.

If, however, you opt for MovableType you have to wait a few seconds before your work of art is ready for public viewing.

Of course if your database server is unavailable for any reason (it happened to me the other morning) what happens?

If you're using a dynamically published CMS then your content is not going to be viewable.

Using MovableType however with static publishing all the site's content will still be viewable and spiderable while you fiddle with your database server.

Pretty cool as far as I'm concerned.
  • Currently 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 0/5(0 votes cast) digg| bookmark

Categories

,

5 Comments

Niall said:

That's what you get when you let a Michele admin a server ;)

Thanks for the vote of confidence !

True, but no big issue, as in most cases mySQL runs on the same server as apache. When mySQL dies, usually the whole servers is having problems, and your static pages will be unavailable as well.

Jeroen

That's simply not true.

The MySQL default config on most linux distros uses a very low number of connections. Until you tweak them the MySQL db server will run into "issues", but the server load can be negligible

Michele

Niall said:

Jeroen,

It's always great fun when going through Digg and coming across Wordpress sites which have a "Database Connection Error" due to the Digg effect. Mysql is very capable of dying with out of memory errors while apache keeps plodding away.

Of course the inverse is also through, I've seen Apache die with out of memory errors while mysql plods away.

Niall.

About this Entry

This page contains a single entry by Michele Neylon published on August 21, 2007 1:45 AM.

Subscribe To Comments Plugin Released for MT4 was the previous entry in this blog.

Must Have Plugins : Hot Date is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Powered by Movable Type 4.31-en