Handle mysql timeouts about mysql HOT 3 CLOSED

If anyone else runs into this problem, this is a good stopgap:

// Reconnect every 5 minutes
// I believe default mysql-timeout is 10 minutes
setInterval(function() {
    client.end();
    client.connect();
}, 300000);

from mysql.

The client will now automatically reconnect whenever a connection ends that was not supposed to be ending. This should fix this issue for most parts.

See: 81edd83

I might spend some more time on implementing exponential backoff and things like that.

from mysql.

First, thank you for all your efforts.

Just wondering, is exponential backoff on the roadmap. Various cloud providers are recommending it as a recovery strategy.

from mysql.