node-persist icon indicating copy to clipboard operation
node-persist copied to clipboard

Please any example using node-pool

Open nvcken opened this issue 11 years ago • 0 comments

My implement below, but not work database.json

"dev": {
        "driver": "mysql",
        "host" : "203.162.69.13",
        "port" : "3306",
        "user": "smilee",
        "password": "123456",
        "database": "bingota_web_noel",
        "pooling": {
          "name": "mysql_pool"
        }
    },
var poolModule = require('generic-pool');
    var pool = poolModule.Pool({
        name     : 'mysql_pool',
        create   : function(callback) {
            var Client = require('mysql').Client;
            var c = new Client();
            c.user     = 'smilee';
            c.password = '123456';
            c.database = 'bingota_web_noel';
            c.connect();

            // parameter order: err, resource
            // new in 1.0.6
            callback(null, c);
        },
        destroy  : function(client) { client.end(); },
        max      : 10,
        // specifies how long a resource can stay idle in pool before being removed
        idleTimeoutMillis : 30000,
         // if true, logs via console.log - can also be a function
        log : true 
    });
persist.env = 'dev';

nvcken avatar Dec 24 '14 00:12 nvcken