Really, just a thought and thinking out loud.
If database replication were already a thing, and very mature.
Why do many of the architectures use MQTT to send data to cloud for analysis, why not use database to store data on site and replicate it to the cloud?