… EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I… THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent connections writing to the table, with…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the … 26 13:51:11 2011 Raid Level : raid5 Used Dev Size : -1 Raid Devices : 6 Total Devices : 5 Persistence : Superblock is persistent Update… /dev/md2 mdadm –verbose –create /dev/md2 –chunk=64 –level=5 –raid-devices=6 /dev/sda3 /dev/sdb3 /dev/sdc3 /dev/sdd3…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… point mysql‘s tmpdir elsewhere) Everything else for MySQL (/mnt/data or similar): (sym-link /var/lib/mysql into here when you setup mysql… sectors fit in a RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql partition from fdisk: 27344896… gave above: RAID 1+0: is a set of mirrored drives, so the number here is num drives / 2. RAID 5: is striped…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 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… misalignment on the file system, you can see how RAID ends up doing 5 IO operations – two to D4 and one on…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… … # Disk Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | …Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
… its impact to MySQL Performance. Here are couple … Enabled ——————————————————– Controller Version Information ——————————————————– BIOS : 5.2-0 (18252) Firmware : 5.2-… device name : RAID10-A RAID level : 10 Status of logical …
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
…” RAID 10 16000 88 178 167 97 2777 1630 9’31” RAID 5 16000 88 232 124 99 330 1359 10’28” RAID 5, LVM… some overhead, but really can be neglected. Even RAID 5 has better performance compared to RAID 10 (see sequential output block)!!! iozone gives… finally chose RAID 5 + LVM for MySQL server. I chose RAID 5 instead of RAID 10 since I didn’t see much gain from RAID 10 in…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… showing benchmark results on Amazon EC2 servers with RAID‘ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t… to outstrip RDS 5.1′s performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get better performance with Percona Server 5.1…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…(R) Xeon(R) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space purposes. In this configuration using 600GB disk, we can get 5… I use Percona Server 5.5.19. I should mention that on these datasizes, sysbench workload is pretty nasty, MySQL will mostly reads…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… steps: mdadm -v –create /dev/md0 –chunk=256 –level=raid1 –raid-devices=2 /dev/sdj /dev/sdk mdadm -v –create /dev… EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not show benefits comparing with others, and… get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small problem…
