Migrated to mariaDB long ago but default database keeps getting more efficient. Is it worth unwinding MariaDB? If yes are there any guides to doing so?

I personally rolled back, because I felt an external DB wasn’t worth the hassle anymore. See this thread for pointers [image] Migrating from MySQL (mariaDB) back to sqlite Configuration So about one year ago, my HA install slowed to a crawl and it was related to the sqlit…

I moved back too. The only downside I have is when analysing the db (e.g. statistics values), as for that you need to stop HA first and make a copy to use with dbbrowser. If you donot have this need then … no issues I guess. Even with above, still happy to have moved back as running a separate dbser…

I keep it because when I do backups I really don’t care about the db. And when I do a backup it takes way less time to do the backup without the fairly large db included. Also I save a years worth of backups at a time and it saves a lot on disk space in my storage location. if I ever need to reco…

[image] vingerha: The only downside I have is when analysing the db (e.g. statistics values), as for that you need to stop HA first and make a copy to use with dbbrowser. I don’t bother stopping HA. I just copy off the “live” database file and do my analysis on the copy. Obviously this doesn…

I’m currently running the default SQLite. But I want longer term reporting. Would it be reasonable to keep SQLite and add InfluxDB (as HA add-on), or should I also be thinking about swapping out SQLite for MariaDB in this configg?

MariaDB doesn’t bring anything more in term of functionality

What Chris said, and also consider whether the long term statistics provide good enough long term data. If your sensor is set up properly, state class measurement will generate hourly snapshots of min, max, average. State class total and total_increasing will generate hourly snapshots of state and …

agree. i think long term statistics are not fleshed out enough to be useful for me. I tried migrating db back but ran into errors when I tried entering the password for mariadb. I gave up and just commented out my configuration.yaml entry for recorder: altogether and rebooted the system. No improve…

Actually it does. MariaDB provides full ACID. Thus it’s impossible to make data within it inconsistent (considering that all related data changes are made within single transaction). It also allows consistent backups in runtime. It’s durable. This all cannot be said about sqlite.

[image] maxym: This all cannot be said about sqlite. https://www.sqlite.org/transactional.html

Is MariaDB worth keeping or is it now inferior?

Configuration

koying (Chris B) November 12, 2024, 8:00am 2

I personally rolled back, because I felt an external DB wasn’t worth the hassle anymore. See this thread for pointers