May 25, 2012

Post: Testing Fusion-io ioDrive2 Duo

… (1.2TB each), which can be connected together via software RAID. So I tested in two modes: single drive, and software RAID-0 over two drives. I should note that to run … graph I show the results for both single card and raid (Duo). Random writes, async: We see stable and predictable write…

Comment: Testing Intel SSD 520

Curious .. how are people deploying these SSDs on DB servers? Are they behind a regular raid controller? Or using software RAID? Or simply straight up direct /dev/sdx? AD

Post: Benchmarking single-row insert performance on Amazon EC2

… configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL…

Comment: ext4 vs xfs on SSD

… of allocation groups, setting the correct sunit/swidth for the RAID array, or using nobarrier, all have no statistically significant impact…

Comment: FlashCache: first experiments

… files layout: ibdata1 and ib_logfile* are placed on separate RAID partition ( not on FlashCache or SSD)” Why did you exclude…

Comment: Testing Intel SSD 520

AD, Most usage is behind a regular raid controller. LSI 9211, LSI 9260, Dell Perc H800 are popular ones for this case.

Comment: Review of Virident FlashMAX MLC cards

… Platform, not Linux. I think this issue applies to any RAID-0 volume regardless of hardware or software platform. If even one drive in a RAID-0 stripe set is unable to write its portion of…, but that is my experience with Windows software Raid-0. Maybe some raid-0 is smart enough to ignore an incomplete stripe…

Comment: Review of Virident FlashMAX MLC cards

… is a problem including a driver failure, the caveat on RAID-0 is that you end up with a corrupt volume…, even with the protections on the card with parity etc, RAID-0 is not safe because driver errors do occasionally happen… ever lose data. A failure to complete a write on RAID-0 corrupts the volume, even if no prior data was…

Comment: Review of Virident FlashMAX MLC cards

Bob, That’s good information. I am always somewhat hesitant about linux software raid. Even Linux is incredible popular, it feels it is still not mature enough in many areas, including IO.

Post: Percona Toolkit 2.1 with New Online Schema Change Tool

… these tools rapidly, for example, to support new types of RAID controllers. Percona Toolkit is a hot topic at the upcoming…