New answers tagged storage
SQL doesn't support database files on SMB prior to 2012. Otherwise it would be possible but not recommended. Your priority should be regular backups of system and user databases, which can be done to an SMB share (best way to do it actually!)
To be honest, I wouldn't want my database on a NAS as it is most likely accessed throughout the office and it is also very vulnerable as everyone connects to it. Ideally, your SQL database should be hidden in the deepest parts of your network. However, I seeing how this doesn't sound like a high end operation, I would see if they can give you the money to ...
NO. Do not attempt to have a single copy of the data with multiple copies of mysqld accessing it. I don't know if that ever worked; if it did, I suspect it has atrophied over the years as changes have been made. Think about it... Each copy of the server has lots of stuff cached in RAM. To coordinate that with other servers would require writing things ...
Top 50 recent answers are included