A node.js mysql adapter for managing/querying pooled connections on top of node-mysql module.

npm install mysql-connection-pool

A Node.js api wrapper for a cluster of MySQL instances. Probably a naive approach but could become more fully-featured and tested in the future. Would only recommend as experimental. Uses node-mysql and underscore modules.

Here's an example using it:

var configurations = [
    {host:'', user:'user', password:'secret'},
    {host:'', user:'user', password:'secret'},
    {host:'', user:'user', password:'secret'}
// Initialize pool of connections 
var pool = new MysqlConnectionPool(configurations);
// Opens all connections in the pool;
// Query a connection in the pool, logging output 
pool.query('show tables;', function(errrows){
    if (err){ throw err; }
// Close the entire pool after 3 seconds (otherwise thread remains open) 
setTimeout(function(){pool.close();}, 3000);

Using an external config:

var _ = require('underscore');
var config = require('./config');
var MysqlConnectionPool = require('./index');
var pool = new MysqlConnectionPool(, function(host){
    return {
        host     : host,
        user     : config.user,
        password : config.password,
        database : config.database