.. I'm using the events socket to trigger things in NodeRed and I have a small nodejs app running that listens on the logging socket and just stuffs those into a MySQL database running on the RPi as well.
Just curious - couldn't you use NodeRed to push the logs into MySQL as well? Also what about testing the event socket for lockups. The http way does seem easier though.
