My Buffalo HD-LX2TU3 comes with NTFS pre-formatted. Because I have Linux and Windows PC, and maybe a OSX later, I decide to use ext4 to minimize invalid characters in filenames. : ” \ / * ? < > | are not allowed in Windows NTFS but only / in ext4 and : in OSX.
When trying to improve ZurmoCRM performance on NAS, I have separate PHP programs and MySQL running on different machine. It is a good idea to run MySQL with RAID 1 to protect data from hardware failure.
I also explain how to harden your NAS to protect MySQL service from remote connection.
In the last 8 month I have invest 9 different NAS. At first, I want to protect my files from hardware failure. Then quickly change to have both RAID 1 and version archive. Eventually, my requirement becomes a server appliance to backup and run my LAMP applications.
I review my investment and design the PSP framework which stands for Protection, Scenario, and Performance to help choosing a right NAS.