Is it possible to catch and handle 'connection lost' event and try to reconnect to db now?
I use mysql driver and I have wait_timeout set in mysql config, so, if connection is inactive for some time, mysql closes it and node-mysql throws an error.
I tryed to catch it with db.driver.on or db.driver.db.on, but no success.
So, I have two questions:
- What should I do in this situation? Should I just ping db every n seconds, or there is another solution?
- What is happening when I do
db.driver.db.on? As far as I understand, db.driver.on is an instance of node-mysql connection. But, when I do:
var mysql = require('mysql');
var conn = mysql.createConnection(my_params);
conn.connect(my_cb);
conn.on('error', function (e) { ... }); // I'm doing this in node REPL, so error handler is attached after db is connected.
everything works well, and, when I do:
var orm = require('orm');
orm.connect(my_params, function (e, db) {
db.driver.db.on('error', function (e) { ... }); //There can be db.driver.on also
});
node-mysql just throws unhandled exception and the whole process ends.
Any help would be appreciated!
Is it possible to catch and handle 'connection lost' event and try to reconnect to db now?
I use mysql driver and I have wait_timeout set in mysql config, so, if connection is inactive for some time, mysql closes it and node-mysql throws an error.
I tryed to catch it with
db.driver.onordb.driver.db.on, but no success.So, I have two questions:
db.driver.db.on? As far as I understand, db.driver.on is an instance of node-mysql connection. But, when I do:everything works well, and, when I do:
node-mysql just throws unhandled exception and the whole process ends.
Any help would be appreciated!