Re: Filesystem for Linux production database server?

A database running on a single RAID 1 device on a 2 CPU Dell with ext3 on linux
is still faster than a database running on a similarly configured Dell box with
windows 2000, and several RAID 10 devices.

No kidding.

Jared

Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/29/2003 11:14 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc: 
        Subject:        Re: Filesystem for Linux production database server?

Linux file systems usually do not support direct I/O (bypassing the buffer cache), which means that you're going to have double caching with almost everything except raw devices. You can have up to 256 raw devices on a Linux
box and if your database is small enough (32-bit system, 2G limit applies),
that will definitely be the fastest option. My recommendation is to go with
IBM JFS because it is a battle tested, mature, well performing file system. I
would advise against XFS because nobody uses it. As for availability, you'll have to go with some RAID controller and standby
database or RAC. In case of RAC, your choice of file systems is clear (OCFS).
Whatever you do, do not configure your RAID as RAID-5 but RAID 1+0 (BARF).

which means that
On 2003.06.29 11:44, zhu chao wrote:
> Hi, friends that run oracle on linux:
> We are running some database on linux, some with UPS protection and
some
> not, all using ext2. Currently we have a DW server running oracle
817/Redhat
> 7.2/Ext2. When server crash because of power supply, fsck took rather
long
> time!
> And we are planning migrate to redhat as2.1/9.2, and I am thinking
of
> what kind of filesystem shall I choose for the new server. The database
is
> about 150G.I had planned to use ext3 for it is journal filesystem, But
> according to http://www.linuxjournal.com/article.php?sid=5841, ext3 is bad
> for performance, and some friend said he hit filesystem crash with ext3.
> So,what is your experience using filesystem for oracle in linux?
> Performance and avaliability is of most important.
> Thanks.
>
>
> Regards
> zhu chao
> msn:[EMAIL PROTECTED]
> www.cnoug.org
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: zhu chao
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).