I've been fiddling with Apache virtual hosting for Rails apps, but am not very happy with it so far in terms of performance and flexibility.

I'm looking for the most robust way to serve a few apps from one server while retaining the ability to control the version of ruby and rails being used. RVM would be ideal. Does anyone have recommendations of what has worked out best for you or what you've seen that works well in this regard to hosting multiple Rails apps?

MySQL or PostgreSQL would be a bonus.