Hi all - some time back I changed HA over to use MariaDB, which has been successful except that the disk I/O promptly trashed the (older) SD card I was using - within a month or so. (I have some Zooz motion sensors that generate a fairly quick pace of state changes.)
I got a more robust SD card but I would really like to see if I can move the majority of disk I/O off the Pi entirely. So I have two ideas I’d like to explore and I want to see if anyone has experience with these, or just opinions:
- Use the MEMORY engine in MariaDB. All state history will be lost on restart but I’m probably fine with that. Should be really fast and avoid a lot of disk I/O.
- Use Amazon Aurora, which is MySQL compatible (supposedly) and for this size and transaction volume will be essentially free.
Any thoughts??