ext3 data journaling

16/10/2008 - 05:02 von Rick DeBay | Report spam
I'm installing Suse 11 for a database server, and need to set up the data file
system to be as reliable as possible.
It's going to be ext3 mounted with the sync flag. I was looking at the
journaling options, and was wondering if journaling the data was worth it. From
a data safety perspective, the data is on the disk whether it writes it to the
data journal or directly to the file. While a partial write to a file would
normally cause problems, in a transactional database the incomplete writes would
just be rolled back.
I can see a performance advantage if the journal is on different hardware, so as
to handle burst conditions.
Am I missing something? Does anyone have any recommendations?

Thanks, Rick DeBay
 

Lesen sie die antworten

#1 Ansgar Strickerschmidt
16/10/2008 - 08:48 | Warnen spam
Am 16.10.2008, 05:02 Uhr, schrieb Rick DeBay :

I'm installing Suse 11 for a database server, and need to set up the
data file
system to be as reliable as possible.
It's going to be ext3 mounted with the sync flag. I was looking at the
journaling options, and was wondering if journaling the data was worth
it. From
a data safety perspective, the data is on the disk whether it writes it
to the
data journal or directly to the file. While a partial write to a file
would
normally cause problems, in a transactional database the incomplete
writes would
just be rolled back.
I can see a performance advantage if the journal is on different
hardware, so as
to handle burst conditions.
Am I missing something? Does anyone have any recommendations?



The main advantage of journalling is the possibility to bring the
filesystem into a consistent state without the need for an extensive
consistency check after a crash. This does not mean that loss of data
(especially those held in the various write caches during the crash) can
be reliably prevented in any case. However, it increases convenience and
adds a bit of security margin at little tradeoff.
For your purpose, you should strongly consider the use of a RAID system,
plus an adequate backup strategy.

Ansgar

Mails an die angegebene Adresse erreichen mich - oder auch nicht.
Nützliche Adresse gibt's bei Bedarf!
Mail to the given address may or may not reach me - useful address will be
given when required!

Ähnliche fragen