… 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
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 … : Fri Aug 26 13:51:11 2011 Raid Level : raid5 Used Dev Size : -1 Raid Devices : 6 Total Devices : 5 Persistence : Superblock… Creation Time : Fri Aug 26 13:51:11 2011 Raid Level : raid5 Raid Devices : 6 Avail Dev Size : 5851089777 (2790.02 GiB…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… about death of the RAID. I think this is far from the case especially if you consider Software RAID here. For many workloads you would like to get RAID just for the sake of BBU. As Jeremy mentioned RAID is… as far as I remember uses decent servers with RAID for their MySQL installations. I surely agree with Jeremy on Commodity does…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of SAN backup, intensive activity… with operating system and other system software involved. In could be even system which queries mysql. I’ve seen monitoring updates which…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… as device in your OS, so you can easily make software RAID from several volumes. So I created 4 volumes ( I used… 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: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
… above – 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…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… 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 plugin…
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 8, 2010 By 20 Comments
… MySQL systems. They tried several configurations (usually 4 drives, they tried hardware RAID, software RAID, RAID 1+0 and RAID 0), but in all cases the RAID controller or software couldn’t predict when the…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO…. The next possible advantage is software – can SAN have some very smart software instead of simple RAID you use with directly attach storage…
Post: How reliable RAID really is
June 30, 2006 By 11 Comments
…should be interested to many MySQL DBAs and other people involved running MySQL In production. Recently I’… better than loosing everything. Unfortunately neither RAID BIOS nor RAID tools do not provide you with such…data. This is of course not to mention software bugs and user errors which are other …
