On Mon, Feb 09, 2004 at 03:13:08PM +1300, Mark Kirkwood wrote: > FYI - Ext3 has 3 modes : > > data=ordered(default) : metadata is journaled (at write time data is > written before metadata - i.e ordered) > data=journal: data and metadata are journaled > data=writeback: metadata journaled (no ordering at write time)
Thanks for that. > The default will not help to protect database integrity if fsync is > false (as only metadata is journaled) > > Will data=journal mode help? I am uncertain. A casual reading if these > definitions suggests that it *might* - anyone know for sure? My problem is that journalling works on a per-file basis. ie, the data for a file is written before that file's metadata. However, the fsync is used for the WAL segments and if you can't guarentee the WAL will hit the disk before the data segments (different files), you're stuffed I think. Or maybe WAL is not that sensitive to that kind of reordering. Maybe it only depends on the WAL being consistant. Hope this helps, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > (... have gone from d-i being barely usable even by its developers > anywhere, to being about 20% done. Sweet. And the last 80% usually takes > 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce
pgp00000.pgp
Description: PGP signature
