… 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…. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is available…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… 50-60 seconds to mysql 5.1 and in about 6-9 seconds on mariadb 5.5, while the galera two… in 11-14 seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10…,200,500,1000,2000 –iterations=10 –number-int-cols=6 –number-char-cols=6 –auto-generate-sql-secondary-indexes=3 –auto-generate…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… : Fri Aug 26 13:51:11 2011 Raid Level : raid5 Used Dev Size : -1 Raid Devices : 6 Total Devices : 5 Persistence : Superblock is… Creation Time : Fri Aug 26 13:51:11 2011 Raid Level : raid5 Raid Devices : 6 Avail Dev Size : 5851089777 (2790.02 GiB 2995… mdadm –verbose –create /dev/md2 –chunk=64 –level=5 –raid-devices=6 /dev/sda3 /dev/sdb3 /dev/sdc3 /dev/sdd3 /dev/sde3…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… Other … # Disk Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | MegaRAID … may be able to fix that (not verified). 6. Added LVM on top of aligned partition table, …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… with HDD RAID storage – technology we have been using for many years – when there’s striping like in RAID0, 5, 6 or any variation of them (5+0, 1+0, 1+0+0 etc.). While IO inside the RAID is perfectly… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition…
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… out there that discuss RAID minutia. Make sure you cover the following: RAID type (usually 5 or 1+0) RAID stripe size BBU… the end of the kernel line: kernel /boot/vmlinuz-2.6.18-53.el5 ro root=LABEL=/ noapic acpi=off rhgb…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… safe write buffering and write merging. Performance is another story. RAID is usually easiest way to get extra performance from your… have to be solved with commodity hardware and commodity people. RAID can be indeed slower than direct disks. For example for…/performance. We use a lot of Dell PowerEdge 2950 with 6 hard drives and 16GB of RAM. With other vendors I…
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…. OS is CentOS 5.3 with 2.6.18-128.1.10.el5 kernel. For RAID modes I use: single card ( for… regular hard drives or SSD disks. The performance drop in RAID settings is unexpected. I am working with Fusion-io engineers…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…caption id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So… 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response… | 3 | 18223 | 0.3784 | | `ssb`.`dim_date` | PRIMARY | 17 | 11 | 6 | 2414 | 0.2075 | | `ssb`.`lineorder` | LO_OrderKey | 17 | 17 | 0…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint… for SSD (note it is single device, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is… price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO – 3.6 TPM / $ Please note that price…
