How is your experience on Node-RED, MQTT and Linux for 24/7 data logger?

See Best Linux Version to Node-Red for a discussion on this. I am surprised that you did not see that post, presumably you did search the forum before asking the question.
Whether you want a gui or command line install is up to how you want to use it.

Mosquitto. Self hosted.