Hi, I recently installed MariaDB on a Buffalo NAS (LS-720D) so instances of Kodi on different devices can share the same library db. It took a fair amount of fiddling, but I got it working with Kodi
It occurred to me later that because of the way I installed and configured MariaDB, the database itself is being stored in the Buffalo OS boot disk (which I think is probably some kind of flash storage, but don't really know so pls correct me if wrong!) and not on the NAS disks/RAID array. For some reason that seemed like a bad idea so I got a mount created on the array to be MariaDB's new default location for databases, and was just about to reconfigure it to point to the new path instead... and only then did it occur to me that maybe leaving it on the OS disk is not a bad idea. It appears to have a capactity of 4gb and with the database fully populated, the disk still has 70% free space due to the lightweight Linux OS
My thoughts are that I wonder if the OS disk was not designed to be accessed a lot since the Buffalo firmware seems simple enough to mostly boot and reside in memory. So should I worry about a mysql database being out of spec for the onboard storage? If it wears out the OS disk in a couple years, the device is bricked. But on the other hand maybe that's crazy talk/not even a thing, and since the HDD array isn't all that fast, maybe the flash storage is actually better for a database..? Thought y'all might have some opinions on this