… some cases and more work for the RAID controller for that same operation. In practice stripes by default are bigger in size… decides how to distribute writes properly so they make the best use of the underlying storage, it also makes sure file… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition…
Comment: MySQL performance on EC2/EBS versus RDS
August 16, 2011 By 10 Comments
I am not sure where the page is located, but Amazon’s suggested best practice for database servers is RAID-10 over EBS, and this is apparently what RDS is built on. The client for whom these benchmarks were run uses this as their standard setup.
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…or cost savings are worth it. Another good RAID question is if Hot Spare should be used….(on other regular interval) rather than finding different best configuration each week. Having spare servers also means…but it is not that frequently seen in practice. To avoid multiple servers failing at the same…
Comment: Spreading .ibd files across multiple disks; the optimization that isn't
December 25, 2010 By 22 Comments
… whit that that a well tuned wide RAID array is going to be the best way to deploy my IOPS to meet…, hours really) It is impossible at any practical price point for me to deploy a RAID array that gives me “enough” IOPS… “general case” workload with unpredictable characteristics, one big raid 10 array is the best “default” choice, but once you understand your IO…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… have master data lost, such as you have RAID or disk failure. Though it also can be …timely fashion over long distance network, meaning it is best to have local backup (and delayed slave if … Interesting enough very few people have their data recovery practices ironed out so they can answer how they …
Comment: Evaluating IO subsystem performance for MySQL Needs
March 29, 2008 By 23 Comments
… the spindles to the OS one-by-one (or in RAID-1 pairs striped with MD/LVM), you’re having cfq… reads/writes to the disk within one I/O queue, practically guaranteeing only a maximum of two, perhaps three of your… the RAID (and BBU cache in the case of writes) in random order, letting it utilize all spindles to their best effect…
Post: Why you don't want to shard.
August 6, 2009 By 33 Comments
… the IO system can be improved with a RAID 10 controller w/battery backed write cache, the…Sharding Partitioning by Application Function – This is usually the best way to fix any of the problems mentioned … it will equally distribute the data equally. In practice this method can be really hard to get…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… we will also tell you what we think is best for you, which is our job). After the …of memory with 17g virtual size, and there’s practically nothing else running (this is a dedicated master server…lot of information on the box’s hardware, including RAID controllers, installed memory, and so on in the …
