Hi all,
Im in the process of moving my HA over from a Raspberry Pi 3 to my Synology NAS - everything looks good so far… I do have 1 question around my recorder database:
In order for me not to corrupt the SD Card in the RPI I have been running MariaDB (on NAS) as my Recorder database… Now that I have moved HA to the same NAS, are there any benefits of still using MariaDB, or does it make sense to just switch to the SQLite database?
MariaDB is faster
A long time ago running an external DB like MariaDB was faster and better for HA performance and viewing history. However, over the years many improvements have been made to both the DB and the calls to the DB such that there’s virtually no difference in performance between SQLite and an external SQL DB. The other benefit of an external DB was reducing the wear on an SD card of an RPi. If you already have HA linked to an external DB, I would just leave it that way instead of trying to revert or transition back to a SQLite DB. You don’t have to reconfigure it and you get to keep all of your history.
Yes in inclined to agree with you.
I suppose another benefits is that I can backup the HA folder without working about the db for being locked, and as such get a full backup without stopping the HA container? Mariadb is backed up separately already.
That’s exactly what I do. Backup the mapped folder using Synology hyper backup as the HA configuration is more critical. I handle the DB backup separately but I don’t care too much about it.