ext3 data=ordered - good enough for oracle?
Johann Lombardi
johann.lombardi at bull.net
Sun Apr 23 00:15:55 UTC 2006
> Given that the default journaling mode of ext3 (i.e. ordered), does not
> guarantee write ordering after a crash, is this journaling mode safe
> enough to use for a database such as Oracle? If so, how are out of sync
> writes delt with?
Oracle manages its own I/O cache in userspace and handles data coherency related
to that. So data=journal is useless in this case.
I guess databases such as Oracle uses O_SYNC to control the flushing of data
or even O_DIRECT to bypass the kernel cache.
Johann
More information about the Ext3-users
mailing list