DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’» is a community of 963,864 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
Code Salley
Code Salley

Posted on • Updated on

Multi-Tenancy with Nodejs and mongoDb

The main concept of multi-tenancy is privacy and data segregation, With MongoDB architecture ( Database and collections ). It’s easy to allocate collection for tenants database

Erb diagram

You should have a simple npm application setup and install mongoose by running;

npm install mongoose --save
Enter fullscreen mode Exit fullscreen mode

Implement a logic to handle MongoDB database connection and switching. In this scenario I will use two different approaches, switching between database's using useDb and disconnect and reconnect ( this is useful for test cases only )

Connect and disconnect approach


// mongoose import 
const Mongoose = require('mongoose')

// a function that takes database name and database url as import and return a mongoose connection
const connectDb = async (dbName, dbUrl) => {

if (dbName === Mongoose.connection?.db?.databaseName) return Mongoose

  try {
    Mongoose.connection.close()
    const mongoose = await Mongoose.connect(dbUrl, { useNewUrlParser: true })
    mongoose.connection.once('open', () =>
      log.info(`mongodb connected to ${dbUrl}`)
    )
    return mongoose
  } catch (error) {
    log.error(error)
  }
}
module.exports = { connectDb }
Enter fullscreen mode Exit fullscreen mode

with the above usage, all we need is the database name and database URL, We check the database name to see if it's already open, if open we just return mongoose object else we close all open connections and reconnect to the database using the URL we passed in.

useDb(recommended) approach


// mongoose import 
const Mongoose = require('mongoose')

// a function that takes database name and database url as import and return a mongoose connection
const connectDb = async (dbName, dbUrl) => {

if (dbName === Mongoose.connection?.db?.databaseName) return Mongoose

  try {
    if( Mongoose.readyState == 1 ) {
        return Mongoose.useDb(dbName)
    } else {
    const mongoose = await Mongoose.connect(dbUrl, { 
                           useNewUrlParser: true })
    mongoose.connection.once('open', () =>
      log.info(`mongodb connected to ${dbUrl}`)
    )
    return mongoose.useDb(dbName)
}

  } catch (error) {
    log.error(error)
  }
}
module.exports = { connectDb }
Enter fullscreen mode Exit fullscreen mode

A very simple approach, with useDb all we need is an open connection or create a new connection then return a new instance of MongoDB by passing the database name to the useDb function from an open MongoDB connection. In other cases you might have separate models(schema) for tenants, Here is an example.

// connect to mongodb
const mongoose = await Mongoose.connect(dbUrl, { 
                           useNewUrlParser: true })

// connect to prefer database
const db =  mongoose.useDb(databaseName)

// use model(schema) preferred
db.model(modelName, schema)

Enter fullscreen mode Exit fullscreen mode

Keep tenants locked up!!

twitter: code salley

Top comments (2)

Collapse
 
redfish profile image
Richard Guerci

Great Article! I am implementing the same logic in my app.
Is there a tenant limit? (I will have 400+ tenant)
Thanks for your help!

Collapse
 
codesalley profile image
Code Salley Author

As long as your app can handle the traffic. You’re good.

Visualizing Promises and Async/Await 🀯

async await

☝️ Check out this all-time classic DEV post