Hello!! I would like develop something but i dont have idea What could be the right way. I am collenting data in a local network with vps and writing in a csv. Now, I would like send that data to Mysql in VPS at same time BUT if I lose the Internet connection I lose the data during that period. H…

The "proper" professional way to do it is with a Message Queue system (not lightweight MQTT but a full enterprise version) such as that from Mulesoft. But that is heavyweight for sure. It would run on your local network. Otherwise you have to build your own queueing system. How up-to-date do you ne…

+1 for node-red-contrib-queue-gate. The example "Retain until processed" on the node's readme shows exactly how to use it for situations such as you describe. It can even retain the queue over a node-red restart if that is required.

Wow, I dint know abut this node, I just to do a small test and looks really interesing for my aplication. Really apreciate!

My idea is continue writing on csv and send the data to VPS Mysql each 30 secs, for example... I understand completly What you mean about csv and move the data to DONE, but been honest, I dont have idea about how do it...

What is wrong with using the queue-gate node?

Nothing wrong, I only have madre one test and looks so good. I only want have other possibility in my hand in other to compare and learn, of course. Many Thanks!

First thing to think about - does it really matter if you lose some data? What difference will it actually make to you? If it is commercial data, OK. But if it is home automation data, so what? Also, how often do you lose your Internet connection? Connecting to a remote DB every 30 sec is quite fas…

Node-RED

Node-RED Forum

Asure write in Mysql VPS if connection loss

General

dceejay 12 September 2020 06:43 3

Also this node [ANNOUNCE] node-red-contrib-queue-gate may be useful.

Topic		Replies	Views
How to queue / hold the sensor values ,when there is a internet failure occurs General	16	2142	14 September 2020
Saving a CSV file on another Computer using Node Red General	5	752	21 March 2022
Read data to buffer and write it to mysql General	2	587	29 September 2021
MySQL node has queue? General	7	202	12 January 2024
MQTT data loss at reconnection General	19	3364	6 October 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Asure write in Mysql VPS if connection loss

Related topics