Python Forum

Hi All,

Am not from a Programming background, but i need to test something like below and need your support

We have a Gateway running on Linux Ubuntu core from where we are collecting the data and storing it on the cloud which is supported by the software.

The Gateway is connected with a 4G LTE (4G sim) USB Dongle and connected to cloud.
Incase for some reason the connectivity gets disconnected the data logging shouldn't stop, so

1. Need to create a local MariaDB Mysql database for storing the data locally in Gateway hardware when network is down (should detect network is down and start storing it in DB)
2. Once the network is up and working again automatically the stored data in DB along with the current data logging should start copying back again to cloud.

Can someone support on this.
Other suggestions are also welcomed
Thanks.

i'd just store it in the DB always and have a 2nd process extract the data and send it to the cloud and move along once it verifies the data is in the cloud. the 2nd process would keep on trying when the network connection goes down. a 3rd process would delete old data when the disk is nearly full. that way i'd have all the data in case of an accident with the cloud data.