I'm working on a project that will have over 1000+ tenants (no joke) most of the sites will be low traffic a few will have moderate traffic.
I've read probably every thread on here about multi tenancy. From what I gather no one is running anywhere near this number of tenants.
I guess the big question is will it work?
I know it will need to be distributed across multiple servers but will it be possible to run every tenant on ever server? (I'm thinking memory foot print may be to big) I'd rather not have to split the tenants on to separate servers.
Could someone who is familiar with multi tenancy please outline that main bottle necks?
I know there was talk that it would be good to have a version that worked off one DB / set of tables, did anyone do any investigation around this? I'm not adverse to writing code.