nodejs mysql 集群_Nodejs群集与MySQL连接

看看关于Nodejs集群的建议和连接mysql服务器的方法 . 我们是为每个子进程打开一个连接还是为所有进程只打开一个连接？或者我们是否为所有子进程创建连接池？推荐的方法是哪种？

一个节点进程

var mysql = require('mysql');

var connection = mysql.createConnection({

host : 'example.org',

user : 'bob',

password : 'secret'

});

connection.connect(function(err) {

if (err) {

console.error('error connecting: ' + err.stack);

return;

}

console.log('connected as id ' + connection.threadId);

});

节点集群选项1：

var cluster = require('cluster');

var http = require('http');

var numCPUs = require('os').cpus().length;

if (cluster.isMaster) {

// Fork workers.

for (var i = 0; i < numCPUs; i++) {

cluster.fork();

}

cluster.on('exit', function(worker, code, signal) {

console.log('worker ' + worker.process.pid + ' died');

});

} else {

// open one connection for each process

var mysql = require('mysql');

var connection = mysql.createConnection({

host : 'example.org',

user : 'bob',

password : 'secret'

});

connection.connect(function(err) {

if (err) {

console.error('error connecting: ' + err.stack);

return;

}

console.log('connected as id ' + connection.threadId);

});

}

选项2：

var cluster = require('cluster');

var http = require('http');

var numCPUs = require('os').cpus().length;

var mysql = require('mysql');

var pool = mysql.createPool({

connectionLimit : 10,

host : 'example.org',

user : 'bob',

password : 'secret'

});

if (cluster.isMaster) {

// Fork workers.

for (var i = 0; i < numCPUs; i++) {

cluster.fork();

}

cluster.on('exit', function(worker, code, signal) {

console.log('worker ' + worker.process.pid + ' died');

});

} else {

// accept http connections and query

pool.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {

if (err) throw err;

console.log('The solution is: ', rows[0].solution);

});

}