I strongly suspect the answer is "no" but here is the question:
Is it OK to have one or more of the Mongodb data files compressed by Windows File System Compression?
(With SQL Server, this is a no no... but I am newer to mongodb)
TIA!
asked Mar 3, 2011 at 0:56
Jonesome Reinstate MonicaJonesome Reinstate Monica
5,51511 gold badges57 silver badges84 bronze badges
Add a comment
|
1 Answer
That's not entirely true about SQL Server. You could use NTFS compression but you have to accept a risk of log file corruption if the system fails while NTFS compression rewrites a sector. Check this Microsoft article for details.
Mongodb would not necessarily be any different. There is an increased risk but that would only be material in very large, high volume systems.
If you want to use filesystem compression, it would be better to use an OS and a filesystem where database servers are supported. Namely, Solaris and ZFS. You have a choice of either Oracle Solaris 11 Express which is supported by Oracle, or a system built on Illumos (formerly OpenSolaris) such as Nexenta.
-
This server will be a windows server.... the only question is whether we will be able to use ntfs compression.... Your response is nice, but is a tad off topic. Mar 6, 2011 at 4:36
-
Other people faced with this question might decide that attaching iSCSI volumes from a SAN that supports compression, to the Windows server, would be a much better way to use NTFS and get the advantages of compression as well. No need to make one machine do everything. And if your setup has a means to replicate transactions onto two Mongodb servers you will find that the risk of NTFS corruption is greatly reduced. Mar 6, 2011 at 5:18