On Sun, Jul 06, 2003 at 10:10:22PM -0600, Jim McAtee wrote: > Jim McAtee wrote: > > > David Lloyd wrote: > > > > > > What would be the ideal RAID configuration for a dedicated MySQL db > > > > server running on FreeBSD? > > > > > > > > We're also running some MySQL databases on Windows 2000 Servers. What > > > > about the best configuration for a dedicated W2k server running MySQL? > > > > > > That depends on what your definition of "optimal" is... > > > > Start with performance and work from there. > > I should add one assumption: The RAID array where the data resides must offer > some degree of fault tolerance. At least to the degree of being able to > survive a single disk failure within the array.
Pure performance: RAID-0 Performace + Redundancy: RAID-10 RAID-5 is a bit cheaper but the performance isn't quite as good as 10. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 10 days, processed 317,523,869 queries (342/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
