This has been a heck of a saga with HA here recently. I noticed my HA was slowing to a crawl and devices were taking forever to update (light turns on 5 minutes after being asked, sensors not updating) so I thought my SD card was failing. New SD card, same problem. Then I thought I was just too overloaded for SD, so upgraded to SSD, still same problem. Now I’m trying changing the DB entirely because I realized that much of this started when I started using Energy Monitor and enabling the record to log all the kWh for that and it was getting well over 2GB. Once I noticed that blowing away the DB sped everything up substantially I knew it was time to try a new DB solution.
So, now that I’ve upgraded to MariaDB (something I’ve actually wanted to do for a while but never got around to it), I’m wondering how I access it remotely and how I back it up. I can see that HA is using MariaDB fine (now, I had to change the db_url config a handful of times until I realized it was core-mariadb as the host rather than homeassistant, homeassistant.local or the IP address) but when I fire up MySQLWorkBench or pypMyAdmin I cannot connect to it.
Is there a trick to connecting to the DB remotely and a trick to back it up automatically each night?
