… – you can’t change the disks either. Both software RAID striping the internal disks on an extra large EC2 instance… volumes is still going to be slower than a good RAID 10 controller with a battery backed write cache. If you can…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end… R900 with 16 cores, FusionIO as storage for table and RAID 10 with BBU as storage for innodb log files, innodb system…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… Block RAID 10, LVM 16000 83 173 120 101 1670 1629 9’42” RAID 10 16000 88 178 167 97 2777 1630 9’31” RAID 5 16000 88 232 124 99 330 1359 10’28” RAID 5… 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: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… story. RAID is usually easiest way to get extra performance from your IO subsystem. Spreading the database among say 10 commodity boxes… as far as I remember uses decent servers with RAID for their MySQL installations. I surely agree with Jeremy on Commodity does… 10-14 hard drives. Both solutions have comparable price/performance, though former depends on your application quite a lot. I think MySQL…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you could also point mysql‘s tmpdir elsewhere) Everything else for MySQL (/mnt… want to use mysql on /dev/sda3, but how can we ensure that it is aligned with the RAID stripes? It takes… sectors fit in a RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql partition from fdisk: 27344896…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… here http://www.mythtv.org/wiki/RAID) mdadm -C /dev/md0 –chunk=256 -n 4 -l 10 -p f2 /dev/sdj /dev… EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not show benefits comparing with others, and… 4 – 10 volumes. And of course to get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…/07/intel-ssd-910-in-tpcc-mysql-benchmark/. Now I want to test this card against RAID over spinning disks. Benchmark date…. Intel SSD 910 (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5… Results There is a jitter graph of Throughput taken every 10 sec: I put number of median throughput, so we can…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… showing benchmark results on Amazon EC2 servers with RAID‘ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn…’s performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
….02 sec) Each year has tens of millions of flights: mysql> select count(*) from ontime_one.ontime_fact; +———–+ | count(*) | +———–+ | 135125787 | +———–+ 1… 7200rpm RAID10 battery backed RAID array was used as the underlying storage for the virtual machines. Baseline: The MySQL command line client… ontime_fact JOIN dim_date using (date_id) WHERE DepDelay>10 AND Year BETWEEN 2000 AND 2008 GROUP BY DayOfWeek ORDER…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…= $fields[2]; $PUBDNS = $fields[3]; $STATUS = $fields[5]; $START = $fields[10]; print “$SecGroup|$IPAdd|$Instance_ID|$AMI_ID|$PUBDNS|$STATUS|$START… by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has an automatic startup script controlled by… but Pacemaker will not manager MySQL, just the host running it. I’ll also skip the raid configuration of multiple EBS volumes…
