On Monday, July 23, 2012 3:01:40 PM UTC-7, Cliff Kachinske wrote: > > > Separate DBs sounds messy. > > Some elaboration on that point. >
Everything that is simple to do on one DB becomes complicated to do on multiple DBs. For example, I run a multi-tenant site that I constantly run queries against all tenants. That would be a pain with separate DBs. Same with migrations, backups, etc. And I don't see much actual benefit of splitting into multiple DBs. The benefits I hear about seem mostly perceptual (data isolation, etc). --
