Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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!

share|improve this question

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
    
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. –  samsmith 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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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