… for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers will run a… MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we…, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
This looks awesome. Would you still want to RAID these for reliability though? Be interesting to see if there’s any drop-off with a pair of these in a RAID 1.
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… on it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a…,000 queries in about 50-60 seconds to mysql 5.1 and in about 6-9 seconds on mariadb 5.5…-14 seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10 for…-queries=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server-5…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… disks in the RAID. This turns out to be the same as the size formulas I gave above: RAID 1+0: is a set of mirrored drives, so the number here is num drives / 2. RAID 5: is…, so the number here is num drives – 1. In our case, it is RAID 1+0 64k stripe with 8 drives. Since those…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… Time : Fri Aug 26 13:51:11 2011 Raid Level : raid5 Used Dev Size : -1 Raid Devices : 6 Total Devices : 5 Persistence : Superblock…[1] sda3[0] 14627723520 blocks super 1.2 level 5, 64k chunk, algorithm 2 [6/5] [UUUUU_] So you can see RAID is….61 TB Current LE 223041 Segments 1 Allocation inherit Read ahead sectors 0 So we have RAID volume back but LVM shows…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… relevant. It was and still is, however, relevant with HDD RAID storage – technology we have been using for many years – when… any variation of them (5+0, 1+0, 1+0+0 etc.). While IO inside the RAID is perfectly aligned to disk sectors… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition…
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
… maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards. In short conclusion, RAID10… CentOS 5.3 with 2.6.18-128.1.10.el5 kernel. For RAID modes I use: single card ( for baseline) RAID0… regular hard drives or SSD disks. The performance drop in RAID settings is unexpected. I am working with Fusion-io engineers…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h for SSD, 4h for HDD RAID… in text form: BP sizeHDD RAIDIntel SSD 910Ratio (i910/raid) 25 GB22816207.1 50 GB55231825.76 75 GB109457295.24 So gain is…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… 34C, isSOHGood= VirtualDev Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0-0) 2 2-2… were run twice – first with RAID controller cache set to Write-Through and then to Write-Back. 1. Baseline – misalignment on the…
Post: How reliable RAID really is
June 30, 2006 By 13 Comments
… running RAID5 using 6GB internal hard drives, which give about 1.4TB of usable space. The problem started than one of… it is much better than loosing everything. Unfortunately neither RAID BIOS nor RAID tools do not provide you with such feature. Happily… few things this case reminds about: Do not assume RAID is Reliable. RAID is more reliable than plain disk, RAID6 is more…
