On Mon, 13 Feb 2006 11:12:27 -0800 "Edgars Jekabsons" <[EMAIL PROTECTED]> wrote:
> > Does anyone else who uses Dreamhost has problems with MySQL connection > going away? > > The project I suggested hosting there is not even inproduction yet, > but we get MySQL server errors a lot (a few times a day). > Sometimes it's just Django error 500, but other times I get a Python > traceback screen. > > Is it just plain unlucky me and an unreliable MySQL server on > Dreamhost or I should have used something more robust than the setup > described in http://wiki.dreamhost.com/index.php/Django? > > TIA, > Edgars > I seemed to have a problem with a test environment I setup. But my "main production" environment is doing better. I don't think it would hurt anything to replicate your current database on a new DB which you setup in the Dreamhost panel. I wrote a little ping script which requests a URL in my app which triggers a simple database lookup. I run the script on a cron job every 5 minutes on a server on my LAN at home. Over the past 8 days, it's only reported back 4 errors. After I got the sense to store the resulting error pages, it looks like one is a 500 error (which feels like a database problem) and one is a a URL lookup failure. The latter is a little weird. I'll try to beef up the error trapping and reporting when I get a chance. One of the reasons I did this, though, was on Dreamhost my app is running under fastcgi. Since it's a low-traffic site, the response time for a new request after no requests have happened in a while is miserable. So, this script keeps the site alive and hopefully provides users with a little better experience and provides information for when the site was having problems. Anyway, that's not exactly what you were asking, but I hope it's helpful nonetheless. - jmj
