Running HA Core on an rPi 2 that I keep running 24x7 anyway, very happy with it. I am wanting to hang on to some state and event data long term. I don’t want to keep it in SQLite on the Pi (DB is pretty big, and I have had too many SD cards die on no notice).
I was thinking of moving the recorder database to MariaDB running on one of the Synology NAS I have, but that would require the Synology to keep the disks spinning 24x7 (they spin down when not in use). Don’t want to do that.
I am contemplating writing a script (scheduled via cron) to archive the data I want from SQLite to a separate archive database in MariaDB. Synology would only spin up when the script runs, or when I am analyzing the data.
Before I go to all that work, has anyone else come up with a 2-tier archive scheme already?