I have a central CrateDB instance running with a WINCC OA PLS, where all Data ist stored. I want to connect multible Raspberry Pi PC’s from remote lokation’s which all should have a localy saved Database for the local fielddata.
The connection is established over public WAN, so we have to account short Network downtimes of about 3% per year in total.
What would be the best solution/set up to have the Data mirrored from the local Harddrive(PLC) to the PLS?
Running a local cluster would likely mean to much data for the Raspberry if there to many of them.
Is it possible to run a local instance of CrateDB which is synchronizing its Tables with only the central PLS-Crate-Instance?
Thanks in advance