node.jsmysql自动断开_nodejs连接远程MySql数据库出现自动断开问题

参照网上这段代码还是不能解决问题&＃xff0c;本地连接不会出现断开&＃xff0c;求大神们讲解

var connection;

function handleDisconnect() {

connection &＃61; mysql.createConnection(db_config); // Recreate the connection, since

// the old one cannot be reused.

connection.connect(function(err) { // The server is either down

if(err) { // or restarting (takes a while sometimes).

console.log(&＃39;error when connecting to db:&＃39;, err);

setTimeout(handleDisconnect, 2000); // We introduce a delay before attempting to reconnect,

} // to avoid a hot loop, and to allow our node script to

}); // process asynchronous requests in the meantime.

// If you&＃39;re also serving http, display a 503 error.

connection.on(&＃39;error&＃39;, function(err) {

console.log(&＃39;db error&＃39;, err);

if(err.code &＃61;&＃61;&＃61; &＃39;PROTOCOL_CONNECTION_LOST&＃39;) { // Connection to the MySQL server is usually

handleDisconnect(); // lost due to either server restart, or a

} else { // connnection idle timeout (the wait_timeout

throw err; // server variable configures this)

}

});

return connection;

}

handleDisconnect();