Category Archives: Systems Administration

Production MySQL performance tuning

For the past 9 years I’ve been working almost exclusively with MySQL (with a little PostgreSQL thrown in) and while I don’t do nearly as much DBA work these days, I still find myself troubleshooting a query or tuning my.cnf. … Continue reading

Posted in Database, FreeBSD, Linux, MySQL, Systems Administration | Leave a comment

Open source caching proxy servers

Hello lazy web, I’m looking for some advice on caching proxy servers and thought you might have some good pointers! We currently front our site with 3 caching proxy servers to offload static content from the web servers and we … Continue reading

Posted in Systems Administration, Web | 7 Comments

Ruby on Rails Dreamhost plugin

Update 2/11/07: Just to clarify, this plugin won’t keep your Rails site running on Dreamhost if the sum of all your running processes exceeds 200MB (which is when their process monitor kills your processes). Run ps aux and sum the … Continue reading

Posted in Ruby, Ruby on Rails, Systems Administration | 14 Comments

Keeping Rails running at Dreamhost Part 2

Update 2/2/07: Per Thomas’ comment I’ve released the code below as the dreamhost rails plugin. Update 1/25/07: People have reported difficulties copy and pasting the dispatch.fcgi source code from this blog post so here is a dispatch.fcgi to download. Make … Continue reading

Posted in Linux, Ruby, Ruby on Rails, Systems Administration, Web | 10 Comments

Keeping Ruby on Rails running at Dreamhost

Update 1/12/07: This solution has reduced my 500 error rate down to less than 0.2% but it’s still not perfect. I continue to plug away at this… Update 1/24/07: I’ve finally solved my Dreamhost 500 error problems with a different … Continue reading

Posted in Ruby, Ruby on Rails, Systems Administration, Web | 4 Comments

Comparing Amazon EC2 with VPS and dedicated hosting

I’ve been reading all the great things about Amazon EC2 (or Elastic Compute Cloud) and lots of pricing comparisons with VPS and dedicated hosting. I finally got an EC2 account and tinkered a bit and there’s a big difference between … Continue reading

Posted in Database, FreeBSD, Linux, MySQL, Systems Administration | 7 Comments

Trafeoffs of aggressive filesystem partitioning

Most systems administrators will tell you it’s important to partition your install into anywhere from 4-7 discrete patitions (or slices if you’re in the BSD camp). While I think it’s good advice in certain cases, the headaches of mis-guessing disk … Continue reading

Posted in FreeBSD, Linux, Systems Administration | 2 Comments

Hiring a senior MySQL and FreeBSD systems administrator

We’re hiring a senior MySQL and FreeBSD systems administrator to work at GreatSchools (a 40 person company) in San Francisco. If you or someone you know is interested in working on a high traffic website (1M page views per day) … Continue reading

Posted in Systems Administration | Leave a comment

Major sites not conserving bandwidth with gzip content compression

At GreatSchools we do around 1M real page views per day and another 250k or so for crawlers. Before content compression we were running well in excess of 10Mbit/s during peak hours and were getting hit with bursting charges on … Continue reading

Posted in Systems Administration, Web | 3 Comments

Creating subversion repositories for just about anything

I’ve been using Subversion for just about everything I work on including keeping my documents synchronized across multiple computers, backups, source control, etc… I got the idea a while back from Martin Fowler’s Bliki who uses it for a similar … Continue reading

Posted in Source Control, Systems Administration | Leave a comment