mysql-cluster

mysql-cluster
=============

npm install mysql-cluster

A wrapper around mysql standard driver. Supports a PoolCluster setup with easy master/slave switching.

``
var mysql = require('mysql2');

// Sample config
var config = {
driver: mysql, // Optional parameter. You can use a version of mysql or mysql2. Default mysql2 will be used when omitted.
cluster : {
canRetry : true,
removeNodeErrorCount : 5,
defaultSelector : 'RR'
},
global : {
host : 'localhost',
user : 'root',
password : '',
database : testDbName,
connectionLimit : 100,
waitForConnections : true,
queueLimit : 10
},
pools : {
master : {
config : {
user : 'root'
},
nodes : [ {
host : 'localhost'
} ]
},
slave : {
config : {
user : 'root'
},
nodes : [ {
host : 'localhost'
}, {
host : 'localhost',
user : 'root'
} ]
}
}
}

var cluster = require("mysql-cluster")(config);

// Aquire connection to one of nodes inside "slave".
cluster.slave(function(err, conn) {
if(!err) {
conn.query('select * from test limit 10', function(err, result, fields) {
// do something
conn.release(); // Put the connection back into pool.
}
} else {
console.log('Error, failed to aquire connection);
console.log(err);
}
}
``