…, however, relevant with HDD RAID storage – technology we have been using for many years – when there’s … volume. This let’s you avoid any mistakes when working on partition table. RAID stripe Further down below on … using an offset, what stripe size and how many stripe elements. It’s easy to check …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… Paul Tuckfield saying “You should ask how many disks they have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY… same partition as well because this makes it very easy to use LVM for backups while assuming you have BBU on the raid volume impact on…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…RAID setup running conventional HDDs. RAID setup For the sake of simplicity you create one single RAID logical volume…how many sectors fit in a RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql partition…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
…RAID volume over many EBS volumes, you are more likely to be affected by this, because the more EBS volumes…on EC2 machines and EBS RAID volumes under the hood. I have no inside information to share on that speculation, but for…partitioning so all the inserts go into one partition…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…RAID…partition size which was slightly over 1TB in size. When I added LVM on top however, I made the logical volume…MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
…RAID here. For many workloads you would like to get RAID just for the sake of BBU. As Jeremy mentioned RAID…RAID available which is used for OS hard drive. Indeed using RAID for OS partition (software) is what we use even for…RAID for their MySQL installations. I surely agree with Jeremy on…volume…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…. So how can …) Filesystem volume name: Last mounted on: … 128 RAID stride: 8 RAID stripe …for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this partition…on startup which is normally done once per so many mounts or so many days. Large partitions with many…
