Which hardware storage option, when set up with redundant disks, offers the least stability,
availability, and reliability for Mysql data?
A.
RAID 5
B.
iSCSI
C.
SAN (Storage Area Network)
D.
NFS (Networked File System)
Explanation:
Which hardware storage option, when set up with redundant disks, offers the least stability,
availability, and reliability for Mysql data?
Which hardware storage option, when set up with redundant disks, offers the least stability,
availability, and reliability for Mysql data?
A.
RAID 5
B.
iSCSI
C.
SAN (Storage Area Network)
D.
NFS (Networked File System)
Explanation:
C. SAN
Effective MySQL Backup and recovery.
Hardware Considerations
D is correct Because:
If reliability is a consideration for your data, do not configure InnoDB to use data files or log files on NFS volumes.
Potential problems vary according to OS and version of NFS, and include such issues as lack of protection from conflicting writes, and limitations on maximum file sizes.
Even when the preceding precautions are observed, this kind of setup works only with MyISAM and MERGE tables, and not with any of the other storage engines.
Also, this warning against sharing a data directory among servers always applies in an NFS environment.
Permitting multiple MySQL servers to access a common data directory over NFS is a very bad idea.
The primary problem is that NFS is the speed bottleneck. It is not meant for such use.
Another risk with NFS is that you must devise a way to ensure that two or more servers do not interfere with each other.
Usually NFS file locking is handled by the lockd daemon, but at the moment there is no platform that performs locking 100% reliably in every situation.
It is not a good idea to configure InnoDB to use data files or log files on NFS volumes. Otherwise, the files might be locked by other processes and become unavailable for use by MySQL.
Do not put MySQL tables on an NFS-mounted volume.
NFS uses a message-passing protocol to write to files, which could cause data inconsistency if network messages are lost or received out of order.
I think D
SAN is the best choice for stability, availability and reliability
Which is the good answer?
A (least)
D.
NFS (Networked File System)
offers the “least” stability,
availability, and reliability for Mysql data?
iSCSI better nfs!
Definitely NFS – NFS is a remote mountable file system so it has every failure point of the native file system plus the vulnerability of a networking or connectivity issue making it fail. All the others are locally mounted except for SAN, which is specifically designed to provide additional reliability over the network.
D
Many issue for “Using NFS with MySQL”
https://dev.mysql.com/doc/refman/5.6/en/disk-issues.html
D
https://dev.mysql.com/doc/refman/5.6/en/disk-issues.html