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)



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. – Jonesome Reinstate Monica Mar 6 '11 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. – Michael Dillon Mar 6 '11 at 5:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.