Subject Re: [firebird-support] Re: Database corruption (again) or what is wrong with Firebird.
Author Milan Babuskov
marrtins_dqdp wrote:
>> of the power failure or system crash (kernel crash). Ext3 is almost
>> unbreakable, even with forced writes off (because of the way it writes
>> data to the disk). Even better alternative would be to skip the
>> filesystem completely and use the raw partition (but that has some
>
> Is there similar issues using Firebird on JFS too?

Default setup of JFS has the same problem XFS and ReiserFS have. In
fact, only ReiserFS and Ext3 can be configured to be completely
power-failure resistant, but Ext3 has a special mode which offers much
better balance between speed and safety, and (what's most important)
it's ON by default.

More (how? why? and what to do?) details in my "Firebird on Linux" paper
after the FB Conference... I woudn't want to copy/paste it here as
nobody would attend my session then ;)

In short: either use ext3 or trust your UPS + backup strategy.

--
Milan Babuskov
http://www.guacosoft.com