Database connection but not a connection?

[dynamicdave]

I had a similar (timing??) problem a few months ago and ended-up creating a simple 'keep alive' flow.
I just do a SELECT query every 15-minutes. There have been some updates (one just over a week ago) to node-red-node-mysql since I wrote the code, so I don't know if my workaround is still needed.

MySQL fails after an hour or so

Quick update to my test doing a SELECT query every 15-mins to see if MySQL connection remains active. My Telegram bot has been working fine for over 38 hours doing dB queries when requested by a user. I did try longer intervals (e.g. 30-mins and 45-mins) but settled on 15-mins for no real reason.