My application, and specifically the database, needs multi-tenancy.
Set up is pretty standard with MySQL on the backend. Right now I have DSP wired to one database as the out-of-the-box configuration.
I don’t want to do record-based multi-tenancy for security reasons.
I don’t want to do a different MySQL server per tenant for cost reasons.
I could do either a) one database (and service?) per tenant or b) a table name prefix with each tenant having their own set of prefixed tables. Right now I’m headed down the path of b. I’ll have to script a fair bit for setting table-level role-based permissions in DSP.
Anyone have anything elegant here they’d suggest? Anything you learned where you did something similar?
What can I do to reduce throwaway wrt to the product roadmap?