Re: ATA disks and DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi there,

Aren't you able to turn write-bacl off (thus enabling write-though) by using
hdparm?

[]s, Fernando Lozano


> Frank Warnke wrote:
> 
> > Could you elaborate on why "IDE disk/controllers and journal fs are not
> > recommended for DB usage"?  Does "DB" mean database?  Does this blanket
> > statement cover ATA RAID controllers as well?  Is this a performance
> > issue or a data loss issue? 
> 
> yes.
> yes, DB = data base.
> yes, it covers ATA RAID controllers.
> it's a data loss issue.
> 
> main problems:
> ATA disks _manufacturers_ enable write-back-caching
> and
> ATA disks allow to reorder the operations in write-back-cache
> 
> There a lot of literature about that:
> http://sr5tech.com/write_back_cache_experiments.htm
> http://sr5tech.com/download/ATA_RAID5_Whitepaper.pdf
> http://archives.postgresql.org/pgsql-admin/2000-12/msg00094.php
> http://redhat.com/archives/fedora-test-list/2003-November/msg01447.html
> http://redhat.com/archives/fedora-test-list/2003-December/msg00001.html
> http://marc.theaimsgroup.com/?t=104991701200010&r=1&w=2
> http://marc.theaimsgroup.com/?t=107014526000001&r=2&w=2
> http://marc.theaimsgroup.com/?l=linux-kernel&m=106745860511194&w=2
> 
> > I also have over 40 servers in the field using either Dell(LSI) or 3ware
> > PATA/SATA hardware RAID controllers (RAID5) running databases on
> > ReiserFS and EXT3 filesystems.  Many have seen close to two years of
> > service and they have been problem free.  Our customers are very pleased
> > with the performance of the database access.
> 
> if you did not have any problem, it doesn't guarantee that it can not
> happen
> 
> > People, including myself, come here to learn and when we can, add our
> > experiences.  Please be careful with your opinions, there are a lot of
> > people viewing this list because they assume you have the answers based
> > on experience.  It would help a viewer of this thread to see a reference
> > or two to substantiate your claim.  If I have done a customer a
> > disservice in the configuration of their servers, I want to remedy it
> > immediately.
> 
> Those are no personal opinions, they are real facts.
> My opinions are mine, if you don't like them you are free to delete the
> e-mail and forget it :-)
> 
> 
> --
> fedora-list mailing list
> fedora-list@xxxxxxxxxx
> To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list




[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux