Awhile back, I blogged how to go about this. Some of the hacks will not be needed for Rails 3.2, but the concepts are the same:
http://blog.jerodsanto.net/2011/07/building-multi-tenant-rai...
http://blog.jerodsanto.net/2011/07/building-multi-tenant-rai...