Hi all, am heavily considering switching to an external Mysql DB instance due to problems with the H2 database datapoints getting corrupted (causes http 500 errors just from trying to load datasources) from time to time. That and the fact I want some means of redundancy for datapoint values being stored - would rather not keep all my eggs in one basket and backing up files won't be enough for me.
As I'm doing my research however, I'm a bit conflicted due to the possible large database size in the mid to long term. Not so much in the order of TB's (more likely several hundred GB's) but how the size will impact speed in mangoUI also.
IMO having mysql provides a bit more freedom in replicating data because of the structured format - it's consistent. And that I could utilise external MySQL servers for redundancy.
I'd like to know what others have found to ensure data is consistent and up to date should they have a server fault or anything unexpected comes up and throws everything out of kilter.