I’ve setup a more resilient web service for a good client of mine.. http://www.practicalaction.org/
By using 2 servers and ‘pound’ they now have some load balancing but most importantly some resilience.. so if one server dies, they have a complete and current duplicate to fall back on.
wget http://www.invoca.ch/pub/packages/pound/pound-2.3.2-1.src.rpm
yum install rpm-build
yum install pcre-devel google-perftools-devel
Resources:
http://blog.tupleshop.com/2006/7/8/deploying-rails-with-pound-in-front-of-mongrel-lighttpd-and-apache
http://www.apsis.ch/pound/pound_list/
http://forums.rimuhosting.com/forums/showthread.php?t=389
Future thoughts :
http://sqlrelay.sourceforge.net/index.html