I am looking for an inexpensive backup for a site that I currently hosted on a colocated box. The site is a rails/MySQL application. I wanted to run the application and the database on the same box for cost savings reasons, since this is only an emergency backup site, I don’t expect the usage to be much at all, so I’m not worried about performance with SQL and Apache on the same server.
I ordered a PS and installed ruby, rails, and apache on it without problems. But when I tried to install MySQL on the box I got errors. I first tried to install Debian packages and those failed quickly with dependency errors. I didn’t want to screw around too much with what DreamHost has already installed on these boxes so I tried to compile from source. It compiled and installed OK, but then whenever I try to use MySQL I get errors… the executables are looking for things in paths that don’t exist. I even tried recompiling with some path options to the configure script, and I still couldn’t get it to work.
I can post the exact errors I got later tonight, but for now, is there anyone with experience installing MySQL 5 on PS-Web box? I am trying to avoid the monthly cost of an additional PS-MySQL.