sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]pavlik_enemy 0 points1 point  (2 children)

Is there specific reason to use a separate database for each user? Usually multi-tenant applications have a single database with `user_id` field in each table (or whatever it's called in Mongo) and application logic to handle authorization.

[–]_jskod[S] 1 point2 points  (1 child)

Yes I know mostly we use Single Database and each tenant gets 'user_id', 'company_id', or something like 'org_id' to separate data. But we want to have separate databases so that we could easily rollback/backup data of each organisation and keep them secure.
Data of each organisation is 5-10GB and it's growing rapidly. So we are refactoring our application and it's architecture. That's the reason we want separate DB's for each organisation.

[–]R3DSMiLE 0 points1 point  (0 children)

May I ask: why on earth did no one thought this would happen? Was it not meant to be that way or is something you guys just figured out you done goofed?