… happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…; it is not unheard of for a monitoring agent or RAID utility software to do this. The pmp-check-unix-memory…
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… 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: How reliable RAID really is
June 30, 2006 By 13 Comments
… guess it should be interested to many MySQL DBAs and other people involved running MySQL In production. Recently I’ve been involved… it is much better than loosing everything. Unfortunately neither RAID BIOS nor RAID tools do not provide you with such feature. Happily… chance some data is corrupted so checking file system and MySQL database is good idea. So my story had a happy…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some… should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads… to ease hardware evaluation for things which are important for MySQL. To prepare small 128MB single file working set we can…
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… as far as I remember uses decent servers with RAID for their MySQL installations. I surely agree with Jeremy on Commodity does… former depends on your application quite a lot. I think MySQL is pretty well supported by matching hardware these days. As…
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… Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h for SSD, 4h for HDD RAID, but the result…
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… performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 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…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… it, other people from MySQL Community too. The situation did not get better, at least not with Dell RAID controllers, H700 and… Dell product line ? (Which is using LSI chips) Are there RAID controllers which do not have this problem ? For many installations… done without server restart with Innodb Plugin, Percona Server and MySQL 5.5. Note it might also be good to increase…
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… IO-bound workload on all devices. For tests I used MySQL 5.4/InnoDB, and all other parameters are the same… for SSD (note it is single device, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is…
