I am planning the deployment of my first rails app. The app is such
that different users can, and should, be running against their own
personal and separate databases. The load caused by each user is
fairly low, with perhaps one hit every 10 minutes or so, but for the
economics of the app to work I need to be able to host as many users
as possible per machine. From my research so far, I was planning on
running Apache+ mod_proxy against a cluster of mongrel servers, but it
is not clear to me if I need one mongrel cluster per database/user or
if can share mongrel instances between them.
Any advice or references?