我踩过的坑，免费版的mongodb只能采用短连接方式；部署过nodejs博客; 送你一套源代码 var config = require(’…/config’); var dbPath = config.DbPath; var mongoose = require(‘mongoose’); var extend = require(‘mongoose-schema-extend’); var loggertxt = require(’…/utility/loggertxt’).logger;

var options = { db: { native_parser: true }, server: { poolSize: 5, auto_reconnect:true }, user: config.username, pass: config.password } //mongoose.connect(dbPath,options); var db = mongoose.createConnection(); //mongoose.connect(dbPath, options); db.open(config.db_host, config.db_name, config.db_port, options); db.on(‘close’, function(){ loggertxt.error(‘MongoDB被关闭’); //mongoose.connect(dbPath,options); db.open(config.db_host, config.db_name, config.db_port, options); }); db.on(‘connected’, function() { loggertxt.info(‘MongoDB连接成功’); }); db.on(‘disconnected’, function() { loggertxt.info(‘MongoDB连接断开’); //mongoose.connect(dbPath,options); db.open(config.db_host, config.db_name, config.db_port, options); }); db.on(‘error’, function (err) { loggertxt.error('MongoDB连接错误: ’ + err); db.close(); //mongoose.disconnect(); //process.exit(1); }); db.on(‘open’,function(){ loggertxt.info(‘MongoDB被打开’); }); exports.mongoose = mongoose; exports.db = db;

//基础Schema var base = new mongoose.Schema({ //唯一键 _id: {type: String, unique: true}, //创建时间 CreateTime: {type: Date}, //修改时间 ModifyTime: {type: Date} }); exports.base = base;

然后其他请求方式 请求一次连接一次，然后关闭， ‘use strict’;

var mongoose = require(‘mongoose’); var extend = require(‘mongoose-schema-extend’); var util = require(“util”); var loggertxt = require(’…/utility/loggertxt’).logger;

function MongooseKeeper() { this.db = mongoose.createConnection(); this.open_count = 0; } MongooseKeeper.prototype.config = function(conf) { // body… var options = { db: { native_parser: true }, server: { poolSize:4 } };

var constr = "";
if(process.env.MONGO_DB_STR){
    constr = process.env.MONGO_DB_STR ;
}
else{
    //'mongodb://user:pass@localhost:port/database'
    if(conf.userid&&conf.password){
        constr = util.format('mongodb://%s:%s@%s:%d/%s', conf.userid,conf.password,conf.host,conf.port,conf.database);
    }else {
        constr = util.format('mongodb://%s:%d/%s',conf.host,conf.port,conf.database);
    }
}
this.dbUri = constr;
this.options = options;

} MongooseKeeper.prototype.open =function() {

this.open_count++;
if(this.open_count ==1 && this.db.readyState == 0)
{        
    this.db.open(this.dbUri,this.options,function() {
        // body...
        loggertxt.info("db opened");
    });
}

} MongooseKeeper.prototype.close =function() { loggertxt.log(“正在访问的数据库请求量”+this.open_count); this.open_count–; if(this.open_count == 0 ) { this.db.close(function(){ loggertxt.info(“db closed”); }); }

我的博客www.chenyulun.com;什么都没配置； 源代码贴https://cnodejs.org/topic/56f122ba0a5a2cfb3ad1491c#572c077aafd3b34a17ff405e