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?
Bandwidth, basically.
Database replication is more chatty than a purpose-designed change-of-state protocol like MQTT.
Coincidentally, I was ask develop database replication using MQTT. That is check if there is any changes on the source table and send mqtt message.
Quick googling says I can use CDC, change data capture, of database.
Any thoughts?
– The truth to the matter:
i was on the meeting, and said, Phil, mentioned we can save bandwidth using MQTT.
Then say: “We use MQTT to replicate then.”
– i hope this was a fact. pun intended.
MQTT was invented for Data Centres to synchronise with each other. Its use case isn’t limited to Edge Nodes.
Right, in the end, it all just data being sent anyway.
I will look at database CDC, if this is an option.