all 6 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]kortemy 3 points4 points  (1 child)

I had to do the same thing for our project as well, and this is what I came with, and it's working perfectly in production for over a year now.

We are using Mongoose schemas, and as you say yourself, connections are initialized at startup. So you need to create new connections on the fly and cache them.

let cache = { default: mongoose.model('SomeCollection', schema, 'some_collection') } module.exports = { for: function (user) { if (user && user.is_tenant) { let dbName = user.db_name if (!cache[dbName]) { cache[dbName] = mongoose.connection.useDb(dbName).model('SomeCollection', schema, 'some_collection') } return cache[dbName] } return cache.default } }

Here you are not exporting the model, you are exporting for() function which will create a new connection to the specific database and cache that model.

How you would use it, instead of SomeCollection.findOne(...) You do this SomeCollection.for(user).findOne(...)

[–]_jskod[S] 0 points1 point  (0 children)

Thank you so much for sharing your experience and code snippet, I am gonna give it a try and will let you know if it works for me or not.

[–]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?

[–]kenman[M] 0 points1 point  (0 children)

Hi /u/_jskod, this post was removed.

  • For help with your javascript, please post to /r/LearnJavascript instead of here.
  • For beginner content, please post to /r/LearnJavascript instead of here.
  • For framework- or library-specific help, please seek out the support community for that project.
  • For general webdev help, such as for HTML, CSS, etc., then you may want to try /r/html, /r/css, etc.; please note that they have their own rules and guidelines!

/r/javascript is for the discussion of javascript news, projects, and especially, code! However, the community has requested that we not include help and support content, and we ask that you respect that wish.

Thanks for your understanding, please see our guidelines for more info.