June 19, 2013

Comment: Why delayed flushing can result in less work

It might also matter in the case where you pay for your IOOPs. Which would be true with something like an attached Amazon EBS storage.

Comment: EC2/EBS single and RAID volumes IO benchmark

Has the recent outage on Amazon/EBS made you reconsider RAID0? Supposedly some volumes were complete lost. Others had reachability problems throughout the day. I assume using SW RAID1/10 could have saved some of these situations.

Comment: MySQL performance on EC2/EBS versus RDS

… is not much performance difference between RAID0 and RAID10 on EBS. http://www.mysqlperformanceblog.com/2009/08/06/ec2ebs-single-and… us, and not really answered definitely by Amazon, is exactly what level of reliability EBS offers with respect to durability, partial page… say that RAID0 is okay. It doesn’t help that Amazon says mirroring will “not significantly” improve durability. That kind of…

Post: Minimizing Downtime from Lengthy AWS Outages

… the impact to your application.  AWS Infrastructure (High Level) The Amazon Web Services infrastructure contains several individual components that can be combined to create a highly available architecture.  While Amazon claims that issues in a single Availability Zone should have… instance and simply fire up MySQL.  This works wonderfully unless EBS is the component experiencing the issue.  In this case, having…

Comment: Death match! EBS versus SSD price, performance, and QoS

… running on the system. At that point, the benefit of EBS[less contention vs the ephermeral drives] is reversed as suddenly…-verify. None of this is rocket science, it’s what Amazon itself designed their system to do before they started selling… in a single database. The other path to take is Amazons, buy the physical hardware you need for peak performance, stick…

Comment: Death match! EBS versus SSD price, performance, and QoS

… easier to run MySQL on local storage in EC2? Is Amazon or Rackspace interested in sponsoring such projects? If you can… storage, use XtraBackup to store backups on EBS and archive the binlog in realtime on EBS. When the master fails setup a…

Comment: Death match! EBS versus SSD price, performance, and QoS

Peter, I’m not sure if the poor EBS performance is a wiring problem. On a switched network with …. That said, I’ve no particular knowledge of how amazon implemented EBS, so I don’t have an alternate theory as to…

Comment: Disaster: LVM Performance in Snapshot Mode

… working on operating MySQL on Amazon and should be doing some performance analysis of Elastic Block Store (EBS), which–you guessed it… cases. In this case our comparison would need to be EBS vs. local file systems, which so far as I know…

Comment: Death match! EBS versus SSD price, performance, and QoS

… depreciation. Note: anything which runs on a large instance in Amazon day in and day out, in my mind is something that ought to be looked into moving outside of Amazon and on to physical hardware. However, for a swiftly growing… the instance and attach RAID to them, move off of EBS and do a cost analysis of losing an hours worth…

Comment: MySQL performance on EC2/EBS versus RDS

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.