mysql-master-slave

MySQL Master Slave
====

This module is depend on mysql module for build the master, slave database environment.

Installation

``
npm install mysql-master-slave
`

Usage Sampple:

`
var cluster = require('mysql-master-slave');

var opts = {
connectionLimit : 10,
user: 'your-user',
password: 'your-password',
database: 'sampledb'
}

cluster.addMaster('your-mysql-server', '3306', opts);
cluster.addMaster('your-mysql-server', '3306', opts);
cluster.addSlave('your-mysql-server', '3306', opts);
cluster.addSlave('your-mysql-server', '3306', opts);
cluster.addSlave('your-mysql-server', '3306', opts);

var sql = 'insert into test123 (create_date) values (?)';

for(var i = 0 ; i < 10 ; i++)
cluster.pool.query(sql, [new Date()], function(err, r, f){
if(err) {
console.log('Error:', err);
}

console.log('Result:', r);
process.exit(0);
});
`

Execution result:

`
node test.js
[2015-04-06 09:31:26.424] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.431] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.432] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.433] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.434] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.436] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.437] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.437] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.438] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:31:26.439] [DEBUG] [default] - [index.js - query] using master pool...
Result: { fieldCount: 0,
affectedRows: 1,
insertId: 40,
serverStatus: 2,
warningCount: 0,
message: '',
protocol41: true,
changedRows: 0 }
`

About Transaction

If you want to use transaction in your project. There is a quick way to implememt transaction use "cluster.beginTransaction()" and "tx.addJob()"...

`
var cluster = require('mysql-master-slave');

var opts = {
connectionLimit : 10,
user: 'root',
password: '123456',
database: 'mydb'
}

cluster.setDbSelectStrategy(1);

cluster.addMaster('123.123.123.123', '3306', opts);
cluster.addMaster('124.124.124.124', '3306', opts);

var tx = cluster.beginTransaction();

tx.addJob('insert into test123 (id, create_date, data) values (?, ?, ?)', [50, new Date(), "test 中文"], function(){
console.log('job1 done...');
})

tx.addJob('select * from test123 where id =?', [51, "test 中文"], function(err, result){
console.log('verify job1 done...');
if(err) {
console.log('error:', err);
}

console.log('result:', result);
});

tx.exec(function(err, result){
if(err) {
console.log('err:', err);
}
console.log('>>>', result);
});
`

Others

Setup as sequence read from pool or random select.

`
cluster.setDbSelectStrategy(1);
`

Result:

`
[2015-04-06 09:37:23.767] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.778] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.779] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.779] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.780] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.781] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.782] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.782] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.784] [DEBUG] [default] - [index.js - query] using master pool...
[2015-04-06 09:37:23.785] [DEBUG] [default] - [index.js - query] using master pool...
Result: { fieldCount: 0,
affectedRows: 1,
insertId: 50,
serverStatus: 2,
warningCount: 0,
message: '',
protocol41: true,
changedRows: 0 }
``