Skip to content

Please any example using node-pool #107

@nvcken

Description

@nvcken

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';

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions