Re: Is file system based database reliable ?

On Mon, 8 Feb 1999, Tim Kutergin wrote: > Sorry for silly question: how reliable is Informix database implemented as > cooked files? As reliable as any other database implemented on cooked files. > Documentation says that it is less reliable that raw devices, since > database could not guarantee writing to the media - nonsense, there is > fsync(2) system call and O_SYNC flag for open(2). And the o/s doesn't necessarily guarantee that the data is on disk when the write() and/or fsync() calls return. Also, the documentation was probably written before fsync() existed, and certainly before it became widely usable. > At least Oracle did not make such statement. Raw devices in Oracle are > using for enhanced performance and for special environments such as > Parallel Server. IDS is effectively a special environment, then. > I am evaluating IDS usage in Linux environment but I afraid that database > reliability will be low (Linux does not support raw devices). It won't be any worse than any other database on Linux. Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn