Pumych Pumych - 2 years ago 908
Node.js Question

Mongoose multiple connections

Currently I have this code for my connection mongoose.js:

var mongoose = require('mongoose');
var uriUtil = require('mongodb-uri');
var mongodbUri = 'mongodb://localhost/db_name';
var mongooseUri = uriUtil.formatMongoose(mongodbUri);
module.exports = mongoose;

File that requires the connection is test.js:

var mongoose = require('../model/mongoose');
var schema = mongoose.Schema({...});

How can I update mongoose.js to use multiple connections with mongoose.createConnection(...) function?

I start with changes only for one connection when I do changes like that:

var mongoose = require('mongoose');
module.exports = mongoose;

I get "undefined is not a function".
If I use this code:

var mongoose = require('mongoose');
db = mongoose.createConnection('mongodb://localhost/db_name');
module.exports = mongoose;

I get "Error: Trying to open unclosed connection"

Any advice?

Answer Source

why do you need another connection?

Mongoose handling connections via connections pool http://mongoosejs.com/docs/connections.html

you can use server: {poolSize: 5} option for increase/decrease pool (number of parallel connections)

If you need connections to different databases look here Mongoose and multiple database in single node.js project

Example of multiple connections:

var mongoose = require('mongoose')
var conn = mongoose.createConnection('mongodb://localhost/db1');
var conn2 = mongoose.createConnection('mongodb://localhost/db2');
var Schema = new mongoose.Schema({})
var model1 = conn.model('User', Schema);
var model2 = conn2.model('Item', Schema);
model1.find({}, function() {
   console.log("this will print out last");
model2.find({}, function() {
   console.log("this will print out first");
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download