How to connect multiple mongodb database dynamically using mongoose?

In real-world development scenarios, dynamically connecting to multiple MongoDB databases is a highly practical requirement, for example, when handling multi-tenant systems. Mongoose is a powerful MongoDB object modeling tool that supports connecting to multiple databases simultaneously. Below, I will detail how to use Mongoose to dynamically connect to multiple MongoDB databases.

Step 1: Install and Configure Mongoose

First, ensure that Mongoose is installed in your project. If not, install it using npm:

bash
npm install mongoose

Step 2: Create a Dynamic Connection Function

We can create a function that accepts a database URI (Uniform Resource Identifier) as a parameter and uses it to create and return a database connection.

javascript
const mongoose = require('mongoose');

const connectToDatabase = async (uri) => {
  const connection = await mongoose.createConnection(uri, { 
    useNewUrlParser: true, 
    useUnifiedTopology: true 
  });

  return connection;
};

Step 3: Use Schema and Model

In Mongoose, each database connection can utilize distinct schemas and models. Therefore, you can define different models for each connection.

javascript
const userSchema = new mongoose.Schema({
  name: String,
  email: String,
  role: String
});

const createUserModel = (connection) => {
  return connection.model('User', userSchema);
};

Step 4: Dynamically Connect to Multiple Databases and Use Models

Now, you can connect to any number of databases as needed and instantiate models for each database.

javascript
async function main() {
  const dbConnection1 = await connectToDatabase('mongodb://localhost:27017/database1');
  const dbConnection2 = await connectToDatabase('mongodb://localhost:27017/database2');

  // Create models
  const User1 = createUserModel(dbConnection1);
  const User2 = createUserModel(dbConnection2);

  // Use models
  const user1 = new User1({ name: 'Alice', email: 'alice@example.com', role: 'admin' });
  const user2 = new User2({ name: 'Bob', email: 'bob@example.com', role: 'editor' });

  await user1.save();
  await user2.save();

  console.log('Users created in different databases.');
}

main();

Summary

Through the above steps, we can see that Mongoose provides a flexible approach to dynamically connecting to multiple MongoDB databases. This method is particularly suitable for applications with a multi-tenant architecture, where each tenant may need to operate on their own independent database instances.

This is the specific implementation method for dynamically connecting multiple MongoDB databases. I hope this helps you understand and apply it to your projects!