var connection;
function handleError () {
connection = mysql.createConnection({
host: '127.0.0.1',
user: 'test_user',
password: 'test_user',
database: 'test_user',
port: 3306
});
//连接错误,2秒重试
connection.connect(function (err) {
if (err) {
console.info('连接错误,2秒重试');
console.log('error when connecting to db:', err);
setTimeout(handleError , 2000);
}
});
connection.on('error', function (err) {
console.log('db error', err);
// 如果是连接断开,自动重新连接
console.info('如果是连接断开,自动重新连接')
if (err.code === 'PROTOCOL_CONNECTION_LOST') {
handleError();
} else {
throw err;
}
});
}
handleError();