Resolving handshake inactivity timeout error in Node.js's MYSQL module

Question

I'm using node-mysql and most of the queries work fine. But some queries don't work. I tried every version of Node (from 0.5... to 5.6.0), I also tried 4.0 and 4.1 but neither helped. I tried changing it manually but it had no effect. I tried changing the sequence file to: this._idleTimeout=-1; but that didn't help either. I read the issues and stuff on GitHub but no help. I could try to fix it myself, but I need more information. Where is the timeout sent?

P粉547420474 · Answer

For those deploying on AWS and encountering this error, you will need to make changes to the security group of the database/cluster, Add an inbound rule where source is the security group of the instance.

The inbound rules should look like this:

类型：MySQL/Aurora
协议：TCP（默认）
端口：3306（默认）
源：<实例的安全组>
描述：<可选>

P粉155128211 · Answer

Okay, the timeout is from line 162 of the Protocol.js file. If you look at node-mysql, you will see that the variable queried is "timeout". If you set the timeout to a much higher value than the default of 10000, the error should go away. An example is

pool = require('mysql').createPool({
    connectionLimit : 1000,
    connectTimeout  : 60 * 60 * 1000,
    acquireTimeout  : 60 * 60 * 1000,
    timeout         : 60 * 60 * 1000,
    host            : process.env.DB_HOST,
    user            : process.env.DB_USERNAME,
    password        : process.env.DB_PASSWORD,
    database        : process.env.DB_DATABASE
});

You can also edit the timeout in the Sequence.js file (node_modules/mysql/lib/protocol/sequences/Sequence.js)

this._timeout  = 100000;