node mysql server disconnect

node_mysql_reco.js

// source: https://github.com/felixge/node-mysql#server-disconnects
var mysql = require('mysql');

function supportReconnect(connection, cb) {
  connection.on('error', function(err) {
    if (!err.fatal) return;
    if (err.code !== 'PROTOCOL_CONNECTION_LOST') throw err;
    connection = mysql.createConnection(connection.config);
    if (cb(connection))
      supportReconnect(connection, cb);
    connection.connect();
  }
}

// ...

var foo = {
  bar: mysql.createConnection({ host: 'localhost', user: 'root' })
}

supportReconnect(foo.bar, function(newConnection) {
  return foo.bar = newConnection;
});