# Best platform for Node red

**URL:** <https://discourse.nodered.org/t/best-platform-for-node-red/10499>\
**Category:** General\
**Created:** [24 April 2019 10:57 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499 "2019-04-24T10:57:56Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![olab](https://avatars.discourse-cdn.com/v4/letter/o/d07c76/32.png) [@olab](https://discourse.nodered.org/u/olab)\
**Post date:** [24 April 2019 10:57 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/1 "2019-04-24T10:57:56Z")

</div>

This is a question with probably many answers but I'll as anyway.

I'm about to set up a node red system to present dashboards from mainly OPUA and MSSQL data. To host this I'll set up a virtual Linux server.

What experiences does the community have? Which Linux distribution to use? CPU, RAM?  
We are probable talking about 300 UPC tags, 30-40 trends, 50 gauges.

Any suggestions?

O

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [24 April 2019 19:45 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/2 "2019-04-24T19:45:14Z")

</div>

> [@olab](#):
>
> CPU, RAM?  
> We are probable talking about 300 UPC tags, 30-40 trends, 50 gauges.

It is quite possible that even a Pi could handle this. So maybe a nano-PC of some kind if you want something more powerful than a Pi3 or equivalent.

> [@olab](#):
>
> Which Linux distribution to use

Well that is very subjective. The most experience from this community is from Rasbian which is derived from Debian. Dave's Pi installation script is likely to work on a Debian OS. Ubuntu is also derived from Debian so that should also work well. Debian is stable, well supported and relatively light weight; however, it doesn't update very often - of course that is likely to be of benefit to you giving you a stable platform but it is likely that it would mean you would need to take more active charge of some key services such as installing and updating newer versions of Node.js. You wouldn't have those issues as much with Ubuntu.

If you don't need the desktop, either don't start it or chose a variant that doesn't include it.

If you end up with a platform with sufficient spare capacity, I would personally also recommend installing `webmin`. This gives you a web interface for managing Linux. In particular though, it gives you the ability to configure it such that it will auto-update Linux software packages for you which can be a reasonably large overhead for running Linux servers.

---

<div class="post-metadata">

**Author:** ![Robbo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/robbo/32/4491_2.png) [@Robbo](https://discourse.nodered.org/u/Robbo)\
**Post date:** [24 April 2019 19:48 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/3 "2019-04-24T19:48:08Z")

</div>

If the aim is too just display guages and graphs then Grafana sounds more suitable for your project?

I would use the OS your more familiar with what ever that maybe. I tend to use Docker containers for projects like this.

---

<div class="post-metadata">

**Author:** ![JayDickson](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jaydickson/32/90592_2.png) [@JayDickson](https://discourse.nodered.org/u/JayDickson)\
**Post date:** [24 April 2019 20:04 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/4 "2019-04-24T20:04:26Z")

</div>

All of my prod instances are Ubuntu Server on ESX. Resource requirements are fairly low and you're limited to a single thread, so going heavily co-tenant is a good way to squeeze your money's worth out of modern hardware.

---

<div class="post-metadata">

**Author:** ![olab](https://avatars.discourse-cdn.com/v4/letter/o/d07c76/32.png) [@olab](https://discourse.nodered.org/u/olab)\
**Post date:** [25 April 2019 15:31 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/5 "2019-04-25T15:31:53Z")

</div>

Sounds like a good idea. I havn't checked Grafana until now but it looks like what I need.

Do you have a sample showing how to get data from Node Red, over to Grafana?

O

---

<div class="post-metadata">

**Author:** ![JayDickson](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jaydickson/32/90592_2.png) [@JayDickson](https://discourse.nodered.org/u/JayDickson)\
**Post date:** [25 April 2019 15:43 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/6 "2019-04-25T15:43:48Z")

</div>

> [@MQTT-\>(JSON)-\>?-\>InfluxDB-\>Grafana](https://discourse.nodered.org/t/mqtt-json-influxdb-grafana/7108):
>
> Hi, I'm brand new to NodeRed, MQTT, InfluxDB and Grafana I'm trying to visualize Data form a ESP8266. Onto the dashboard the data come in. But I've got an issue to transform the MQTT data into an proper format for InfluxDB. NodeRed time series graphs work fine, but I can't visualize the MQTT sensor data in Grafana. What should I do? A transformation with the json block, and a custom function. But what shoult the function looks like? Everything I tried doesn't work.

---

<div class="post-metadata">

**Author:** ![Robbo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/robbo/32/4491_2.png) [@Robbo](https://discourse.nodered.org/u/Robbo)\
**Post date:** [25 April 2019 15:53 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/7 "2019-04-25T15:53:33Z")

</div>

Grafana has data sources for MS-SQL (as well as many others), so that's probably the most efficient way? I've not heard of OPUA.

---

<div class="post-metadata">

**Author:** ![Meloman](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/meloman/32/96137_2.png) [@Meloman](https://discourse.nodered.org/u/Meloman)\
**Post date:** [16 January 2023 06:52 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/8 "2023-01-16T06:52:18Z")

</div>

Thank you for this explanation.

In my case the choice will be Ubuntu Server LTS with Node-Red, OpenVPN, MySQL and Webmin.  
With this combination, I'll get a long life of Ubuntu in server version so light (no GUI or useless apps) but easy to manage remotely via VPN secure connection.

I'll make a tuto if I have enough time.

---

<div class="post-metadata">

**Author:** ![Meloman](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/meloman/32/96137_2.png) [@Meloman](https://discourse.nodered.org/u/Meloman)\
**Post date:** [16 January 2023 07:04 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/9 "2023-01-16T07:04:53Z")

</div>

I think he meant "OPC UA Server" with OPUA.

I did not know Grafana, I will study that, at first sight, I like it.

---

<div class="post-metadata">

**Author:** ![Meloman](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/meloman/32/96137_2.png) [@Meloman](https://discourse.nodered.org/u/Meloman)\
**Post date:** [16 January 2023 07:11 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/10 "2023-01-16T07:11:52Z")

</div>

I know this question is 4 yld but If it interests some of you, I tested with ModBus TCP communication for about 220 values (2 queries of 120 and 100 registers at time) each second, recording in MySQL database, it works fine and CPU load on Raspberry Pi 4 is 2-5% only.

So Pi4 is enough, but best is to install a SATA SSD on it for database.  
We use this solution :

> **[Geekworm X825-C8 (X825 V2.0) Metal Case+Power Switch+Cooling Fan Support X825...](https://www.amazon.fr/Geekworm-X825-C8-Cooling-Support-Raspberry/dp/B09295FHBW)**
>
> Achetez Geekworm X825-C8 (X825 V2.0) Metal Case+Power Switch+Cooling Fan Support X825 V2.0 2.5 inch SATA SSD/HDD Shield & Raspberry Pi 4 Model B & X735 Only(Not Support X825 V1.5): Amazon.fr ✓ Livraison & retours gratuits possibles (voir conditions)

And i install Ubuntu Server on it or in some cases the Pi OS.

---

<div class="post-metadata">

**Author:** ![KarolisL](https://avatars.discourse-cdn.com/v4/letter/k/a4c791/32.png) [@KarolisL](https://discourse.nodered.org/u/KarolisL)\
**Post date:** [16 January 2023 08:55 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/11 "2023-01-16T08:55:19Z")

</div>

My 2 cents about Raspberry pi is that SD cards are sensitive to shutdown and might go corrupt.  
There are a lot of similar forum posts about that: [https://forums.raspberrypi.com/viewtopic.php?t=311435](https://forums.raspberrypi.com/viewtopic.php?t=311435)

In my case, RPi was shutdown every day for a night, so UPS was not an option. Some cards performed better, some worse, but longest I managed to run without SD card fail was ~4months.

For that reason we switched to industrial devices: Siemens IOT2040/2050 or even ipc127e. Price and performance ratio sucks a lot compared to RPi, but when availability is the most important thing it was our way to go and it runs now for 4-5years without a fail

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [16 January 2023 17:00 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/12 "2023-01-16T17:00:32Z")

</div>

> [@KarolisL](#):
>
> In my case, RPi was shutdown every day for a night

Do you mean it was shutdown by powering off, rather than a controlled shutdown? If so then that is a really bad idea. Having said that, having started using good quality cards a few years ago, I have not had a power fail damage a card. I have had maybe a dozen power fails during that time, with six Pis, so a total of maybe 70 power down events.

---

<div class="post-metadata">

**Author:** ![KarolisL](https://avatars.discourse-cdn.com/v4/letter/k/a4c791/32.png) [@KarolisL](https://discourse.nodered.org/u/KarolisL)\
**Post date:** [16 January 2023 18:10 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/13 "2023-01-16T18:10:37Z")

</div>

> [@Colin](#):
>
> Do you mean it was shutdown by powering off, rather than a controlled shutdown?

Yes exactly. Rpi were installed in electrical cabinets to collect data - so if shift finishes, operators powered off whole line with Rpi inside it.  
I don't remember the brand of SD cards, but my best result was 4months of power offs for everyday ~ (lets say ~120) until SD card was corrupted for single Rpi. I hope you will outperform it 😃

I've noticed more and more blogs about prevention for this issue. In my case this might have been a solution

> **[Read-Only Raspberry Pi - Never Corrupt your Micro-SD Card - Tutorial Australia](https://core-electronics.com.au/guides/read-only-raspberry-pi/)**
>
> Here is a solution so you can turn your Raspberry Pi handheld computer on and off from the power plug (power cycle it) just like any other appliance in your home! And it can all be done through only one setting. 
> With a normally set-up Raspberry Pi,...

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [16 January 2023 18:23 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/14 "2023-01-16T18:23:37Z")

</div>

But that just makes the whole sd-card read-only doesn't it? If so, not much help unless you have another place to write stuff to.

No general purpose computer likes to have its power cut off any any of them can end up with storage corruption if you do. It is simply that devices with more complex storage controllers and more complex filing systems are better at both trying to keep discreet writes, finish writes before power cut and recovering from small corruptions.

A Pi is a bear of simple mind and doesn't have all those features when using an SD-Card.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [16 January 2023 18:31 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/15 "2023-01-16T18:31:55Z")

</div>

It seems to me you should have an ups on the pi’s and do a controlled shutdown.

This might help: [https://www.pishop.us/raspberry-pi-ups-hat-guide/](https://www.pishop.us/raspberry-pi-ups-hat-guide/)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [16 January 2023 19:32 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/16 "2023-01-16T19:32:35Z")

</div>

Yes, a short term 'UPS' (which is a contradiction in terms of course) which has sufficient capacity to allows the pi time to shut down cleanly before turning itself off is ideal for such situations.

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [16 January 2023 20:10 UTC](https://discourse.nodered.org/t/best-platform-for-node-red/10499/17 "2023-01-16T20:10:15Z")

</div>

Well most UPS's are short term aren't they - actually a super capacitor would likely be plenty as long as the power cut trigger was responsive enough. It actually doesn't really even need to do a full shut-down, just stop writing to the card - that would be enough.