MySql Node "Error: Pool Is closed"

[dynamicdave]

I had a similar error when using the MySQL node last year (2021).

[Feedback wanted] Update to mysql node

I have just updated the node-red-node-mysql node to use the more maintained mysql2 library in response to MySQL 8.0 needs new Auth mechanism · Issue #853 · node-red/node-red-nodes · GitHub - and it is on npm as node-red-node-mysql@next so can be manually installed... eg cd ~/.node-red && npm i node-red-node-mysql@next If anyone has any time to give it a whirl I would really appreciate it. It claims to be nearly compatible with the basic mysql library but there are some known differences, see-…

Are you using the latest version as @dceejay has done a lot of work improving this node, in fact there was an update a week ago.

One of my problems was the number of dB connections. I found when I reduced the number of connections the node behaved much better.

I'm also using this flow to perform a 'keep database alive' every 15-minutes.

[Feedback wanted] Update to mysql node

Upgrade MySQL - working like it suppose to.