… single database / applicaiton. For example for a single database you can achieve higher writes with a SAN… when things crash quickly that is the best situation for failover. When a drive fails in… hardware failure – typically losing a disk. Usually the RAID controller does the right thing though when…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… to buy memory instead, and use the storage device for writes. Here’s the benchmark I came up with to … is when data fits completely in the buffer pool (best performance). It’s important to point out that once… differently. Raw results: Buffer pool, GB FusionIO Intel SSD RAID 10 2 450.3 186.33 80.67 4…
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…database on all slaves which is best done in binary mode for large data sets. Such global recovery… time recovery. Timing recovery is also important. Especially for write intensive environments it may take many days to…
Comment: 5.0.83-build17 Percona binaries
August 4, 2009 By 19 Comments
… xeon X5355 running ubuntu 9.04 with Raid 1 array X25-M and Raid 10 array of 4 x 1….the write delays on large data writes such as repairs, but with a mixed read-write load it happens less frequently. The best … scenario Gabriel is absolutely right and I’d go for a X25-E if you can afford it. Anyway …
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…of this article was not to show the best configuration out where but instead to show …outstanding writes are not lost on the crash. Which outsanding writes ? To the OS device, to the RAID …OS cache for reads and writes. 256MB cache on controller can still potentially skew read results for 2GB …
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… sure its 3) Make sure you use software raid. Raid cards these days are rarely as good as… for the disk configuration in your bios, it vastly improves small file access whether reading or writing, key for …_flush_method=O_DIRECT 9) We get the best results with filepertable. Especially if you find your…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…(R) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space purposes. In… and writes pages from buffer pool (replacing pages in buffer pool). This however allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do…
Comment: Estimating Undo Space needed for LVM Snapshot
June 11, 2008 By 5 Comments
…special circumstances we were running RAID0 on the raids and replicating across machines. On *any* failure we…the best way, but it is the cheapest, and that mattered at that time. Of course for inventory… ~2TB volume for snap. Since during that time of day we have relatively low writes to those tables…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…performance difference not just 5-10% you often see for simple queries due to generally fatter code. The …flush_log_at_trx_commit=2 This is probably best solution. In many cases this would be good …cache unit and make sure you set your RAID cache policy to “write back”. One of the customers I worked…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… group: 2048 Inode blocks per group: 128 RAID stride: 8 RAID stripe width: 80 Flex block group size: … panic. I believe remount-ro is the best option to use for the database server, though panic might … needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes …
