Wlad These SSD reviews of yours are just superb. My favourite on the MySQL Performace blog! You can also do a review on the best available hardware raid-sets and give your advise.
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… say you have a server with standard hardware RAID setup running conventional HDDs. RAID setup For the sake of simplicity you create… RAID logical volume that covers all your available drives. This is the easiest setup to configure and maintain and is the best… out there that discuss RAID minutia. Make sure you cover the following: RAID type (usually 5 or 1+0) RAID stripe size BBU…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… relevant. It was and still is, however, relevant with HDD RAID storage – technology we have been using for many years – when… decides how to distribute writes properly so they make the best use of the underlying storage, it also makes sure file… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…Other … # Disk Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | MegaRAID … mounting but not during mkfs. This is your best option if you have a proper alignment in …
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… performance gains or cost savings are worth it. Another good RAID question is if Hot Spare should be used. I normally… add a lot to high availability – if you have proper RAID monitoring in place and keep couple of spare hard drives… reviewed yearly (on other regular interval) rather than finding different best configuration each week. Having spare servers also means you often…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… – can SAN have some very smart software instead of simple RAID you use with directly attach storage which can magically improve… server with multiple power supplies ECC memory kill-chip and RAID is more reliable than without these technologies but I always… something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication is…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…) Xeon(R) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space… in buffer pool). This however allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do measurements every 10 sec to see…
Comment: Spreading .ibd files across multiple disks; the optimization that isn't
December 25, 2010 By 22 Comments
… whit that that a well tuned wide RAID array is going to be the best way to deploy my IOPS to meet… at any practical price point for me to deploy a RAID array that gives me “enough” IOPS to satisfy group #1… “general case” workload with unpredictable characteristics, one big raid 10 array is the best “default” choice, but once you understand your IO…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… different reason. If you’re using RAID10 – most commonly used RAID level for write intensive database systems, you will have 2 hard drives to pick reading any block. RAID controller (and even software RAID driver) typically tracks disk head position so it… difference – This is a lot, but remember this was the best case. Typically you will not be able to get over…
Comment: Death match! EBS versus SSD price, performance, and QoS
February 22, 2011 By 54 Comments
… in all the testing I’ve done – even for RAID 0. Hardware RAID makes assumptions about the minimum amount of time that…. I’ve tested Adaptec, LSI, 3ware, Highpoint and software RAID. Software RAID performs best for all SSD that I’ve tested, even the…
